SSIS – SQL Server 2008 R2 & Integration Services Features (or not)

Matt Masson of the SSIS team has announced publicly that there are no new features for SSIS being released in SQL Server 2008 R2. Think that’s bad news? Think again – the team is hard at work on the next release (the term I’ll use for now) and based on some discussions I’ve been involved […]

Read more
SQL Server Ordering – in order or not in order

There seems to be some misinformation going around about how SQL Server works with ordered data, especially with how the data is *physically* stored, even with a clustered-indexed table. Please see this post for more details on SQL Server ordering: http://blogs.msdn.com/sqltips/archive/2005/07/20/441053.aspx To add to that list a bit: Updates are (almost) the same as select […]

Read more
24 Hours of PASS – Free SQL Server training for 24 straight hours!

The PASS team has assembled a unique opportunity for those wishing to expand their SQL Server knowledge, be it in database administration, business intelligence (including, of course, SSIS), blogging, etc…, can attend one or more sessions (out of a total of 24) for free by registering here: http://24hours.sqlpass.org/ No matter where in the world you […]

Read more
SQL Server – Project code-named “Madison” ships first technology preview

It would seem that the DATAllegro acquisition is complete as Microsoft has shipped its first technology preview of the project code-named “Madison” to ten customers for their feedback. Madison looks to be quite the offering, allowing for rapid growth of a data warehouse architecture because of its “appliance” model as well as integration with existing […]

Read more
SQL Server 2008 – Maintenance Plans and SSIS Requirements

For those of you that wish to execute maintenance plans on a server and do not wish to have SSIS installed on said server, you will run into issues if you are on an RTM version of 2008 (version 10.0.1600). The specific error message is “The SQL Server Execute Package Utility requires Integration Services to […]

Read more