COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

SSDT all the way

I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

Tales of a DBA fed up with NOLOCK. Part 1

Nov 12, 2014

Dear Diary,

They asked for help again. Every now and again everything slows down and they see a lot...

Show AutoGrowth Events with Powershell to CSV

This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...

Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test

By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...

Friday Followup For February 13, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Steps to become more agile with Sql development

In this series of posts I am going to talk about what it is we need to do, as Sql...

Steps to become more agile with Sql development

In this series of posts I am going to talk about what it is we need to do, as Sql developers and DBAs to improve our working practices so...

Steps to become more agile with Sql development

In this series of posts I am going to talk about what it is we need to do, as Sql...