Inside SQL Server Pro December 2012
Written by Ian Stirk   
Monday, 10 December 2012

The latest edition of SQL Server Pro magazine highlight’s the 2012 SQL Server Pro Editors’ Best and Community Choice Awards, and as always, contains much more…

SQL Server Pro is an online monthly magazine containing the latest news and articles from leaders in the SQL Server world. The magazine is subscription based, and part of a wider SQL Server website found at The items in bold below correspond to the name of the article in the current issue.



This month’s cover story details the 2012 SQL Server Pro Editors’ Best and Community Choice Awards, where the magazine’s editors and the community at large both choose their preferred database products. If you’re looking for a product to perform a given task, this article is a great starting point for your investigation.

Categories covered include:

  • Backup and recovery
  • Business intelligence/Reporting
  • Development
  • Management and performance
  • Security/Auditing/Compliance
  • Storage hardware
  • Free tools

Elsewhere in the issue, long time contributor Itzik Ben-Gan provides an interesting T-SQL Puzzle based on the 1980s UK TV game show blockbusters. The idea behind the game is to connect 4 or 5 items in a row. If you like to solve puzzles, you’ll love this problem and solution. Be sure to try your own solution before looking at the answer given.

When problems occur with merge replication, determining the cause can be problematic. One solution is to continually monitor performance. This article describes using SSIS to collect baseline data for merge replication, it’s a great example of how two SQL Server features can be used to compliment each other.

If you want to make sense of how the optimizer makes its decisions, you need to read the tipping point. This is my favorite article this month. While sometimes the optimizer can get things wrong, resulting in slowly performing queries, this article shows you how to look at the choices the optimizer makes, and the tipping points involved in making those decisions.

The Industry Bytes section contains an overview of the importance of statistics in query performance, with valuable links to more detailed articles. And New Products describes several cloud based products now available.

Michael Otey’s editorial outlines two lesser known SQL Server features, namely Master Data Services and Data Quality Services. The former provides a consolidated view of data from disparate sources or companies, the latter provides related data cleansing functionality.

If you’ve ever wondered about the reliability of your servers, the reader to reader article provides a walkthrough of code from Tomaz Kastrun, which captures this information using a combination of xp_cmdshell, ping, and SSIS.

It seems no SQL Server question is too difficult for Kimberly Tripp and Paul Randal to answer in SQL Server questions answered. Under investigation are Backup Compression and Large Objects (LOB).

The issue finishes with a short roundup of the New database features in Visual Studio 2012.

Sometimes I wish the magazine articles were longer, or had more code examples. That said, over the course of the year, it is difficult to fault its range and depth.

More Information


To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.





or email your comment to:



DataStax Extends Astra DB

DataStax has extended its Astra DB cloud database to be available in multiple regions and multiple clouds. Astra DB is built on Apache Cassandra and now supports multi-region deployments on any of thr [ ... ]

TigerGraph 3.2 Improves Scalability And Security

TigerGraph has been updated with new availability, scalability, manageability, and security features that the team says will ensure mission-critical graph applications work flawlessly in both private  [ ... ]

More News

Last Updated ( Monday, 10 December 2012 )