Robert Sheldon The MERGE Statement in SQL Server 2008 When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy... 27 August 2010 14 min read
Joe Celko The DIS-Information Principle: A Splitting Headache You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue... 17 August 2010 10 min read
Michael Sorens Mixing WPF and WinForms You can embed WPF controls in a WinForms application or WinForms controls in a WPF application, using a simple adapter.... 10 August 2010 32 min read
Andrew Clarke SQL Source Control: The Development Story Often, there is a huge difference between software being easy to use, and easy to develop. When your pilot users... 22 July 2010 21 min read
Fabiano Amorim Operator of the Week – Index Spool If you've ever wondered what happens to your queries if you're not conscientious about creating indexes, then Fabiano Amorim has... 25 June 2010 14 min read
Joe Celko Binary Trees in SQL A number of hierarchies and networks are most convenently modelled as binary trees. So what is the best way of... 22 June 2010 13 min read
Hima Bindu Vejella Book Review: The Art of XSD – SQL Server XML schemas The 14 chapters of "The Art of XSD", written by MVP Jacob Sebastian, will take the reader step-by-step all the... 10 June 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – Lazy Spool Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator... 10 June 2010 9 min read
Neil Hobson Exchange 2010 DAG Creation and Configuration Part 1 If you're using Exchange 2010, then you're probably interested in using the new Database Availability Group feature for your High... 07 June 2010 13 min read
Jonathan Medd 10 Steps to Kick-Start Your VMware Automation with PowerCLI Virtualization is a powerful technology, but it comes with its own host of monotonous and time-consuming tasks, no matter how... 02 June 2010 17 min read
Laerte Junior I’m a SQL Server DBA, and I’m in Love with PowerShell To learn PowerShell, Laerte suggests that you just start using it. To encourage you to start, he provides a series... 28 May 2010 13 min read
Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he... 20 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he... 07 May 2010 7 min read
Rod Colledge High Performance Storage Systems for SQL Server Rod Colledge turns his pessimistic mindset to storage systems, and describes the best way to configure the storage systems of... 29 April 2010 14 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with... 28 April 2010 6 min read
Fabiano Amorim Showplan Operator of the Week – Concatenation Fabiano continues in his mission to describe, one week at a time, all the major Showplan Operators used by SQL... 22 April 2010 3 min read
Nick Harrison Back to Basics: Converting a Web Page to a Web Form View ASP.NET developers can learn a lot from MVC practices. This article shows you how to structure a WebPage in an... 20 April 2010 15 min read
Fabiano Amorim Showplan Operator of the week – Assert As part of his mission to explain the Query Optimiser in practical terms, Fabiano attempts the feat of describing, one... 14 April 2010 7 min read
Andrew Clarke Who Tests the Tester? It is scarcely surprising that it can take up to five years to release a new version of SQL Server... 19 February 2010 15 min read
Carl Niedner ANTS Profiler Saves Me From A Sordid Fate A bit of string concatenation never hurt anybody, right? Think again. Carl Niedner has been designing software since 1983, and... 18 February 2010 5 min read
