Sunday, January 17, 2016

Using Regular Expressions to create Quoted lists in SSMS

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

Moving Data with Linked Databases

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.