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

Heading To PASS Summit 2015 – Now What?

You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...

Heading To PASS Summit 2015 – Now What?

You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...

Improving Networking at PASS Events–Part 1

This week I’m spending some drive time thinking about how we might improve networking at SQLSaturday and that led to...