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
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
Richard Morris Niklaus Wirth: Geek of the Week It is difficult to begin to estimate the huge extent of the contribution that Niklaus Wirth has made to IT... 02 July 2009 11 min read
Phil Factor The Book ‘Confessions of an IT Manager’ For three and a half years, the 'Confessions of an IT Manager', by Phil Factor, have been a distinctive part... 27 May 2009 7 min read
Gail Shaw Finding the causes of poor performance in SQL Server, Part 2 In the first part of this series of articles, Gail showed how to find the procedures that contributed most to... 03 April 2009 28 min read
Brien Posey An Introduction to Unified Messaging For many years, everyone involved in the administration of offices has wished that there was a way of combining the... 26 March 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
Bill Holmberg Change Management- What It Is and Why You Need It Bill Holmberg takes a practical look at Change Management, and list the steps you need to take. To make things... 02 March 2009 12 min read
Phil Factor Phrenetic Phil and the SQL Shootout Phil Factor turns to burlesque in order to reinforce his point that an ability to answer SQL Technical questions isn't... 03 February 2009 7 min read
Amirthalingam Prasanna Some Data with your Application Take-away, Sir? Prasanna is reminded of pizza in cardboard boxes when he explores the possibilities of Synchronization Services for ADO.NET. Data applications... 09 December 2008 9 min read
Joe Celko Unique Experiences! You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause... 18 November 2008 14 min read
Robert Sheldon SQL Server Data Warehouse Cribsheet It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into... 03 November 2008 21 min read
Andrew Clarke .NET Reflector: Soup to Nuts .NET Reflector is almost an intrinsic part of the .NET Framework, a free tool for browsing the contents of a... 22 October 2008 15 min read
Ben Lye Reporting on Mobile Device Activity Using Exchange 2007 ActiveSync Logs In this new column giving practical advice on all things Sys Admin related, Ben Lye takes on the often difficult... 10 October 2008 6 min read
Vladimir Bodurov Dynamically generating typed objects in .NET When you are binding Data to DataGrid in .NET, this has to be done at design-time. That's fine if you... 14 July 2008 17 min read
Neil Hobson High Availability in Exchange 2007 Neil Hobson writes about the ways that MS Exchange 2007 can ensure that your organisations messaging remains available. He looks... 10 June 2008 17 min read
John Papa Data and Silverlight 2: Data Binding Silverlight 2 is far more versatile than Silverlight 1. It can handle data-sources with some subtlety. John Papa tackles the... 05 June 2008 12 min read
Richard Morris The Burning Men – The IT drug habit It would seem bizzare that IT staff who depend on their quick wits for their living should ever think it... 29 April 2008 10 min read
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
