January 2010 - Posts

• Tweetpoll and RESTful Northwind go bye-bye

  On 31st January 2010 Windows Azure and SQL Azure will transition to becoming services that you have to pay for which means that my three small demos that are hosted up there are going to disappear hence I thought now would be a good time to review before Read More... Posted Saturday, January 23, 2010 11:25 AM by jamiet | 0 Comments Filed under: SQL Azure, Azure, twitter, twittercache, Northwind, tweetpoll, codeplex

• “Excel found unreadable content” when exporting a Reporting Services report

  [This is just a quickie, I’m putting it up here for anyone that received the messages above and searches for it online!] Earlier today my team experienced some issues with a Reporting Services report that when attempting to export to Excel would cause Read More... Posted Friday, January 22, 2010 9:16 PM by jamiet | 2 Comments Filed under: sql server, SQL Server Reporting Services, excel, reporting services

• The SQL developer gap (Warning: rant coming up)

  I recently submitted a bug to Microsoft Connect concerning the behaviour of the expression language in SSRS, if you’re interested you can read about it here: DateAdd() doesn't throw an error when it has invalid parameters . I got a swift and detailed Read More... Posted Wednesday, January 13, 2010 12:43 AM by jamiet | 13 Comments Filed under: sql server, ssis, SSRS, SSAS

• MERGE and OUTPUT – the swiss army knife of T-SQL

  The new T-SQL MERGE statement in SQL Server 2008 seems to be finding many uses over and above its de facto UPSERT usage scenario, probably the most popular of which is its ability to update one table from another in an ANSI-compliant manner as detailed Read More... Posted Wednesday, January 06, 2010 7:46 PM by jamiet | 6 Comments Filed under: merge, t-sql