Joe Celko Celko’s Summer SQL Stumpers: Prime Numbers Joe Celko kicks off our series of Summer SQL Stumpers with a challenge to improve on his solution to calculating the... 23 July 2009 6 min read
Roger Hart Continuous Integration with SQL Toolbelt Sometimes, you wish you had a tool to run a software development process exactly the way you need it to... 23 July 2009 17 min read
Rodney Landrum SQL Server Tacklebox Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts and techniques to automate and standardize SQL Server installation, document... 15 July 2009 3 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
Bob Cramblitt William Durkin, Serial Red Gate Beta Tester An interview with William Durkin. When he has the time, William finds it useful to work as a pre-release software... 09 July 2009 4 min read
Robert Sheldon Working with Precedence Constraints in SQL Server Integration Services In SSIS, tasks are linked by precedence constraints. A task will only execute if the condition that is set by... 07 July 2009 11 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
Brad McGehee Brad’s Sure Guide to Indexes In order to best appreciate the reasons for, or importance of, the various administrative tasks that are needed for indexes,... 11 June 2009 40 min read
Karla Kay Remail Thinking of Setting up a SQL Server Users Group? The work of setting up a SQL Users Group isn't always easy, but, as Karla relates, it can be a... 03 June 2009 11 min read
Jaap Wesselius Windows Server Virtualisation: Hyper-V, an Introduction For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the... 01 June 2009 11 min read
Barry King Reporting Services with Style Even when Microsoft neglect a feature, there are always pioneers who find ways of getting around the problem. Such is... 28 May 2009 10 min read
Robert Sheldon Using the FOR XML Clause to Return Query Results as XML The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in... 27 May 2009 36 min read
Jacob Sebastian Introduction to XML Schema What is an XML Schema, and why is it important? How did XSD develop from its precursors, DTD and XDR?... 07 May 2009 14 min read
Joe Celko SQL and the Snare of Three-Valued Logic The whole subject of the Three-Valued (also known as ternary, trivalent or 3VL) Logic of SQL tends to trip people... 07 May 2009 13 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
Chris Massey Free eBook: SQL Server Crib-Sheet Compendium For everything you need to know, rather than want to know, about SQL Server Reporting Services, replication, backup, XML, performance,... 24 April 2009 1 min read
Ben Hall Embedding IronRuby and the DLR into SQL Data Generator You can embed DLR-based languages such as IronPython and IronRuby into applications. This gives you instant scripting, and with it,... 23 April 2009 14 min read
Phil Factor CLR Assembly RegEx Functions for SQL Server by Example Phil Factor presents a simple CLR Assembly to allow SQL Server users to access all the powerful RegEx library methods... 15 April 2009 15 min read
