Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

PASS Summit Wednesday Key Note 3


More demos using Analysis Services from R2. They’re showing how you can refresh data & reports without having to write a bunch of SSIS packages. That’s pretty cool too. You can actually connect to Excel now and pull data into SSAS to manage the data like it was a database. You’re going to have to spend time managing these files like they were servers.

Analysis services is starting to manage itself? I hate to say this, but I’ve heard that kind of statement before from MS. It wasn’t true then. Is it true now? No idea yet, but the small part of me that doubts these things just fired up.

The reports can be animated. Data in motion is pretty darn slick to watch.

Powerpivot is a freebie that runs in Office 2010. You can put it to work in SharePoint through shared documents and it all runs on top of  SQL Server 2008 R2. It’s going to require a pretty major set of upgrades in peoples offices to get this stuff running. It’s going to be difficult when most of us are still running SQL Server 2000 systems.

And Microsoft is giving away an XBox. Go here.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.