SQL Script: - How to find the database restoring history of SQL Server databases

Sometime we need to find out the history of database restoration to get the answers of following questions: -

1) Do...

Azure SQL Database – Automatic Index Tuning

Introduction: -
We live in an era of “Automation”.  Planes run on auto pilot mode, cars will soon be auto driven,...

SQL .NET Requirements

SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...

Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th

Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was...

Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th

Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...

PASS Virtualization Webinar – April 11

I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure...

Interview With Matt Gordon

I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I...

Learning is Hard–March Goals Update

This is the third update for my goals for 2018. This is about 3 weeks after the last update, and...

‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS <= 17.5

Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...

Speaking at SQL Saturday Atlanta (#733)

I am so honored and humbled to have been selected to speak at SQL Saturday Atlanta (#733) on May 19,...