SQL Shep
SQL Server 2014 Updatable Columnstore Index
I have had many calls with customers that essentially ended with your I/O subsystem cannot keep up...
Date: 05/01/2014
SQL Server 2014 Managed Lock Priority for Partition Switch and Online Reindex
Online reindex and partition switch have both been around for a while now, however one of the...
Date: 04/30/2014
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...
Date: 04/29/2014
Windows Azure Privacy, Security and Compliance
One of the questions that is very common among customers is what is the security compliance of...
Date: 04/29/2014
SQL 2014 In-Memory OLTP papers released
We have released a new feature in SQL Server 2014 that may significantly improve OLTP application...
Date: 04/28/2014
SQL 2014 Standard Edition Improvements
Good News Everyone! SQL Server 2014 Standard Edition has new features for 2014. 1. Increase in...
Date: 04/28/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...
Date: 11/25/2013
SQLCAT.com has left the building, but not really...
Wow, it has been entirely too long since I have posted anything. But I can assure it has been for...
Date: 09/05/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...
Date: 06/10/2013
SQL 2014 Preview announced at TechED
In case you missed it this week and I doubt you did, it was announced at TechED that SQL 2014 will...
Date: 06/04/2013
New CAT White Paper Published, SQL Perf in the cloud!
It is going to be a very busy summer with all the new toys going into preview, but before I get into...
Date: 06/04/2013
Spelunking Azure, What does it Cost?
As I mentioned in a prior post I will be spending some time on Azure, I imagine the things I run...
Date: 05/13/2013
Multi-Terabyte File Storage in the Cloud using DFS!
We recently had a question come to the team about DFS(Distributed File System) in Azure. The short...
Date: 04/03/2013
I WANT YOUR FEEDBACK ON AZURE!
It’s no secret that Microsoft has had a huge push for Azure. Even within the CAT team the...
Date: 04/01/2013
Cloud Spelunking, Managing Azure form your Desktop via PowerShell (the Setup)
These next few posts are going to deviate from the normal SQL, but in time I will get back to that....
Date: 03/29/2013
Windows 2012 and .Net 3.5 Feature Install
Windows 2012 Sever RTM was this week, I can think of no better way of honoring it than to write a...
Date: 08/01/2012
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...
Date: 07/19/2012
SQL 2012 Security Audit 2 (Database Audit)
After mastering SQL Server Audit creation the next item is the database audit. As the name...
Date: 07/05/2012
SQL 2012 Security Audit 1
While the SQL Server audit is not difficult to setup, I am still seeing many folks use and ask about...
Date: 06/27/2012
PASS 2012 Sessions posted
Nothing techy today, just a reminder that phase 1 of PASS early registration ends June 30. The...
Date: 06/25/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...
Date: 06/22/2012
SQL Server 2012 License Core Limitaion
Well, I wondered how long it would take before I got a case related the 2012 licensing change, looks...
Date: 06/21/2012
Surface and SQL
For my first post i can think of nothing better than mentioning the new Surface. I recall when we...
Date: 06/20/2012