If you would like a short 10-minute intro on how to get started using the Microsoft Assessment and Planning Toolkit (MAPS) to inventory, discovery and record your SQL Server footprint, versions, utilization, users, licenses, etc., then you can have a look at the video that I just posted on our Microsoft YouTube channel for SQL Server data warehouse & BI group here in the East Coast U.S. field organization: http://www.youtube.com/watch?v=VdHs8Ee1iZI. BTW, the MAPS tool is a FREE download from Microsoft.com, see it here. This is version 6.5 of this tool and if you have any version prior to it, I suggest that you upgrade to it and run another SQL Server assessment on your network. This version of MAPS now has the awesome feature of virtualization discovery, proposal and recommendations built-in. This makes MAPS the premier SQL Server tool when consolidation your SQL Server environment.
I have a couple of really quick loose ends to tie up here in the blogosphere for Microsoft Business Intelligence. Ever since Microsoft acquired Proclarity in 2006, they have shown a real commitment throughout the organization to business intelligence. Microsoft’s investments and focus on democratization of BI and BI for the masses has been a huge success, particularly with self-service for business decision makers and the decision to make BI accessible to Excel and business users.
So, that being said, there are just 3 topics that I want to close up on in my MSSQLDUDE blog this year:
A few friends of mine here in the Microsoft SQL Server & BI field on the east coast here in the U.S. have started a YouTube channel where we are recording our monthly lunch ‘n learn sessions, with a focus on BI & DW: http://www.youtube.com/user/MSFTSQLBIEASTEPG
I have written about the new Enterprise Information Management (EIM) capabilities that SQL Server 2012 is exposing and expanding at blogs such as SearchSQLServer, MSSQLDUDE and SQL Pro BI Blog. I can remember pushing hard for data quality, MDM and expanding those capabilities into ETL through SSIS back in a series of meetings in Redmond in 2007. That is all coming into place now in the SQL Server product and coming to market finally. I wanted to point you all to a nice series of videos to explain how to get started with the DQS product coming in SQL Server 2012 to provide data quality services to your BI solutions here.
Lastly, I wrote a quick blog with an intro to the new Silverlight Power View BI reporting and data exploration tool in SQL Server 2012 here. Unfortunately, the image links do not seem to be working, so I’ve included the thumbnails to th screenshots of Power View and the SharePoint BISM data connection page below. Notice the awesome Silverlight-based data visualizations that you can now generate out-of-the-box with Power View, which is part of SQL Server Reporting Service in SQL Server 2012. You can try this now, today, with the SQL Server 2012 RC0 download.
Sorry that I’ve been so busy lately, I have not yet had time to complete part 1 of my System Center series for SQL Server DBAs. I promise to have the SCOM section out this weekend.
I do want to point you all to 2 updating “goings-on” in my world:
We are running a free 4 hour SQL Server 2008 R2 performance monitoring and tuning seminar sponsored by Sebastian Meine of SQLITY.NET on October 20 in our Malvern Microsoft Technology Center (MTC) here in the Philly burbs. You can register for that free event here.
And I finally got around to complete a new SQL Server Magazine BI Blog post today focused on the SQL Server Denali CTP3 release of SSIS, demonstrating the new version control features here.
I am finalizing my demos and presentations for Philly Code Camp on October 15. You can register here, it is FREE and lots & lots of training on .NET technologies and we have BI & SQL Server tracks. This is the 3rd update to my series on leveraging Silverlight in Microsoft BI to make cool visualizations and dashboards. Code Camp is one of my favorite events of all-time, I always have a great time at these events. I also will update my presentation and demos and post those next week, just prior to the event.
Thanks for to who were able to attend my talk this past Saturday at SQL Saturday Philadelphia on Microsoft BI Silverlight Dashboards. I had a great time and hope that you did, too.
If I missed anything here in this blog or post-session follow-up, please use this thread to ask your questions and we can discuss openly here. Or you can always reach out to me directly.
You can grab the presentation that I used here. And if you would like copies of the Silverlight code for the 1.0 MEC controls from the Microsoft Enteprise Cube project, I made a few of them available here previously. I am working on also making available the Silverlight map and pie chart, too. So keep checking back here to my MSSQLDUDE blog for those updates.
BTW, I promised a link to Silverlight support on the MAC, so here it is.
I have highlighted Bart Czernicki’s book on using Silverlight for Microsoft BI in a few of my blogs and presentations in the past. He is out with a Silverlight 4.0 version for Microsoft Business Intelligence. You can go to his site here. It is an excellent book that I used recently in building out some next-gen dashboard prototypes for customers. I used some of the techniques in a presentation that I did for the NYC SQL Saturday in November.
Those that follow my blogging here and at the SQL Magazine BI blog will know that I lead a solution product at Microsoft a few years ago called Microsoft Enterprise Cube (MEC) where we highlighted RIA UIs, Silverlight, pre-built analytics and ETL and other areas necessary to have a “packaged BI” offering. When I left for Oracle after that project dried up, many of those same concepts were put into Oracle’s “BI Applications” like Project Analytics and P6 Analytics.
But it is heartening to see some of the assets and concepts still interest people and still exist today. I previously posted some of the original Silverlight 1.0 XAML from MEC concept screens and other concepts like the ETL Toolkit expanded over the years. Bart’s book had this to say about those efforts:
Microsoft Enterprise Cube (MEC), which is the epitome of BI 2.0
I think that’s true, although I think that generic Microsoft SharePoint 2010 with SQL Server utilize Fast Search and SharePoint’s messaging capabilities with PerformancePoint Services 2010 probably gets you close to that same point now today. There are Microsoft partners that can do a lot of the same things that MEC was intended to do. Having a pre-built set of ETL, analytics, data models, dashboards and cool RIA UIs can help accelerate time to market and quicken ROI, but it is not necessary, which is probably one of the reasons that products like MEC did not survive as a Microsoft SKU.
Just up with latest post on SQL Mag BI blog to complete the series on Silverlight for Microsoft BI here. It’s a final part of the series that Derek and I worked on to show Silverlight, mobile apps and other cool ways to visualize your Microsoft BI solutions and make them more compelling. Check it out, enjoy and send me your feedback & comments! Thanks, Mark