Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different...

SQL backup directly to Azure storage

Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...

Audit Schema Change Report

In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion.  You can read about that here.  I recommend reading...

Data Compression–A unique feature PART–II TIP #92

In last post TIP #91  we talked about  What is Data compression ? What are the  features ?  Now in this tip...

Dynamic Data Masking

Dynamic Data MaskingFEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users...

Using Solutions in SSMS

There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...

Why I don’t (yet) recommend In-Memory OLTP to my customers

Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...

Azure Data Factory

What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing.  It allows...

Exam Prep 70-463: Variables and Parameters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Monitor Query Statistics

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....