Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about
February 13, 2017
Author: Jason Brimhall
sp_server_diagnostics – Black Box Recorder
A few months back I began a series about the SQL Black Box Recorder, that you can read here, with
July 26, 2016
SQL Black Box Recorder part II
A few months back I began a series, about the SQL Black Box Recorder that you can read here, with
April 6, 2016
Indexed Views – Performance Panacea or Plight
Indexed View(s) An indexed view is a view where the result set from the query (the view definition) becomes materialized in
January 28, 2016
Disk Space and SQL Server
Disk Space in SQL Server One of the frequently required job functions of the database administrator is to track disk
January 21, 2016
SQL Black Box Recorder
Across many professions and industries there is often a need to have some sort of device that “audits” everything that
January 12, 2016
Freakin’ out on XE at the FreeCon
Just a couple weeks ago I announced that SQL Solutions Group was getting ready to host a day of free training—a
September 29, 2015
An Experiment with Deadlocks
Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple
July 21, 2015
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of
July 15, 2015
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform
April 22, 2015