Browse by Tags

Tagged Content List
  • Blog Post: SQL 2012 and SQL 2014 NUMA Fix

    SQL 2012 and SQL 2014 NUMA Fix Typically a SQL Server Cumulative Update release is not a noteworthy event, however SQL Server 2012 SP1 CU9 and SQL Server 2014 CU1 include a fix that is noteworthy from a from a CAT Lab perspective. In short, if you have a NUMA server with 32 or more physical cores...
  • 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: Azure Billing per minute and No Compute Charge for a stopped IaaS VM

    *Updated to account for Stopped (Deallocated) which means stopped from the portal, not just shutdown from inside the instance!!! You asked for it Microsoft did it. Billing per minute is pretty self-explanatory, prior to June 3 all IaaS compute hours billed by the hour and for the most part rounded...
  • 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: Thank you, and Who is on my schedulers?

    In the last two days I have had over 2000 page views on the two posts I have put up. I know I am not that good of blogger yet and the posts are not riveting, so I can only assume that it is the work of Joe Sack and Grant Fritchey who have blasted my blog out to the twitter–verse. All I can say...
Page 1 of 1 (6 items)