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
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
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 FOR XML in SQL Server: RAW, AUTO, EXPLICIT & PATH Modes Complete guide to the FOR XML clause in SQL Server. Learn all four modes - RAW, AUTO, EXPLICIT, and PATH... 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
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
T-SQL Programming Phil Factor in T-SQL Programming SQL Server CLR Regex Functions: Build Your Own Assembly (SQL Server 2022 and Earlier) Build and deploy CLR regex functions for SQL Server 2022 and earlier without Visual Studio. Complete VB.NET assembly with REGEXP_LIKE,... 15 April 2009 15 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
Gail Shaw SQL Server Performance Investigation Part 2: Execution Plan Analysis, Index Design, and Post-Implementation Measurement Part 2 of a SQL Server performance investigation: examining the execution plans of the worst-offending procedures identified in Part 1,... 03 April 2009 29 min read
Robert Sheldon Working with Property Expressions in SQL Server Integration Services Property Expressions in SSIS packages are assigned to a property at run time. This allows parameters to be passed to... 16 March 2009 12 min read
Brad McGehee How to Identify Blocking Problems with SQL Profiler Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking... 13 March 2009 11 min read
Gail Shaw SQL Server Performance Investigation Part 1: Server-Side Trace, Aggregated Execution Statistics, and Identifying Worst-Offender Procedures Part 1 of a SQL Server performance investigation walkthrough - setting up a server-side trace, filtering it to capture the... 09 March 2009 14 min read
Dan McClain How to Get Management Buy-In for Software purchases There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs... 02 March 2009 15 min read
