August 2010 - Posts

• Don’t turn the dataflow into a cursor [SSIS]

  I saw a thread on the SSIS forum today that went something like this: I have the following dataset: AccountNo Date DailyMovement 00000001 28/08/2010 10 00000001 29/08/2010 5 00000001 30/08/2010 7 00000002 28/08/2010 8 00000002 29/08/2010 6 for which I Read More... Posted Tuesday, August 31, 2010 11:22 PM by jamiet | 9 Comments Filed under: sql server, sql server integration services, ssis, dataflow, script component

• Microsoft publish Visual Studio 2010 Database Project Guidance

  Three days ago I wrote a blog post entitled Setting up database unit testing as part of a Continuous Integration build process [VS2010 DB Tools - Datadude] which goes through some of the intracasies of using Visual Studio 2010 Database projects (aka datadude Read More... Posted Monday, August 23, 2010 1:33 PM by jamiet | 1 Comments Filed under: sql server, Datadude, Visual Studio 2010, unit testing

• Setting up database unit testing as part of a Continuous Integration build process [VS2010 DB Tools - Datadude]

  [This blog post assumes a familiarity with the terms Continuous Integration (CI), MSBuild & MSTest. If you don’t have a good appreciation of those terms then this blog post probably isn’t for you anyway so don’t worry about it!] Over the past few Read More... Posted Friday, August 20, 2010 8:41 PM by jamiet | 18 Comments Filed under: sql server, Datadude, msbuild, Visual Studio 2010, unit testing, mstest, Continuous Integration

• Be wary of using UNC paths in SSIS packages

  I have recently discovered what I believe to be a bug in SQL Server Integration Services (SSIS) 2008 and am taking the opportunity herein to warn about it so that nobody else gets stung by it. The bug concerns the use of Uniform Naming Convention (UNC) Read More... Posted Thursday, August 19, 2010 9:15 PM by jamiet | 11 Comments Filed under: sql server, Connect, sql server integration services, ssis

• "Only SSRS 2005 reports can be opened in SSMS 2008 R2"

  In yesterday's blog post Introducing sp_CascadingDataViewer I mentioned that one of the artifacts up at http://cascadingdataviewer.codeplex.com is a SQL Server Reporting Services (SSRS) report that visualises the output from sp_CascadingDataViewer and Read More... Posted Thursday, August 12, 2010 3:47 PM by jamiet | 2 Comments Filed under: sql server, sql server 2008, sp_CascadingDataviewer

• Introducing sp_CascadingDataViewer

  In September 2009 I wrote one of my first blog posts on SQLBlog entitled Deriving a list of tables in dependency order . In it I provided a SQL statement that would return a list of all tables in a database in what I called dependency order i.e. by adhering Read More... Posted Wednesday, August 11, 2010 11:59 PM by jamiet | 11 Comments Filed under: sp_CascadingDataviewer

• SQL Social - Kent

  This is a short blog post to give a shout out to to the inaugural SQL Social event in Kent, England that is happening on 18th August 2010. For details go to: http://sqlsocialkent20100818.eventbrite.com/ Here’s the agenda: 7:00 Dave Ballantyne ( blog | Read More... Posted Tuesday, August 10, 2010 10:48 PM by jamiet | 0 Comments

• SSRS Helper Code : Convert a multivalue parameter to a comma delimited string

  Occasionally I use this blog to post bits of code that I might, one day, need again and justify it by telling myself that someone else, somewhere, might need one day need the same as well. This is one such blog post. The following code converts a multivalue Read More... Posted Sunday, August 08, 2010 10:43 PM by jamiet | 6 Comments

• Killing Google Wave reminds me of WinFS

  You may have heard that Google is effectively killing its Google Wave product (see blog post Update on Google Wave ) which is, frankly, not too much of a surprise. Some colleagues (hey Chris, Tom) and I tried to adopt it on our current project but quite Read More... Posted Thursday, August 05, 2010 2:02 PM by jamiet | 2 Comments Filed under: winfs, Google Wave

• The One Billion Node machine plus one

  I have been reading Jas Dhalliwal ’s blog post series on the One Billion node machine ( Part 1 , Part 2 ) with interest where he talks about the notion of a network of machines acting in unison and the opportunities that that presents. In his own words: Read More... Posted Sunday, August 01, 2010 10:34 PM by jamiet | 3 Comments Filed under: Azure, cloud computing