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

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

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