Browse by Tags

Tagged Content List
  • Blog Post: Head Blocking Script, Again…

    Did I mention I use this blog to keep scripts so I do not lose them? Well, I do, it is easier to find stuff on the internet than it is on my own machine. This script is not new, it is not extra special for 2014, it's just a basic head blocker script with query statement text. Finding who is backed up...
  • Blog Post: SQL 2012 Security Audit 3 (Predicate and Failure)

    This is the script to bring it all together. In this case I have opted for just a server side specification with a filter on the database and exclusion of system objects. You can certainly leave the access to system objects, however it will generate a significant number of audit entries. I encourage...
  • Blog Post: SQL 2012 Security Audit 2 (Database Audit)

    After mastering SQL Server Audit creation the next item is the database audit. As the name indicates, the Database Audit is Database scoped, so it will focus to the database level actions. This can be useful if you have a single database on the server, or perhaps even a single schema or even table...
  • Blog Post: Surface and SQL

    For my first post i can think of nothing better than mentioning the new Surface . I recall when we demoed the original Surface about 4-6 years ago, depending on where you were at the time. As time goes by it will be more difficult to find a reference to it, but it will live on the internet forever and...
Page 1 of 1 (4 items)