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
Tag: SQL Administration
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
What Sessions are Deployed?
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying
September 1, 2015
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out
May 13, 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
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of
February 17, 2015