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

SQL Server 2016 – Perform Volume Maintenance

One of the server settings that I always enable when configuring a new instance of SQL is database instant file...

Great Value IT Training early August Update

Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus...

Undocumented Commands

There isn’t really a need to do what I am doing in this blog post but I guess one reason...

DacFxed - Powershell Nugetized DacFx wrapper

Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...