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
Robert Sheldon Report Builder 3.0: Adding Charts to Your Report Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts... 11 October 2012 13 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
Joe Celko Book Review: SQL and Relational Theory by C. J. Date SQL and Relational Theory, by Chris Date, isn't likely to be a book that SQL's greatest defender, Joe Celko, would... 26 September 2012 10 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
Seth Delconte Getting Started With XML Indexes XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running... 25 September 2012 17 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
Joe Celko Matrix Math in SQL Relational Databases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but... 17 September 2012 10 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
Robert Sheldon Report Builder 3.0: Formatting the Elements in your Report There is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder.... 12 September 2012 16 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
Phil Factor 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 14 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
