Share via


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