Daily Coping 14 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Disappearing Data Files

This article has just shared the power of XEvents and yet another use in helping to audit the database environment for changes. Not only do we have this powerful...

Ethics in Modern Data at the Houston SQL Server and BI User Groups, July 2020

On July 14, Christine and I presented at the Houston SQL Server and BI User Groups' virtual meeting. Our joint presentation is one of our favorites to present, Ethics in Modern Data. 

Thanks...

Full Architecture for SQL Backup to Blob Storage in Cloud

One of the tasks that any DBA should know How to take backup to URL or restore a backup from URL and this’s the easiest part very simple steps...

Laptop to Build Hyper-V Test Lab - Part 1

This is the first Video of the series, will show you how to configure Hyper-V and then create several VM’s to configure AlwaysOn

Laptop to Build Hyper-V Test Lab - Part 1

Laptop to Build Hyper-V Test Lab - Part 1

More ADLS Gen2 enhancements

On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2): Archive tier is now GA: The archive tier provides...

Recovery Unit InitPersistentVersionStore Failed

As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported a message printed from the error log. I was...

sp_Blitz for All Servers

Are you a Microsoft SQL Server DBA managing one or more servers?  Then you should know about the First Responder Kit from Brent Ozar Unlimited.  This is a free...