The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network,...

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it...

SQL Server vNext

I have been pretty busy recently working with Joe Sack from Microsoft and  getting my hands dirty with SQL Server...

Friday Reading 2017-02-03

2017 is trundling along now, this week I’ve been reading…
The GitLab incident report

We’ve all had that moment of “what did...

Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark

(EN)In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.

(DE) In...

Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark

(EN)
In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when...

GitLab for SQL Server Projects

This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build...

Using a DMK in TDE

When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t...

DBA 101: Altering a column

People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...

Getting Started with Power BI: Setup (Part 1 of 3)

This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...