Welcome to EMC Consulting Blogs

Browse by Tags

• Denali
• DTS
• SQL Server
• SQL Server 2005
• SSIS
• Upgrading SQL Server

• Denali : Using EXECUTE WITH RESULT SETS (example using SSIS Source Adaptors)

  One of my pet peeves about stored procedures is the lack of clarity they provide a user on the data types of returned columns. This is especially applicable when the column returned has been calculated. Consider a statement such as this SELECT 10.0/5. Read More... Posted 16 November 2010 15:36 by James.Rowland-Jones | 8 Comments Filed under: SSIS, SQL Server Integration Services, SQL Server, Denali

• 08.04.08 is SQL2K day

  Well it isn't likely to cause quite the same stir as Y2K but I thought it was a significant date for everyone's diaries... On the 8th April 2008 Microsoft withdraws mainstream support for SQL Server 2000. Look here if you don't believe me. Read More... Posted 18 February 2007 16:40 by James.Rowland-Jones | 1 Comments Filed under: SQL Server 2005, Upgrading SQL Server, SSIS, DTS, SQL Server Integration Services