SQL Server Integration Services 2016 Control Flow Templates Introduction At the time of writing, SQL Server 2016 preview (CTP 3.0) has been released. One of the exciting new features of SQL Server Integration Services (SSIS) is that you are able to define templates for the control flow. These templates can be added to regular SSIS packages to enable quick and efficient re-use. This tip will introduce you to this new feature.
SQL Server Cursor Example In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors? I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient mann
Improving the DBA’s Quality of Life with SQL Sentry As the person responsible for your organization’s databases, have you ever struggled with late nights and lots of stress fighting fires, or the anxiety of troubleshooting performance problems while annoyed customers fill up your email inbox? It doesn’t need to be that way. Let SQL Sentry show you how to identify potential issues before they turn critical, setup intelligent alerts to highlight important server conditions while reducing noise, and