Sunday, January 17, 2016
This presentation is about a 'trick' i found in SSMS that makes it much easier to create quoted lists for for the 'in' statement
Sunday, January 10, 2016
SSIS isn't the only game in town to move data between SQL Server databases. There are other options like BCP.exe, programs and scripts, and linked databases. I've created a an example solution to demonstrate how to use SQL server agent, linked database,s and some T-SQL to move data between databases.