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... 18 January 2013 8 min read
Ambily Kavumkal Kamalasanan Windows Store App Contracts Windows Store Apps use contracts to declare the interactions that they support with other apps and with the 'Charm Bar'.... 14 January 2013 15 min read
Warwick Rudd Expanding AlwaysOn Availability Groups with Replication Publishers SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has... 14 January 2013 9 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... 03 January 2013 10 min read
Richard Morris Bill Baker: Geek of the Week Bill Baker had a considerable influence on the way that SQL Server evolved to deliver reporting services and business intelligence.... 04 December 2012 8 min read
Feodor Georgiev How come the Hourglass? Why database applications slow down It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It... 28 November 2012 12 min read
Robert Sheldon Report Building 3.0: Adding Maps to Your Reports With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations.... 13 November 2012 17 min read
Feodor Georgiev How come the Hourglass? Why database applications slow down It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It... 10 November 2012 12 min read
Dino Esposito Syntactic Sugar and the Async Pill Asynchrony is essential for scalability and performance on the server side. Although it has always been possible to write asynchronous... 18 October 2012 12 min read
Sven Aelterman Jacob Sebastian The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in... 16 October 2012 2 min read
Richard Morris Alex Payne: Big in the IT Business Alex Payne worked on developing Twitter for three years. When he started, it was a small side-project: When he left,... 15 October 2012 11 min read
Robert Sheldon Book Review: Microsoft SQL Server 2012 Bible A broad topic requires a thick book. the Microsoft SQL Server 2012 Bible is the work of several authors and... 12 October 2012 9 min read
Robert Sheldon Report Builder 3.0: Creating a Basic Report Report Builder is underrated as a BI and report-authoring tool. It is a free stand-alone application from Microsoft that provides... 24 August 2012 18 min read
Grant Fritchey The Seven Sins against TSQL Performance There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally... 31 July 2012 15 min read
Richard Morris Database Continuous Integration with Bamboo We were so interested in Atlassian's Bamboo, and it's role in Continuous Integration, that we wanted to find out more,... 26 July 2012 15 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... 13 July 2012 20 min read
Chris Farrell .NET Memory Management Basics .NET memory management is designed so that the programmer is freed from the chore of consciously having to allocate and... 11 July 2012 19 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... 04 July 2012 8 min read
Richard Morris James Hong: Big in the IT Business James Hong was one of a generation of entrepreneurs who fell into the role almost accidentally by creating an application... 28 June 2012 11 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... 21 May 2012 15 min read
