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

SQL Script to find the database & their files details on a SQL Server

Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...

SQL Script to find the database & their files details on a SQL Server

Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name2) Database ID3)...

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

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 we need to restore the database again as there...

The Journey Begins

Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...

Thursday Night at the PASS Summit

It’s early days for thinking about the Summit, but as I wrote the post for yesterday about not submitting I...

YouTube Channel Update: March 30, 2018

Hey everyone!
Here’s the latest stuff on my new YouTube Channel. Please let me know if these videos are helpful. Also,...

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

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