Passion, Challenges, and SQL

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

Passion, Challenges, and SQL

One of my biggest reasons why I do what I do, boils down to the challenges that I frequently get to encounter. There is a wild satisfaction to working...

Easy Permissions Audit

Something I have written about more than a handful of times is the need to audit. When people think about...

Interview Trick Questions

Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to...

Defaults In msdb Database

The defaults in the msdb database are about what is missing. It's missing quite a few things that could be critical to your environment.
Related Posts:

SQL Server Configurations - Back...

Easy Permissions Audit

This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:

Failed to Create the Audit File December 31, 2017

Quick Permissions...

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...

Audit SQL Agent Jobs

One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...

Audit SQL Agent Jobs

One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...

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