Categories
Career

Is the Accidental DBA Dead?

For many over the years, they didn’t choose their role. The Accidental DBA was a recognised path into the profession. With platforms and skills changing, I thought it worth asking – are those days behind us? This route to DBA was straightforward. As Brent concisely put it nearly a decade ago – “stand near the database”. That […]

Categories
SQL Server

Understanding SQL Server’s Dedicated Admin Connection (DAC)

Slow queries are one thing, but under heavy pressure, your SQL Servers might see failed connections or slow responses. When the server isn’t responding we want a back-door we can crack open. In SQL Server, this comes in the form of a Dedicated Administrator Connection (DAC). In this post I want to look at what […]