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

Most Read: My Top 5 SQL Server Articles and Blogs

There has been some really useful blogs and articles posted over the last week or so, this is my top...

Populating My DBA Database for Power Bi with PowerShell – Databases

Following my post about using Power Bi with my DBA Database I have been asked if I would share the...