Setting up a new CI server to build SSDT projects

I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to...

SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting

TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...

SSC Editorial: The Counter Offer – Part 1/Part 2

Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The...

Webinar: Kicking the Tires on SSIS 2016

The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating...

Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)

Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...

Comparison Predicates and Event Data

Predicates are a significant component within the Extended Events Engine. This article discusses one of the pieces of the puzzle of predicates - comparison operators - also known as...

Comparison Predicates and Event Data

In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of...

Costumes at the PASS Summit

tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit....

DR drill - Part 2: Log Shipping

Welcome back to DR drill series!

In the last post (here), we have highlighted a number of ways to setup disaster...

Encrypting Connections To SQL Server Using Certificates

Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...