July 9, 2015

TSQL pattern matching as part of a table join

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s[...]
Read More »

December 8, 2014

SQL Server Table Designer can’t save changes

I come across this warning/error message every time I do a fresh install of SQL Server on my laptop and despite having set this option back more times[...]
Read More »

December 4, 2014

Need to search strings inside your SQL Objects? Try this utility

While performing a migration from SQL Server 2000 to SQL Server 2014 (wow what a big jump), I needed to find all stored procedures that made a call to[...]
Read More »