SQL Azure, Hekaton, and Bob Dorr is Awesome

Hello Dear Reader!  I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...

Sql Server - Index Utilization Report

Index Utilization Report

One day my manager came and told me that he need Index Utilization Report.
He felt that during...

Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and...

Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of...

Why SQL Server Database Is In Recovery Mode?

The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes...

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...

Understanding the Different States of SQL Database

Overview
There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in...

When should I use a CTE?

If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...

An MCM teaches COMMENTS at SQL Saturday OKC

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...

Go, Go, Golang!

WHAT!
 
Yep, you read that right. I’m building tools in Go.
I can hear you now…. But Wes you are a SQL...