September 2009 - Posts

• RESTful Northwind on SQL Azure

  Introduction I recently gained access to SQL Azure, the hosted database part of Microsoft’s Azure cloud offering. I don’t currently have a reason to use SQL Azure in my day-to-day work so I set myself a small project that would enable me to prod and poke Read More... Posted Thursday, September 10, 2009 12:13 AM by jamiet | 6 Comments Filed under: SQL Azure, Datadude

• Deriving a list of tables in dependency order

  Currently at work I’m on a data warehousing project and one of the things we typically need to do during development is clear down our data warehouse in preparation for simulating a first-time load. I needed to write a script that would loop over all Read More... Posted Tuesday, September 08, 2009 9:51 PM by jamiet | 21 Comments Filed under: t-sql

• Move BOL examples please!!

  Earlier on today I tweeted the following message: Anyone think #sqlserver BOL should have the examples at the top? That's the only bit people read, right?   In other words, the examples that appear in SQL Server Books Online are the most useful things Read More... Posted Wednesday, September 02, 2009 1:04 AM by jamiet | 7 Comments