SQL SERVER: Checking all tables row count and size

This is one of those posts where I just blurt out neat stuff I just learned! Today I talked to a man who knew a lot more about databases than…This is one of those posts where I just blurt out neat stuff I just learned! Today I talked to a man who knew a lot… Continue Reading


T-SQL: Generating test data quickly

Today I needed to generate a lot of test data and my SQL-fu hadn’t been fed properly lately so I wasn’t sure what approach to take. Luckily I only needed…Today I needed to generate a lot of test data and my SQL-fu hadn’t been fed properly lately so I wasn’t sure what approach to take…. Continue Reading



SQL Server 2008: Create an alter table script

There are times where you need to save a table as a script in order to use it later. This is great if you want to script how the table…There are times where you need to save a table as a script in order to use it later. This is great if you want to… Continue Reading


SQL Server Profiler missing templates

If you’ve upgraded to SQL Server 2008 R2 then you might have experienced a problem with your templates; they are gone!  You will also notice that your trace provider is…If you’ve upgraded to SQL Server 2008 R2 then you might have experienced a problem with your templates; they are gone!  You will also notice that… Continue Reading