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
Grant Fritchey Statistics in SQL Server SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or... 08 January 2013 10 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
Fabiano Amorim Hypothetical Indexes on SQL Server Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take... 18 December 2012 8 min read
Grant Fritchey SQL Server Backup Questions We Were Too Shy to Ask During presentations about doing database backups and restores, there seem to be two types of questions that are commonly asked... 07 December 2012 20 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
Jonathan Kehayias Free Tools for the DBA: PAL Tool The Performance Analysis of Logs tool is a general tool for collecting and analysing log data. With the addition of... 30 November 2012 10 min read
Robert Sheldon Book Review: Pro SQL Server 2012 Relational Database Design and Implementation A book on Relational Database Design and Implementation is always welcome, especially when written by one of Simple-Talk's most popular... 28 November 2012 9 min read
Feodor Georgiev Handling Backups for Rapid Resilience The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth... 20 November 2012 10 min read
Seth Delconte Manipulating XML Data in SQL Server When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from... 23 October 2012 14 min read
Book Discussion Brad McGehee in Book Discussion Book Review: Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Kreuger Experienced DBAs have a wealth of experience to rely on when it's time to troubleshoot a problem, but it can... 22 October 2012 11 min read
Tony Davis SQL Server Transaction Log Management by Tony Davis and Gail Shaw When things go wrong, a DBA's reputation depends on an understanding of the transaction log, both what it does, and... 16 October 2012 2 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
Feodor Georgiev Designing Databases for Rapid Resilience As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure.... 15 October 2012 12 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
Louis Davidson Tim Ford Tune Your Indexing Strategy with SQL Server DMVs SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you... 11 October 2012 42 min read
Michael Sorens Database Source Control Basics: Getting Started It makes a lot of sense to do it, but how do you get started? Whatever you use to build... 09 October 2012 17 min read
Joe Sack Exploring Semantic Search Key Term Relevance SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come... 09 October 2012 7 min read
Kalen Delaney SQL Server Concurrency: Locking, Blocking and Row Versioning Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data... 02 October 2012 2 min read
Brad McGehee Book Review: SQL Server Hardware by Glenn Berry Brad finds Glenn Berry's 'SQL Server Hardware' book to be a valuable reference, not so much for the actual hardware... 25 September 2012 9 min read
