Alex Kuznetsov Basic Defensive Database Programming Techniques We can all recognise good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade.... 31 March 2010 36 min read
Joe Celko Celko’s SQL Stumper: Eggs in one Basket Joe Celko reveals the winner of his Easter Stumper: the puzzle of designing an apparently simple database to deal with... 29 March 2010 13 min read
Phil Factor Exploring your database schema with SQL In the second part of Phil's series of articles on finding stuff (such as objects, scripts, entities, metadata) in SQL... 02 March 2010 23 min read
Joe Celko Procedural, Semi-Procedural and Declarative Programming in SQL A lot of the time, the key to making SQL databases perform well is to take a break from the... 15 February 2010 10 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
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
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
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
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
Phil Factor Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block In which Phil is asked to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do... 12 November 2009 17 min read
Fabiano Amorim Query Optimizer and Cartesian Products In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano takes a... 22 October 2009 5 min read
Fabiano Amorim Data Correlation Optimization Internals Having adroitly introduced us, in his previous article, to the Date Correlation ability of the Query Optimizer, Fabiano discusses the... 14 October 2009 10 min read
Jacob Sebastian The Art of XSD – eBook Download When information is exchanged in XML format, you need an agreement between the sender and receiver about the structure and... 07 October 2009 1 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
Fabiano Amorim The Query Optimizer: Date Correlation Optimisation In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to... 01 October 2009 10 min read
Joe Celko Celko’s SQL Stumper: The Data Warehouse Problem Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems... 25 September 2009 5 min read
Joe Celko Causation, Correlation and Crackpots Joe Celko explores the dangers of muddling correlation and causation, emphasises the importance of determining how likely it is that... 15 September 2009 13 min read
Robert Sheldon Transact-SQL Formatting Standards (Coding Styles) How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How... 25 August 2009 25 min read
Joe Celko Getting rid of SQL Code Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem... 20 August 2009 13 min read
