Shovell: An ASP.NET Demo Application for ANTS Performance Profiler 6
by Bart Read | 28 July 2010
I've been using an ASP.NET application, which my colleague Alex wrote some time ago: a simple Digg clone called Shovell. I've been planning to publish the application for a while, and have finally got round to posting it up here, along with full installation and usage instructions.
VALUES() and Long Parameter Lists
by Joe Celko | 22 July 2010
| 
13 comments | 
To make progress as a relational Database programmer, you have to think in terms of sets, rather than lists, arrays or sequential data. Until that point, you'll feel the need to pass lists, arrays and the like to functions and procedures. Joe suggests some unusual ways around the difficulty and broods on the power of the VALUES constructor.
Raw Materials: Command-Line Nostalgia
by Larry Gonick | 28 July 2010
| 
Arthur finds philosophy deep in a dialog box.
Defensive Database Programming with SQL Server
by fatherjack | 17 July 2010
| 3 comments 
It's a little like having a security firm visit your house and tell you about the weaknesses that a criminal might exploit and best practices that you can adopt to make yourself less vulnerable. Alex covers clearly and explains how and why they could be problems before providing working examples of how to avoid getting caught out.
Automate and Improve Your Database Maintenance Using Ola Hallengren’s Free Script
by Brad McGehee | 20 July 2010
| 7 comments | 
If you ever feel uneasy when you set about handcrafting database maintenance jobs for SQL Server, it may be the voice of your conscience saying 'Ola, Ola!'. Follow your conscience. Ola Hallengren has already crafted a superb set of routines to do this for you. Why reinvent something that does it all, safely and well. Brad McGehee explains....
Implementing the OUTPUT Clause in SQL Server 2008
by Robert Sheldon | 22 July 2010
| 1 comment | 
In retrospect, it was probably the inclusion of the OUTPUT clause in the MERGE statement that gave SQL Server 2008 its most powerful SQL enhancement.. It isn't the easiest of features to explain, but Bob does it in his usual clear and careful way.
SQL Source Control: The Development Story
by Andrew Clarke | 22 July 2010
| 
Often, there is a huge difference between software being easy to use, and easy to develop. When your pilot users tell you "by week three of any development project you've thrown out anything that takes time or just gets in your way", then it is time to be serious about usability, as well as quality. We decided to find out from some of those at the sharp end of the development of Red Gate's SQL Source Control.
Product Review: Schema Compare for Oracle
by Bruce Armstrong | 23 July 2010
| 1 comment | 
One of the more important tasks in the process of rolling out incremental developments to a multi-server production system is to double-check that all of the planned modifications, and nothing else, have been deployed. An Oracle expert, Bruce Armstrong, comes across SQL Compare for Oracle, and sees if it helps with this time-consuming task.
Giancarlo Niccolai: Geek of the Week
by Richard Morris | 07 June 2010
| 
Falcon isn't exactly new. It is a scripting language that is designed with a number of programming paradigms for multi-threaded applications. It is growing rapidly in importance. Richard Morris decided to contact Giancarlo, the language's creator, find out why there was so much interest in it.
iWorry
by Laila | 16 July 2010
| 5 comments 
It is an interesting time for any .NET developer wanting to develop software for mobile phones. We've always taken it for granted that there would be a good .NET platform for mobile phones. Surely Microsoft aren't going to fumble the key component, Windows Phone 7, after getting the development tools so right.