April - 2015

IsDST function for SQL Server

I've seen my share of in-house logics to detect if a given day falls under daylight saving time or not, and the conclusion I've come to...

If the SQL Server service does not start in a VM, check this:

ScaleIO SAN - Great for VMware, Not so great for SQL Server

IsDST function for SQL Server

Finally, a mirrored drive!

Deciding between Availability Group and Clustering - Episode IV: Software side of the story

Availability Group is a Klingon Warrior

Out of space? SQL dead? Here's what you do.

Yep. We are SQL consultants, and are telling you to stop using SQL.

MiniMe to the rescue - Simple but effective performance tuning trick

SQL Server Simple Facts

Quick query to return currently restoring databases

No tags yet.