August 2011 - Posts

• [SSIS] OnPipelineRowsSent event

  Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson but that ended in August 2009 when I left EMC. There is a lot of valuable content over there however certain events in the past leave me concerned that that content is not well Read More... Posted Friday, August 19, 2011 1:48 PM by jamiet | 6 Comments Filed under: sql server, sql server integration services, ssis, dataflow, OnPipelineRowsSent, repost

• London SQL Server User Group - 18th August 2011

  Yesterday evening I had the pleasure of presenting at the London SQL Server User Group meeting. It was a really good evening and I was delighted to meet five people that were making their first visit to the user group - a good sign for the future indeed. Read More... Posted Friday, August 19, 2011 11:51 AM by jamiet | 2 Comments Filed under: sql server, London SQL Server User Group

• Query window custom colouring now works properly [SSMS]

  SQL Server 2008 introduced a new feature that had the potential to be very useful, the ability to color colour-code a query window in SSMS to represent the server that was being connected to. This was configured using the properties of a server in the Read More... Posted Thursday, August 11, 2011 9:28 PM by jamiet | 4 Comments Filed under: sql server, ssms, sql server management studio

• [T-SQL Tuesday] Some code is born crap, some code achieves crapness and some code has crapness thrust upon it!

  I recently returned to a client at which I last worked back in 2006 and, as you might imagine, that gives me ample material for a blog post dedicated to Crap Code; conveniently the subject of the latest T-SQL Tuesday . I first worked for this client back Read More... Posted Wednesday, August 10, 2011 5:04 PM by jamiet | 0 Comments Filed under: t-sql, sql server, T-SQL Tuesday

• On the typeof() campaign trail

  Given a table: CREATE TABLE [person] ( [id] INT IDENTITY ( 1 , 1 ) , [name] VARCHAR ( 100 ) , [age] INT ); How nice would it be to be able to do something like this inside your stored procedures?: DECLARE @person TABLE ( [name] typeof ( [person].[name] Read More... Posted Wednesday, August 10, 2011 10:25 AM by jamiet | 1 Comments Filed under: t-sql, sql server

• SQL_VARIANT_PROPERTY function

  I learnt something about T-SQL today that I never knew and I figure I’m not the only one so it might be worth sharing what I learnt; namely, I discovered the SQL_VARIANT_PROPERTY function. It all started when going over a piece of code that I recently Read More... Posted Wednesday, August 03, 2011 9:50 PM by jamiet | 4 Comments Filed under: t-sql, sql server

• Report Authoring on the SSIS Catalog [link]

  Just a short post here to let you know that the SQL Server Integration Services (SSIS) product team recently invited me to contribute a blog post about authoring reports for SSIS in Denali for their team blog . I was of course only too happy to accept Read More... Posted Tuesday, August 02, 2011 8:47 PM by jamiet | 0 Comments Filed under: sql server integration services, ssis