Richard Morris Exporting our Competence There are several initiatives that have ambitions to replace the Internet. Some of these, in the States and Europe, we... 05 February 2008 11 min read
Richard Morris The Seven Billion Dollar Man When the incredible news broke, last week, that a trader at the third-largest bank in France, the Société Générale, had... 29 January 2008 10 min read
Alex Kozak Numeral Systems and Numbers Conversion in SQL Numeral systems can be fascinating. In everyday programming, we are now becoming quite insulated from the need to convert between... 10 December 2007 19 min read
David Leibowitz Reporting at the Top In Reporting Services, It is not difficult to provide flexible grouping and to display the detail records in a drill-down... 26 October 2007 15 min read
Timothy Ford Greetings from the Alpaca Mill Timothy Ford fails to make the leap from his cubicle to the Alpaca farm, due to the help, sympathy and... 06 September 2007 7 min read
Simon Sabin What Specification Server Should I Buy? Simon Sabin explains why he is always cagey about giving advice on the sort of hardware to run SQL Server... 13 August 2007 5 min read
Alex Kuznetsov Close These Loopholes in Your Database Testing Alex starts of a series of articles on 'Unit Testing' your database development work. He starts off by describing five... 31 July 2007 7 min read
William Brewer Database High-Availability: Soup to Nuts William Brewer argues that, although there are technologies around that will minimise downtime in most circumstances, they are only part... 31 May 2007 14 min read
Adam Machanic A Primer on Managing Data Bitemporally In systems that require, for auditing purposes, advanced logging and reproducibility of reports between runs, a straightforward update, insert, or... 10 May 2007 8 min read
Eric Brown Troubleshooting with Dynamic Management Views If you work with SQL Server 2000, then you know how painful it is to triage a server that has... 12 April 2007 5 min read
Robyn Page SQL Server XML Cribsheet If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out... 29 March 2007 17 min read
Keith Fletcher Creating Cross Tab Queries and Pivot Tables in SQL For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored... 27 March 2007 18 min read
Jesse Liberty and Alex Horovitz Getting Started with XAML See for yourself the flexibility of XAML, as Jesse Liberty and Alex Horovitz show you how to create an interactive... 16 March 2007 12 min read
Phil Factor The March of Technology In which Phil, under the influence of a surfeit of lobster, some fine wine and a large book, conjures up... 28 February 2007 9 min read
Grant Fritchey SQL Server Error Handling Workbench Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000... 20 February 2007 15 min read
Jeff Hewitt Building Active Directory Wrappers in .NET The ability to authenticate .NET application users against Active Directory is a common requirement. Here, Jeff Hewitt demonstrates how to... 09 February 2007 18 min read
Phil Factor Robyn Page SQL Server Excel Workbench The need to produce Excel reports from SQL Server is very common. Here, Robyn Page and Phil Factor present practical... 06 February 2007 15 min read
Dan Sullivan Managing SQL Server using PowerSMO Most DBAs don't have time to perform routine processes manually. Everything has to be scripted, automated and scheduled. Here, Dan... 31 January 2007 22 min read
Richard Morris Why editorial freedom is worth fighting for One of the biggest challenges in running any publication is balancing editorial freedom ...the ability to report on all events... 05 January 2007 9 min read
Phil Factor On Training Your IT Manager A keen new manager, with ambitions to make his mark, can cause all sorts of unpleasantness in the workplace. Phil... 23 November 2006 10 min read
