New sample database – AdventureWorks light

Microsoft have released a new sample database for SQL Server 2005 which is much simpler than AdventureWorks. It’s still based on the same scenario, and it still (frustratingly) uses singular table-names (like Person, not People), but this is certainly going to be useful for all kinds of demonstrations. It really helps to have a model … Continue reading New sample database – AdventureWorks light

ANZ MVPs feed

MVPs from Australia and New Zealand now have a feed you can subscribe to. Check it out at http://feeds.feedburner.com/AusNZ-MVPs – a variety of topics, that I’m sure you’ll enjoy!

Coalesce is not the answer to string concatentation in T-SQL

I’ve seen many posts over the years about using the COALESCE function to get string concatenation working in T-SQL. This is one of the examples here (borrowed from Readifarian Marc Ridey). DECLARE @categories varchar(200)SET @categories = NULL SELECT @categories = COALESCE(@categories + ‘,’,”) + NameFROM Production.ProductCategory SELECT @categories This query can be quite effective, but … Continue reading Coalesce is not the answer to string concatentation in T-SQL

Meet the Robinsons in amazing 3D

Being a parent, I went to see the new Digital 3D movie Meet the Robinsons over the weekend. The film itself is a little predictable, and not much to really blog about, but the Digital 3D is really impressive. It uses Disney Digital 3D technology  (a rebranding of Real D) like Chicken Little and Monster … Continue reading Meet the Robinsons in amazing 3D

Vista requiring ctrl-alt-del before login

So you want to tell Vista to require Ctrl-Alt-Del before you can logon. Just like you had in previous versions of Windows. And it’s easy to do, you just have to find the proper dialog box, like the one below. You tick the checkbox, and everything is done. Now, this dialog box should be easier … Continue reading Vista requiring ctrl-alt-del before login

Some new CodeCamp MVPs

It’s great when a new quarter starts, because we get to find out who the new MVPs are. This time, my good friend Peter Ward has received the gong in the SQL world, and in the Dev world, friends Grant Holliday and Paul Stovell (both from Readify) have been honoured. Great news guys – thoroughly … Continue reading Some new CodeCamp MVPs