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…

1

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 you to…

2

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 you…

0

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…

0