Database Development

SQL Server Development (T-SQL)


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


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


T-SQL: NVARCHAR(255) vs. NVARCHAR(MAX) Disk Space Comparison

In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]