Katmai for the BI Guy

I attended a session yesterday here at TechEd 2007 in Orlando – DAT 201, SQL Server 2008 “Katmai” Overview with SQL Server General Manager David Campbel presenting. Although there was very little detail information, it was quite a good session, as it presented a nice survey-level overview of the features coming in SQL Server 2008.

The development process for Katmai was structured differently from previous SQL Server releases. Instead of each team building their own feature in isolation, development was structured around “themes”[1] and within each theme there are scenarios, where each scenario encompasses a group of features. Also, a single feature can help complete multiple scenarios.

The theme that is most relevant to business intelligence developers is the “Pervasive insight” theme. This theme has three scenarios, with quite a few features included. Here’s the deal:

Scenario: Integrate all data into enterprise data warehouse

  • Enterprise partitioning parallelism
  • Enhanced DW query optimizations
  • Data compression
  • Resource governor
  • Persistent lookups
  • Change data capture – find those changed records since last point
  • MERGE (UPSERT!!) SQL Statement (how will this affect SCDs?)
  • Data profiling

Scenario: Reach all users with a scalable BI platform

  • Scalable report engine
  • Scale out analysis
  • Subspace computations
  • Streamlined analysis tools
  • Scalable backup tools
  • New cube design tools
  • Best practice design alerts
  • IIS agnostic report deployment – Host SSRS w/o IIS

Scenario: Empower every user with actionable insight

  • New Word rendering
  • Improved Excel rendering
  • Report builder enhancements
  • Rich formatted data
  • Enhanced data visualization
  • MOPLAP enhanced writeback
  • And there was one more feature bullet here, but they moved on too quickly before I could write it down.

Sadly, I do not yet have the information to drill down on many of these feature bullets, but hopefully there is enough here to whet your appetite as it has whetted mine…

[1] I’ve heard other product groups use the term “pillar” to describe similar high-level meta-feature groupings.

Advertisements

About ssimagine

My name is Matthew Roche, and I am a Senior Program Manager with the SQL Server product group at Microsoft. I work on Master Data Services and Data Quality Services, and have previously worked on SQL Server Integration Services. Although I work for Microsoft and will be posting on technical topics, I want to stress that this is a personal blog, and any opinions posted here are mine and mine alone. I built my career around SQL Server and Microsoft technologies for well over a decade before I joined Microsoft as an employee, and I plan on using this blog to share my personal experience and opinions. They may well be shaped by my experience on the SQL Server team, but they’re still mine, and not that of Microsoft, disclaimer, disclaimer, etc., etc..
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s