Ben Lye Monitoring and Scheduling Exchange 2007 Database Online Maintenance To keep the Exchange database healthy, it is important to make sure that online maintenance and online maintenance and online... 25 August 2009 11 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
Bart Read .NET Reflector Support: Why does .NET Reflector auto-update itself? We’re asked about this fairly regularly, so I thought it was about time I posted up our position on it... 21 August 2009 2 min read
Tony Davis In Defence of Defensive programming The relational data model is 40 years old this month, and SQL is not much younger. By any standards, it... 21 August 2009 3 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
Plamen Ratchev Ten Common SQL Programming Mistakes It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries. In this article, Plamen... 20 August 2009 28 min read
Bart Read .NET Reflector Support: How can I set breakpoints in the code I’ve decompiled when debugging? I see this question come up from time to time in the .NET Reflector mailbox, so I’m going to make... 19 August 2009 3 min read
Richard Morris Sir Tony Hoare: Geek of the Week After inventing the QuickSort algorithm, and designing the compiler for the Algol 60 programming language, Tony Hoare went on to... 18 August 2009 14 min read
Jaap Wesselius Update: Exchange Server 2010 Release Candidate Exchange Server 2010 Release Candidate is now available for download from Technet, so we asked Jaap to review it for... 18 August 2009 7 min read
Louis Davidson Devlink Wrapup…or…Where I started to realize that the data world is “different” First off, let’s just say that Devlink (www.devlink.net) is a fantastic conference. It returned to the Lipscomb campus this year,... 17 August 2009 6 min read
Laila Lotfi Models, Views, and Controllers: ASP.NET MVC The poor application programmer, chipping away contentedly in Winforms or Webforms, is often heard to groan whenever a new Microsoft... 13 August 2009 3 min read
Nick Harrison A Defense of Reflection in .NET The trouble with making general rules about programming practices is that one can miss out on many benefits of of... 13 August 2009 14 min read
Bart Read .NET Reflector Support: How do I report a bug in one of the add-ins? The best way to report a bug in an add-in is to contact the add-in author directly. Andrew Clarke maintains... 11 August 2009 1 min read
Bart Read .NET Reflector Support: How do I install add-ins? Andrew Clarke has written an excellent article describing how to install .NET Reflector add-ins, as well as listing many of... 11 August 2009 1 min read
Tony Davis Database Trampled by Godzilla View For the older generation of SQL developers, discouraging the use of views is tantamount to accusing a respectable aging dowager... 06 August 2009 3 min read
Bart Read .NET Reflector Support: How do I refresh the assemblies list? You might want to do this if you’ve got an assembly open, into which you’ve recompiled some changes. It’s pretty... 05 August 2009 1 min read
Richard Morris Chuck Moore: Geek of the Week Charles Moore is one of the greatest ever programmers. The 'Forth' language he invented is still in use today, particularly... 05 August 2009 13 min read
Rodney Landrum SQL Server Tacklebox Free eBook As a DBA, how well-prepared are you to tackle issues such as backup failure due to lack of disk space,... 04 August 2009 3 min read
Phil Factor Stolen Pages, Ad-hoc queries and the sins of dynamic SQL in the application. &nbs… 03 August 2009 11 min read
Shawn McGehee SQL Backup 6: Wind of Change One could be forgiven for thinking that there is little more you can do with any third-party Backup software than... 03 August 2009 15 min read