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
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
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
SQL Server Louis Davidson Tim Ford in SQL Server SQL Server Index Tuning with DMVs: sys.dm_db_index_usage_stats, Missing Index Details, and Operational Stats Using SQL Server DMVs to tune your indexing strategy - identifying unused indexes (sys.dm_db_index_usage_stats), finding operational hotspots including latching and... 11 October 2012 43 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 SQL Server Registered Servers and Central Management Server: SSMS Setup Guide Manage multiple SQL Server instances with Registered Servers and Central Management Server (CMS) in SSMS. Covers setup, permissions, querying the... 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
Gail Shaw Gail Shaw’s SQL Server Howlers For the latest in our series of SQL Server Howlers, we asked Gail Shaw which common SQL Server mistakes and... 14 August 2012 22 min read
Dave Ballantyne Cleaning Up SQL Server Deployment Scripts Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema... 02 August 2012 22 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
Seth Delconte NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always... 10 July 2012 14 min read
Warwick Rudd TDE with SQL Server AlwaysOn: Certificate Propagation to Availability Replicas Configure Transparent Data Encryption (TDE) on SQL Server AlwaysOn Availability Databases. Covers creating the master key, certificate, and database encryption... 04 July 2012 8 min read
