configured to shut down on failure
license core limitaion
managed lock priority
ON_FAILURE = SHUTDOWN
online index rebuild
sql 2012 edition upgrade
SQL Server 2012
sql server 2012 books online
Browse by Tags
Tagged Content List
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...
29 Apr 2014
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...
25 Nov 2013
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...
10 Jun 2013
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...
19 Jul 2012
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...
5 Jul 2012
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...
22 Jun 2012
Page 1 of 1 (6 items)
© 2014 Microsoft Corporation.
Privacy & Cookies