Richard Morris Itzik Ben-Gan: DBA of the Day Itzik Ben-Gan, who was one of our first Geeks of the Week in 2005, is so well known and popular... 06 January 2010 17 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
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
Phil Factor Connection Strings, an Overview We asked Phil to come up with a simple explanation of connection strings. We somehow weren't expecting a 'quote of... 26 November 2009 13 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
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
Richard Morris Geek of the Week: Joe Celko Joe Celko, the Database Developer and writer from Austin Texas, is not a man to mince his words. His encyclopedic... 16 October 2009 12 min read
Anith Sen Five Simple Database Design Errors You Should Avoid Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five... 16 October 2009 18 min read
Robert Sheldon Using Information Schema Views Many seasoned database developers tuck away all the commonly-used INFORMATION_SCHEMA queries as templates. They're an indispensable supplement to sp_help and... 01 October 2009 13 min read
Michael Sorens A Unified Approach to Multi-DataBase Query Templates While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired... 30 September 2009 22 min read
William Brewer Calling Stored Procedures from .NET Applications Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored... 11 September 2009 18 min read
Hugo Shebbeare Disaster Recovery for SQL Server Databases High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This... 28 August 2009 27 min read
Ben Lye Monitoring and Scheduling Exchange 2007 Database Online Maintenance To keep the Exchange database healthy, it is important to make sure that online maintenance and online maintenance and online... 25 August 2009 11 min read
Shawn McGehee SQL Backup 6: Wind of Change One could be forgiven for thinking that there is little more you can do with any third-party Backup software than... 03 August 2009 15 min read
Brad McGehee Do Not Forget to Maintain Your Indexes Index Maintenance Plans are essential for the well-being of a database. However, there is more to the process than just... 09 July 2009 15 min read
Joe Celko Avoiding the EAV of Destruction A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a... 18 June 2009 11 min read
Anith Sen Facts and Fallacies about First Normal Form When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith... 07 May 2009 15 min read
Richard Morris Marc Wick: Geek of the Week Marc Wick is the genius behind GeoNames, the free Web Service that powers a number of popular GPS applications and... 06 May 2009 8 min read
Robert Sheldon XML Data Modification Language Workbench XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases,... 28 April 2009 21 min read
