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

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

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

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

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 for encrypting connections to SQL Server using certificates....

Finding Next Business Day in T-SQL

Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...

Finding the worst running query in a stored procedure

The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...