One-year Anniversary for SQL Server 2005: CTP for SP2

Albeit overshadowed by the upcoming release of Windows Vista and Microsoft Exchange 2007 and the release of the 2007 Microsoft Office System this November, SQL Server is having a big month. This week, we've seen excellent attendance at the Professional Association for SQL Server (PASS) 2006 Community Summit in Seattle. While I was in Las Vegas last week at the well-attended SQL Server Magazine Connections conference, a colleague noted that it was the one-year anniversary of the November launch of SQL Server 2005, Visual Studio 2005, and BizTalk 2006 in San Francisco (for more information see "Planes, Trains, and Automobiles: Backstage for Launch Activity," November 2005, InstantDoc ID 48546), and Microsoft coincidentally chose to release to manufacturing (RTM) Windows Vista and the 2007 Office System during this anniversary week.

So now, one year after the release of SQL Server 2005, conference attendance is at a high, showing that SQL Server attendees want to learn from real-world experiences now that the release has "settled" into their workplace. Outside of conferences, upgrade and migration training and consulting demand is at an all-time high. Interestingly (given an interdependence I will touch on) last week the SQL Server team also released the first public Community Technology Preview (CTP) of Service Pack 2 (SP2). In keeping with a practice first introduced with Service Packs for Reporting Services 2000, Microsoft is using Service Packs to release new features and performance optimizations rather than just patches and bug fixes. We got significant features in SQL Server 2005 SP1 (e.g., the much-anticipated Database Mirroring feature), but SP2 looks like it's going to be a blockbuster, and a lot of it is focused on business intelligence (BI).

Oracle support in Report Builder. Developers will be able to build Report Models that use Oracle relational data sources, so users will now be able to use Report Builder to access information in Oracle.

Hyperion support with Reporting Services. Organizations will now be able to use Reporting Services to build reports on top of Hyperion Essbase cubes.

Data compression through a new varDecimal data type, which is important for data warehouse scenarios and is specifically important for SAP Business Information Warehouse (BW) scenarios. This requires less disk storage of decimal data, which increases overall performance.

Support for Windows Vista, which means SQL Server 2005 Developer and Express editions with SP2 will be supported to run on Vista.

Editor's Note: SharePoint Pro Online--LIVE! will be a premier virtual event for developers and administrators of SharePoint products and technologies. Brought to you by MSD2D and the Windows IT Media Community, this event will demonstrate, showcase and exhibit the premier companies in the SharePoint market. The conference will bring industry experts to the desktops of attendees, educating them on various SharePoint topics. Register today!

From the Blogs

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More