Peter Lalovsky


T-SQL: Change Tracking – What is this and how it works

Change tracking was introduced in SQL Server 2008. This is a tool that keeps the fact that there are changes in tracked tables for a specified period of time. It doesn’t show what the changes are, it tells that a data has been changed. It answers if a change has been […]


Training: The Paperback version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics is on Amazon

Hi Intuitive Learners, One year ago the Kindle version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics was published on Amazon. Now the paperback version of the book is available on Amazon and you can take a quick look at it here. You can contact us all the […]


T-SQL: (Migration) Export the definition of Stored Procedures

Very often we need to bulk export database objects and move them to another server. Manually we do this by right click on the database –> Tasks –> Generate Scripts… In this example I show how we can export Stored Procedures with T-SQL and SQLCMD. This model gives us the […]


Training: The Kindle version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics is on Amazon

As of today, after a one year and a half long process of writing and preparing, the book that gives you the solid basics in Transact-SQL Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics is now on Amazon in Kindle format. Select your market: USA Canada Great Britain Australia […]