Robert Sheldon Columnstore Indexes in SQL Server 2012 The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore... 30 July 2013 11 min read
Warwick Rudd Expanding AlwaysOn Availability Groups with Replication Subscribers High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the secondary replicas will need to... 18 January 2013 8 min read
Robert Sheldon Handling Errors in SQL Server 2012 The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that,... 03 January 2013 10 min read
Jonathan Kehayias Optimizing tempdb configuration with SQL Server 2012 Extended Events One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the allocation bitmap of each data... 13 July 2012 20 min read
Warwick Rudd Encrypting Your SQL Server 2012 AlwaysOn Availability Databases It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you do so you'll find that... 04 July 2012 8 min read
Joe Sack A first look at SQL Server 2012 Availability Group Wait Statistics If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of... 21 May 2012 15 min read
Warwick Rudd SQL Server 2012 AlwaysOn SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server features, particularly Failover Clustering, and... 15 May 2012 19 min read
Fabiano Amorim Window Functions in SQL Server: Part 2-The Frame Fabiano continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented and when, and explaining the... 24 November 2011 13 min read
