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

AlwaysON move database without breaking HADR

AdvertisementsMove database without breaking alwaysON

This post is going to show the database movement from one drive to another drive, without...

Dreaming of SQL Saturday

I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL...

What’s the difference between LEFT and RIGHT OUTER JOINs?

A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...

Minimizing SQL Server DBCC CHECKDB Performance Impacts

Overview
SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data....