Nick Harrison A Developers’ Guide to Refactoring Databases When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to... 04 April 2011 15 min read
Richard Morris Steve Furber: Geek of the Week Professor Stephen Byram Furber CBE, FRS, FREng was one of the designers of the BBC Micro and the ARM 32-bit... 28 March 2011 12 min read
Wesley David Game-over! Gaining Physical access to a computer Security requires defense in depth. The cleverest intrusion detection system, combined with the best antivirus, won't help you if a... 15 March 2011 11 min read
Fabiano Amorim Lipoaspiration in your SQL Server Database Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now... 03 March 2011 13 min read
Joydip Kanjilal EntityDataSource Control Basics The Entity Framework can be easily used to create websites based on ASP.NET. The EntityDataSource control, which is one of... 03 March 2011 8 min read
Robert Sheldon The EXCEPT and INTERSECT Operators in SQL Server The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a... 28 February 2011 14 min read
Brad McGehee Correlating SQL Server Profiler with Performance Monitor Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from... 16 February 2011 24 min read
Jaap Wesselius SMTP Routing Changed in an Exchange Database Availability Group In Exchange Server 2010 it is possible to make the system more resilient by creating a Database Availability Group (DAG)... 03 February 2011 3 min read
Wesley David 7 Things that High Availability is Not Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's... 13 January 2011 8 min read
Fabiano Amorim Showplan Operator of the Week – Merge Interval When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting... 11 January 2011 7 min read
Joe Celko BIT of a Problem The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it... 04 January 2011 12 min read
Michael Sorens LINQ Secrets Revealed: Chaining and Debugging LINQ has the capabilities of providing a great productivity boost. LINQ Chaining is particularly powerful magic, giving your code greater... 01 December 2010 30 min read
Robert Sheldon The DELETE statement in SQL Server Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd... 25 November 2010 11 min read
Fabiano Amorim ShowPlan Operator of the Week – Merge Join Did you ever wonder how and why your indexes affect the performance of joins? Once you've read Fabiano's unforgettable explanation,... 22 November 2010 9 min read
Shailesh Patel Understanding Browser-Based Silverlight Project Architecture A large part of Silverlight's allure is in its cross-browser capabilities, and that power is derived from its rendering architecture.... 04 November 2010 11 min read
Fabiano Amorim Showplan Operator of the Week – SORT Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the... 11 October 2010 5 min read
Joe Celko State Transition Constraints Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer.... 08 October 2010 13 min read
Khawar Yunus One application in both WPF and Silverlight Because Silverlight is a development of Windows Presentation Foundation, and the technologies are so interlinked, it would seem obvious that... 05 October 2010 6 min read
Richard Morris Carl Franklin and Richard Campbell: Geeks of the Week Learning .NET doesn't have to be dull: not when there are geeks like like Carl Fraklin and Richard Campbell with... 13 September 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – Stream Aggregate Fabiano continues his mission to explain the Query Optimiser in practical terms, describing, one week at a time, all the... 10 September 2010 9 min read
