Phil Factor Finding Stuff in SQL Server Database DDL You'd have thought that nothing would be easier than using SQL Server Management Studio (SSMS) for searching through the DDL... 04 February 2010 24 min read
Kathi Kellenberger Writing Efficient SQL: Set-Based Speed Phreakery Phil Factor's SQL Speed Phreak challenge is an event where coders battle to produce the fastest code to solve a... 04 February 2010 31 min read
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
Buck Woody Mission Critical: SQL Server 2008 Performance Tuning Task List In which Buck Woody imagines how the US military would have tackled DBA checklists for 'mission-critical' databases. And having imagined... 04 February 2010 3 min read
Paul Nielsen Switching rows and columns in SQL When they use SQL Server, one the commoner questions that Ms Access programmers ask is 'Where's the TRANSFORM/PIVOT command? So... 04 February 2010 4 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
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
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
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
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
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
