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
Joe Celko Median Workbench SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median,... 05 April 2009 15 min read
Richard Morris Simon Sabin Says SQLBits SQLBits is the largest SQL Server conference in Europe. Because it is held on a Saturday, and is free, it... 03 March 2009 9 min read
Grant Fritchey Understanding More Complex Query Plans In order to be able to tackle performance issues in SQL Server , and write effective SQL, it is essential... 26 February 2009 30 min read
Gayani Devapriya Designing A Data Access Layer in LINQ to SQL Gayani provides the complete source code for a sample Data Access Layer for LINQ to SQL, using the Northwind Database,... 21 February 2009 13 min read
Joe Celko Divided We Stand: The SQL of Relational Division Businesses often require reports that require more than the classic set operators. Surprisingly, a business requirement can often be expressed... 17 February 2009 17 min read
Phil Factor The TSQL of Text Files Phil returns to the old subject of 'Getting text-based data in and out of SQL Server'. He shows various easy... 19 January 2009 15 min read
Alex Kozak Estimating Disk Space Requirements for Databases In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk... 16 January 2009 16 min read
