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, so why not have auto indexed databases? This article...

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

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

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

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