Quick Permissions Audit

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:

Easy Permissions Audit...

Automatic Tuning Monitoring and Diagnostics

Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic...

Automating like an Enterprise DBA

TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...

Automating like an Enterprise DBA

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....

ArithAbort and SQL Agent Failures

ARITHABORT can be a short termed head scratcher.  Pay close attention to what has changed in the environment.  Test alternatives.  And check those connection strings.
Related Posts:

Failed to Create the...

ArithAbort and SQL Agent Failures

ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...

Quick and Easy XE for Azure DB

The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....

Short Circuiting Your Session

It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...

Automatic Tuning Monitoring and Diagnostics

Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...

Event Tracing for Windows Target

There are many useful targets within SQL Server's Extended Events. Of all of the targets, the most daunting is probably the Event Tracing for Windows (ETW) target. The ETW...