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

SQL Server principals – Server Roles

[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us on Facebook & YouTube.] Server Roles: Server roles are security principals to control access of...

SSIS Parameters

SSIS parameters help to ease the process of passing runtime values to SSIS packages. For values that can change over time, using parameters in SSIS is an ideal means...

T-SQL Tuesday #128: Learn From Others

Introduction This month’s T-SQL Tuesday is being hosted by Kerry Tyler. The subject is a recent mistake that was made and what was required to fix it. These don’t have to be SQL...