Jaap Wesselius Hyper-V R2 Live Migration Reliability is one of the great payoffs to virtualization, and failover clustering has got a whole lot better with Windows... 10 February 2010 11 min read
Robert Sheldon Implementing User-Defined Hierarchies in SQL Server Analysis Services To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on... 02 February 2010 13 min read
Nick Harrison Back to Basics: Structuring a Web Page with CSS and ASP.NET Nick explains why such habits as using nested HTML Tables to position content in the right place on the browser... 28 January 2010 15 min read
Michael Sorens Using LINQ Lambda Expressions to Design Customizable Generic Components LINQ makes code easier to write and maintain by abstracting the data source. It provides a uniform way to handle... 27 January 2010 25 min read
Richard Morris Don Syme: Geek of the Week It came as a surprise to many of us when Microsoft pulled from it's hat a rabbit in the form... 19 January 2010 10 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
Richard Morris Robin Milner: Geek of the Week Although Robin Milner is best known for creating ML, which has evolved into Microsoft's new F# language, he would, had... 14 January 2010 11 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
Robert Sheldon Five Basic Steps for Implementing an Analysis Services Database To learn an application, nothing beats getting it up and running. Getting started with Analysis Services can be frustrating unless... 05 January 2010 18 min read
Barry King SQL Server Partitioning without Enterprise Edition Table partitioning is a valuable technique for managing very large database tables. It has always been possible with SQL Server,... 10 December 2009 6 min read
Richard Morris Donald Knuth: Geek of the Week Donald Knuth is an extraordinary man. As well as inventing 'Literate Programming' and writing the most important textbook on programming... 26 November 2009 14 min read
Dr. Masha Petrova Increase Your Value as a Professional in the Technical Industry It has never been so important to enhance your employability as it is today. Job security can never be taken... 17 November 2009 7 min read
Nirmal Sharma Increasing the Availability of Virtualised Applications and Services By using a virtualized clustering computing environment with failover, you can improve server availability without using as many physical computers.... 22 October 2009 23 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
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
Neil Hobson Exchange 2010 High Availability In April 2009 Microsoft released a public beta of Exchange 2010, the latest and greatest version of a part of... 18 September 2009 14 min read
William Brewer Calling Stored Procedures from .NET Applications Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored... 11 September 2009 18 min read
Richard Morris Luca Cardelli: Geek of the Week Luca Cardelli is probably best known for Polyphonic C# and Biocomputing, but he has designed a number of experimental languages... 02 September 2009 7 min read
Hugo Shebbeare Disaster Recovery for SQL Server Databases High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This... 28 August 2009 27 min read
