Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2. You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there are a couple of new breakthroughs. Most notably is the new vardecimal data type, which is as its name suggests a variable length decimal value (though the initial press release indicated that this is an Enterprise Edition feature only). Also included is improved integration between Reporting Services and the SharePoint Portal system, a number of fixes for SSAS and SSIS, and dozens of minor housekeeping items.