Current Running Queries

Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...

Create a Date Dimension in Azure SQL Data Warehouse

Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...

AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING

AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
 
I have recently come across an issue that, one of my alwaysON secondary replica...

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
Related Posts:

Cannot Open Backup Device January 1, 2020...

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the...

What is the Lambda Architecture?

Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...

Visual Studio Live!–Washington DC–Save with me

I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my...

Fix that page

I am in a fix-it mood so for this blog I am going to corrupt a page and then show...

Dropping Masking from a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Server 2016 Cumulative Update 1

On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...