SQL Server

SQL Server


SSIS: Check for Errors in SSISDB and Send Email

SSISDB is the database that is collaborating with SSIS. When we execute a package, the execution information is logged in SSISDB. If a job is scheduled, we need to know if there are errors in the executions. As a last step in SSIS package, I run stored procedure that searches […]


T-SQL: Change Tracking Retention Period – What do we have after it expires

In the last posts we played with Change Tracking (CT): T-SQL: Change Tracking – What is this and how it works T-SQL: Change Tracking Retention Period – How Long the Changes are Kept? Let’s execute few queries and see what do we have after the retention period expires.


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 […]