Josef Richberg Simple Query tuning with STATISTICS IO and Execution plans A great deal can be gleaned from the use of the STATISTICS IO and the execution plan, when you are... 04 February 2010 21 min read
Robert Sheldon Implementing User-Defined Hierarchies in SQL Server Analysis Services To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on... 02 February 2010 13 min read
Bob Cramblitt SQL Search- The Search and the Sequel It started out as an experiment to try to explore different ways of creating a software tool that people would... 02 February 2010 8 min read
Phil Factor Laying out SQL Code It is important to ensure that SQL code is laid out the best way for the team that has to... 21 January 2010 17 min read
Laerte Junior Exceptional PowerShell DBA Pt 2 – The Morning Checklist Laerte Junior takes us further into the world of an Exceptional PowerShell DBA, showing us how he uses PowerShell 2.0... 21 January 2010 15 min read
Rodney Landrum Managing Data Growth in SQL Server 'Help, my database ate my disk drives!'. Many DBAs spend most of their time dealing with variations of the problem... 21 January 2010 37 min read
Brad McGehee Brad’s Sure DBA Checklist Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don'ts. It... 20 January 2010 33 min read
Joe Celko Celko’s SQL Stumper: The Class Scheduling Problem What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with... 19 January 2010 8 min read
Fabiano Amorim 13 Things You Should Know About Statistics and the Query Optimizer Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a... 07 January 2010 24 min read
Brad McGehee Database Maintenance Plans in SSMS: An Overview Maintenance plans are essential. Microsoft provide two tools, the Maintenance Plan Wizard and the Maintenance Plan designer, to assist the... 06 January 2010 23 min read
Robert Sheldon Five Basic Steps for Implementing an Analysis Services Database To learn an application, nothing beats getting it up and running. Getting started with Analysis Services can be frustrating unless... 05 January 2010 18 min read
Phil Factor The SQL of Scrabble and Rapping In which Phil decides to use a table consisting of all the common words in English to explore ways of... 25 December 2009 15 min read
Robert Sheldon Working with the bcp Command-line Utility Even though there are many other ways to get data into a database, nothing works quite as fast as BCP,... 10 December 2009 35 min read
Barry King SQL Server Partitioning without Enterprise Edition Table partitioning is a valuable technique for managing very large database tables. It has always been possible with SQL Server,... 10 December 2009 6 min read
Laerte Junior Exceptional PowerShell DBA Pt1 – Orphaned Users Inspired by Brad McGehee's 'How to Become an Exceptional DBA', Laerte decided it was high time he took a proactive... 26 November 2009 16 min read
Rodney Landrum Eating SQL Server Installations for Breakfast Here you will find wholesome SQL Server installations on the menu, complete with Express, Continental and Deluxe breakfast choices, depending... 24 November 2009 25 min read
Grant Fritchey Controlling Execution Plans with Hints The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best... 12 November 2009 38 min read
Robert Sheldon Managing Transaction Logs in SQL Server The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed... 12 November 2009 17 min read
Phil Factor Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block In which Phil is asked to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do... 12 November 2009 17 min read
Bob Cramblitt Exceptional DBA Josef Richberg: fighting cancer, but still sharing Josef Richberg is an exceptional person: The Judges of the Exceptional DBA Award were quickly proved right in their decision... 10 November 2009 6 min read
