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...

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...

tSQLt – SQLCop – Checking Naming Conventions

I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for...

Please Throw this Hardware at the Problem

We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems...