Interview Trick Questions

Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...

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

Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of...

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

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

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

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

Quick Permissions Audit

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

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