Last week I was at the PASS Summit in Charlotte, North Carolina. It was my second time attending the summit and also my second time speaking at the summit. I think they said that this was something like the 15th year for the summit. There is nothing like getting together with a couple thousand other professionals who have professional and/or personal interests in the same things you do. It is an opportunity to talk with collegues that you may only communicate with through email or twitter throughout the rest of the year. It is also a chance to reconnect with existing friends and to make new friends who share the same interests as you.
This year, the number of sessions dedicated to business intelligence and the Microsoft BI stack has grown. Part of that is that the BI stack itself has expanded with everything from the tabular model in SSAS to augment the multidimensional model to Data Quality Services (DQS), Master Data Services (MDS), Power Pivot, Power View, Power Map, Power Query and Power Q&A. (If you would like to try some of the latest members of the BI stack, go to: http://office.microsoft.com/en-us/excel/power-bi-FX104080667.aspx ). Of course, PASS also supports a separate BI conference that is scheduled for the spring. However, the interest in business intelligence was especially interesting to me because of my personal interest in the entire stack of tools since the introduction of PowerPivot several years ago.
Personally, I’m looking forward to one more SQL Saturday this year, the Tampa SQL Saturday, BI Edition (http://www.sqlsaturday.com/248/eventhome.aspx ) which happens on November 9th. I will also be speaking there so if any of you have an interest in BI topics, come out to Tampa in a little over 2 weeks and say, ‘Hi!’. The BI edition of SQL Saturday was founded in Tampa several years ago by Jose Chinchilla and I’m glad to have been a part of each subsequent annual event.
Other events that are coming up are the monthly meetings of both Orlando SQL groups. The south group, MagicPASS (http://magicpass.sqlpass.org/ although I don’t think the web site has been updated), will be meeting in Celebration, FL on Wednesday, October 23rd and the north group, OrlandoPASS (http://orlando.sqlpass.org/ ), will be meeting in Sanford, FL on Thursday, October 24th. If you are more into SharePoint, there is a meeting of the Tampa SharePoint group on Tuesday, October 22nd at 6:00 PM to 8:30 PM at the Microsoft Office, Tampa (https://www.eventbrite.com/event/8853808981/). It is a busy week as you can see.
The other news that you may have already heard is that the CTP2 of SQL Server 2014 was released last week during the PASS Summit. I have not looked into 2014 yet so I don’t have a recommendation one way or the other. However, if you have processes that would benefit from improved performance, the new Hekaton engine in SQL 2014 may be able to provide some performance improvement with very little effort (read that as no program changes). During the Summit, the Thursday keynote was presented by David DeWitt who tried to explain the technology behind how Hekaton achieves its performance gains. Most people left the keynote with their heads hurting trying to understand the magic behind the technology. However, it seems like the magic might be summarized by the combination of the elimination of latches and locks thus reducing the amount of contention when accessing data along with efficiencies with the new column store method allowing more data to be read into memory reducing disk access for many operations. Of course that may be too simple and probably incomplete. Afterall, my head started to hurt as well.
Well, that’s it for this week. I guess it was more of a summary of what I’ve been up to and why I did not have much time to post any blogs for the last two weeks. I’m sure my text here does not even begin to do justice to the excitement of the summit, so perhaps it would be better if I just left you to go out to the summit site and watch some of the interviews and keynote talks here: http://www.sqlpass.org/summit/2013/PASStv.aspx.
C’ya next time.