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
Database Administration Seth Delconte in Database Administration 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
Laerte Junior The PoSh DBA: Solutions using PowerShell and SQL Server PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much... 18 September 2012 15 min read
Richard Morris Meredith Ryan: DBA of the Day Meredith Ryan - DBA at the Bell Group -was elected by judges and the SQL Server community as the Exceptional... 14 September 2012 12 min read
A Cloudy Place SQL Monitor Hosted: keeping an eye on your servers from the cloud Simple-Talk's Melanie Townsend sits down with Red Gate's Matt Lee to talk about their newest adventure in cloud-based monitoring for... 12 September 2012 9 min read
Grant Fritchey Why is that SQL Server Instance under stress? There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these... 11 September 2012 14 min read
Tools Phil Factor in Tools Registered Servers and Central Management Server Stores SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered... 28 August 2012 15 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
