December 2012 - Posts

• Database unit testing is now available for SSDT

  Good news was announced yesterday for those that are using SSDT and want to write unit tests, unit testing functionality is now available. The announcement was made on the SSDT team blog in post Available Today: SSDT—December 2012 . Here are a few thoughts Read More... Posted Friday, December 14, 2012 1:47 PM by jamiet | 4 Comments Filed under: unit testing, SSDT

• Editing sqlcmdvariable nodes in SSDT Publish Profile files using msbuild

  Publish profile files are a new feature of SSDT database projects that enable you to package up all environment-specific properties into a single file for use at publish time; I have written about them before at Publish Profile Files in SQL Server Data Read More... Posted Monday, December 10, 2012 2:42 PM by jamiet | 1 Comments Filed under: msbuild, MSBuild Extension Pack, XPath, SSDT

• Query for server DefaultData & DefaultLog folders

  Do you ever need to query for the DefaultData & DefaultLog folders for your SQL Server instance? Well, I just did and the following script enabled me to do that: DECLARE @HkeyLocal NVARCHAR ( 18 ), @MSSqlServerRegPath NVARCHAR ( 31 ), @InstanceRegPath Read More... Posted Monday, December 10, 2012 1:10 PM by jamiet | 2 Comments Filed under: sql server

• The current state of a MERGE Destination for SSIS

  Hugo Tap asked me on Twitter earlier today whether or not there existed a SSIS Dataflow Destination component that enabled one to MERGE data into a table rather than INSERT it. Its a common request so I thought it might be useful to summarise the current Read More... Posted Friday, December 07, 2012 12:18 PM by jamiet | 2 Comments Filed under: merge, sql server integration services, ssis

• The perils of double-dash comments [T-SQL]

  I was checking my Twitter feed on my way in to work this morning and was alerted to an interesting blog post by Valentino Vranken that highlights a problem regarding the OLE DB Source in SSIS. In short, using double-dash comments in SQL statements within Read More... Posted Thursday, December 06, 2012 10:21 AM by jamiet | 17 Comments Filed under: t-sql, sql server, sql server integration services, ssis

• Documenting sp_ssiscatalog

  What is the best way to document an API ? Moreover, what is the best way to document a T-SQL API? Before I try to answer those questions I should explain what I mean by “a T-SQL API”. I think of an API as being a collection of well-defined, known, code Read More... Posted Wednesday, December 05, 2012 12:19 AM by jamiet | 1 Comments Filed under: t-sql, sp_ssiscatalog