Columnstore Indexes – part 92 (“Lobs”)

Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...

Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5

Data security is always one of the important points which can not be ignored. Nowadays if you are working for...

Data Channel - Launch

Dear All,

I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...

Change the Collation Setting for Clustered SQL Server 2014 Instance

One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...

Don't Count on Me

This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...

ETL #73–NULL or NOT NULL and SQL Interview Questions

Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...

Quick PoSh Kills with Stop-DbaProcess

I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but...

Friday Reading 2016-11-25

Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual

Tony Davies discusses containerisation...

sqlservr.exe

We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...

XmlReader vs XmlDocument Performance

Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...