Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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