Category: SQL

Spectre and Meltdown Exploits
Spectre and Meltdown In recent weeks, a significant security risk was exposed. This exploit has been named in two fashions: Spectre and Meltdown.
January 18, 2018

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