posted on Monday, June 11, 2007 9:59 AM by bknight

Favorite BI Features in SQL Server 2008

If you haven’t heard yet, CTP 3, which is a public beta of SQL Server 2008 has now been released and can be downloaded at the Connect website. After a bit of unscientific research, here’s my top 5 BI features in SQL Server 2008. It’s ordered in my priority order. It’s important to note that some of these features have not been introduced in CTP 3 yet but will be coming soon.

  1. No more IIS requirement for SSRS! – Finally, there’s not the overhead of having to install IIS as part of the popular reporting tool.
  2. CDC and Merge – While this is a database engine improvement, it will tremendously help your BI effort in SSIS. The ability to do Change Data Capture on a SQL Server table will help warehousing scenarios and reduce your load time by a factor of 9x.
  3. SSRS scalability – The reporting engine has been significantly improved to scale to million row reports. Also introduced is a best of both worlds table and matrix style report called tablix.
  4. SSIS thread scheduler improvements – In some early testing, the thread improvements have netted a 20-70% improvement in data flow performance. The main improvement is going to be with a long list of synchronous transforms.
  5. Authoring Reports in Excel and Word – Thanks to some smart licensing of Soft Artisians’ product suites, you’ll now be able to author a report in Word or Excel. I would expect this to be a pretty big blow to competing reporting platforms since users will be able to write reports in where they spend most their time in.

-- Brian Knight


# re: Favorite BI Features in SQL Server 2008

Wednesday, June 20, 2007 11:04 PM by John Louis
Great, Exporting to Word and Excel is a execellent feature

# re: Favorite BI Features in SQL Server 2008

Wednesday, October 31, 2007 10:17 AM by obsid
Exporting to word is nice, but it could always export to Excel. The better feature is being able to create reports in word/excel, thats really cool

# re: Favorite BI Features in SQL Server 2008

Friday, December 21, 2007 2:26 AM by Eric
I’ve been anxious to get my hands on SQL Server 2008 but haven’t had the chance yet mainly due to time constraints. Currently I am still using SQL Server 2005 and it works well enough for me but it’s really starting to show and feel its age. When that was first released it solved many of my <a href=>provisioning</a> issues. Now that almost 3 years have passed I’m starting to have some troubles and slow downs when introducing new software applications into my network. I’m sure that 2008 will somehow allow this process to become more efficient but I won’t know until I download the beta!

# re: Favorite BI Features in SQL Server 2008

Monday, March 10, 2008 1:02 PM by PedroCGD
Hi Brian,
And the new version os SSRS08 allow create data sources when querying SSAS cubes in a multidimensional view? Or still with bidimensional view?!!