SQL Centre of Excellence

If you’ve been to the recent SQL 2012 Road show last week , you may have noticed that we were using CTP3 for the demos.

Well, release candidate 0 is now available for download, with more features for Power View and some of the items we demo’d


The Hyper- image with all the components pre loaded has not yet been updated, so if you can’t wait like us, you’ll need to start installing Winking smile

We've just finished the SQL 2012 Road show  featuring Always On, BISM, PowerPivot 2.0 and Power View (formally project crescent).

There are a few more features coming in RTM that we could not demo, but be aware that they will be adding value to what you can currently see. More details are available on the reporting services blog here http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/10/13/power-view-pass-and-mobile.aspx 

1. Multi View

Charts can now be split up into multiple “regions” adding more options to data visualisation

2. Export to PowerPoint

I was a bit concerned this feature would be cut as it appeared in very early demos and then disappeared in CTP3, but good news is it looks like this feature is back to stay.

3. Self Service Alerting

From SharePoint you can now create alerts based on the data.

4. A Roadmap is announced for “mobile” BI to enable project crescent and other tools on mobile devices, even Apple iPads!! This wont be early 2012, but should be later in 2012 looking at the released roadmap.

A few people have asked for links to sample BISM data models and reports to demo Project Crescent or Power View.

There are two main choices

1. The official site has a Hello World Picnic or Adventure Works examples which are quite cute

2. You can download an entire VHD (needs Hyper-V) that contains the whole stack including the TailSpin Toys database, BISM project and sample reports. Be warned this is 60GB or so.


I’m using the Tailspin toys are the moment, but the Hello World Picnic is a much smaller download if you are not using the massive CTP image/VHD.



SQL 2012 Road show

by Bob Duffy 8. November 2011 15:57

So far we have completed the SQL 2012 road show in Dublin and Belfast. Sandra has put some of the pictures up on the Prodata Facebook site here

The agenda for all shows is:

-SQL 2012 overview (15 mins)

-Always on Deep Dive (90 mins)

-Introduction to BISM (90 mins)

If you couldn’t make the road show, or have been to the road show and want to show some of the content to your colleagues I’ve uploaded the decks here:

Page List

Page List