#SQLSat85 - Orlando

Just got back from #SQLSat85 in Orlando -

I thought it was great!

Started off with Bill Pearson's MDX class - great presenter!!

After that, same room, @Adam_Jorgensen presented from "Zero to Cube" - learned some good stuff!!

Then chatted with Bill for awhile about the industry and future of BI.

Next was lunch - some good B-B-Q.

Chatted with some of the Tampa Bay BI Chapter posse.

Then sat in a BI class -

Same room, listed to Kyle Walker present "SSRS Subscriptions" - good information as well as SSIS demo on how to email multiple PDF files using Pragmatic Works custom control for SSIS.

Last, same room, Bill gave a good presentation on DAX - a lot of smart people in the room including an Access MVP who asked some good questions.

Had to get back to Tampa Bay - left around 4pm - got home 6pm in time for dinner - and now a cigar!

Thanks to the organizer for a great event all around - my 2nd SQL Sat so far - next one is in Tampa Nov. 5 BI -

Can't wait!


Learning Microsoft BI

So you are finally out of school, that learning was such a drag.

Well, you could get a job as a line operator in a production plant - and you'll most likely never have to learn again if that's what you choose.

However, if you chose the profession of IT worker, chances are you'll never stop learning.

I've been learning a lot lately, as I would like to get to the next level of Business Intelligence.

Let me tell you, there is SO much information out on the web to learn from.

I've been reading about Advanced Analytics in the Microsoft Stack of BI.

First there was the installation of the product.

Then there was downloading and running the sample projects in SSAS.

Then there was PowerPivot and viewing the OLAP Cubes in Excel.

Then there was creating my first KPI and viewing the contents in an SSRS report deployed to the server.

Then there was SharePoint, which I never loaded due to technical difficulties (I haven't given up yet!).

Then there's Performance Point Developer - a snazzy way to produce cool looking Dashboards, Scorecards, KPI all with drill down/up capabilities for the Senior level execs.

The first go-around, I'm trying to digest what the BI stack encapsulates.

Next I'll dive deeper into each of the components until I get a better understanding of how everything integrates together.

The one thing I was real surprised about in this learning exercise was how many smart people there are in Microsoft BI and how willing everyone is to share their knowledge.

I am surprised at how fast I am digesting all the info as I was a little intimidated at first.

I clung to my 15 years of reporting as if that's all there ever will be.

Looking forward to this weeks SQL Saturday in Orlando, Fl.

It's all good!


Installing Sharepoint 2010 after installing Denali doesn't work

I installed SQL-Server Denali on a Windows 7 machine.

After installing Denali, I wanted to load Sharepoint2010.

However, it threw an error when viewing the pre-requisites:

 When attempting the install, I received the following error message:

Will need to research if its possible to load Sharepoint2010 after installing SQL-Server Denali.

This link says it's a know bug...

Tried to download the SharePoint 2010 SP1 from this site --> This did not solve the problem...

This site has promise - can download the patch.