I’m speaking at SQL Saturday 749 : Baton Rouge

Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...

Friday Reading 2018-07-27

Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.
Linux Load Averages: Solving the Mystery

Good...

Adding File to Database in AlwaysOn Availability Group

When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...

Keep up with SQL Server Patches!

Keep up with SQL Server Patches with us with our feed from Microsoft.  Check it out!  http://vitamindba.com/sql-server-releases/
The post Keep up with...

SQL Server – Stairway to Database Backup-and -Restore, (and Recovery)- Complete Guide

It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database...

Save the Connection String Parameters in SSMS – AlwaysOn

In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...

Are your backup files where they say they are?

 
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...

Power BI Custom Visuals Class (Module 112 – Acterys Matrix Light)

In this module you will learn how to use the Acterys Matrix Light. Acterys Matrix Light is designed primarily for...

Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3

In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do...

Know more about SQL Server database backups, restores, and recovery: Q& A – Part 2

In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL...