SQL Server 2014 Updatable Columnstore Index

I have had many calls with customers that essentially ended with your I/O subsystem cannot keep up with your workload.  The obvious next question was how do we solve that?  My answer was usually get a faster IO subsystem or do less IO!  Now, SQL 2014 offers another option. Let’s pretend for a moment that…

2

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 biggest issues which still exists is they both require a schema modification lock which is very unfriendly with other locks.     From the lock compatibility matrix you can determine that a Sch-M lock is in conflict with everything….

0

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…

0

Windows Azure Privacy, Security and Compliance

One of the questions that is very common among customers is what is the security compliance of Azure? This is a very short question with a very long answer.  To shorten your search visit the Microsoft Azure Trust Center.  At the time of this posting the Trust center has provided compliance framework for ISO/IEC 27001:2005,…

0

SQL 2014 In-Memory OLTP papers released

We have released a new feature in SQL Server 2014 that may significantly improve OLTP application performance called “In-Memory OLTP” codename “Hekaton”.  A single blog post cannot come close to describing the features, benefits and complexities of implementing and using Hekaton.  Take a look at the following new papers to help determine if Hekaton is…

1

SQL 2014 Standard Edition Improvements

  Good News Everyone!  SQL Server 2014 Standard Edition has new features for 2014. 1.  Increase in supported RAM to 128GB. 2.  Addition of Buffer Pool Extension (BPE).  Imagine BPE as a warm cache for the SQL Server buffer pool.  As clean pages are aged out of the buffer pool due to memory pressure, having…

1

New Paper Released on SQL 2014 Cardinality Estimation

There is a new Cardinality Estimator in SQL 2014.  I wanted to drop a quick post to cover a few key points; All of this can be found in Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator A re-designed cardinality estimator in SQL 2014 has been implemented to improve the quality, performance,…

0

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…

1

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 good reason.  I have been neck deep in Hekaton, Column Store and a few other treats in SQL 14.  However, I am going to talk about none of that today.  If you have not noticed…

0

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 up, no more, now you are billed…

2