PASSMN Rocks 2012!

Minnesota SQL Server Users Group

As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN.  I work with a great group of individuals who have worked hard to get our upcoming speaker schedule and sponsorships worked out.  I am very excited to discuss the upcoming schedule and invite anyone in our area during this time to join us.  So here goes…

Locked In

Tuesday, March 20 – Thomas LaRock

Tom LaRock (@SQLRockStar) is a SQL Server MVP and he is currently a Senior Database Administor for Confio Software.  Check out his blog at for more information about him and his community contributions.

Topic: TBD

Sponsor: Confio Software

Tuesday, April 17 – Ted Kummert, Mark Souza, and Itzik Ben Gan

Ted Kummert is the corporate vice president of the Business Platform Division at Microsoft which includes SQL Server and SQL Azure.  It is a privilege to have Ted available to speak at our user group and share more about SQL Server.  He was one of the keynote speakers at the PASS Summit in 2011 as well.

Mark Souza joins us this night as well.  Mark is the General Manager for SQL Server at Microsoft.  He is responsible for customer and partner interaction for many products including SQL Server.

Topic: SQL Server 2012

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ and has been a SQL Server MVP since 1999.  He is the foremost author and speaker on T-SQL related topics.  He is a regular presenter at PASS events including an annual favorite at the PASS Summit.  Check out Itzik’s website to learn more about him:

Topic: Apply T-SQL Magic

Sponsor: TechFuse Conference

Tuesday, May 15 – Lara Rubbelke

Lara Rubbelke (@SQLGal) is one of our own.  It wasn’t that long ago that she was helping form this very user group. Now she regularly presents on Big Data for Microsoft including during one of the key notes an the 2011 PASS Summit.  Read more from Lara at her blog:

Sponsor: Emergent Networks

Topic: Big Data Architectures

Tentatively Scheduled

Tuesday, June 19 – Jes Borland

Jes Borland (@grrl_geek) joins us from our neighbor state of Wisconsin.  She is an active member of the Wisconsin SQL Server User Group and MADPASS.  She has presented at the 24 hours of PASS and the PASS Summit.  Check out her blog:

Tuesday, July 24 – Kalen Delaney

Kalen Delaney may join us in July as she will be teaching a class at Benchmark Learning during that time.  Kalen is the author of Inside SQL Server and one of the original founders of PASS.  She has been a SQL Server MVP since 1993.  You can find out more about Kalen and her upcoming classes at

Local Presenter Spotlight

Besides the individuals above, we are also looking forward to hearing from our user community in our monthly, local presenter time slot.  If you are looking for an opportunity to share a new tip or something you have learned about SQL Server – development or administration – please let our program director know.  We want our user group to actively involve users from our own community.  We also would love to grow our speaker ranks from within the community.  We all started our speaking somewhere, let PASSMN be the place to help you learn to present or practice presenting.

If you are interested in presenting at our user group or sponsoring our user group, drop us a line at


PowerPivot and Market Research

This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for the purposes of Market Research at Minnesota School of Business.  A friend of mine, Shane Smith, is teaching this class and invited me to show how the tools I work with every day can help his students analyze data for marketing.

The Setup

The class was analyzing the results from a survey they conducted at the school as a part of a market research project.  The survey had five questions with various types of answers such as Yes/No and multiple choice.

Shane wanted to show the class that using technology, they could glean more results from their survey.  This process would also help them understand the effectiveness of the survey they created.

The Data Prep

For my part, I wanted to introduce them to what I do – business intelligence solution design and implementation.  I also wanted to introduce them to the specific tools which they could use to analyze their results for the project.  In this case, we were using Excel 2010 and PowerPivot for Excel 2010 (SQL Server 2008 R2 version).  The final goal was to help them see that these tools can be used to analyze data in real world scenarios.

Shane provided me with the initial survey results in an Excel spreadsheet.  I took that data and flattened some of it out and turned some of it into data that math could be performed on.  For example, I took a multiple choice survey question with 5 possible values and turned it into 5 columns of data with 1 and 0 as possible values so additional calculations could be done on it.  We also created the equivalent of a dimension by taking one of the multiple choice questions and creating a new sheet with possible values and labels.

The Cool Stuff

I took the sheet we updated the data on and I walked the class through the process of bringing that data into PowerPivot.  This included building a relationship between the dimensional data and the primary survey results which were on two sheets in the source workbook. From there, we generated a couple of pivot table views and some charts.  Next, they came up with other ideas of what data to look at and how they wanted to see it presetned. I walked them through the process of prepping the data as necessary.  Then we created more visualizations and presentations of the data that helped them better analyze their results.

The Wrap Up

Kudos to the Microsoft team that put this toolset together.  These students, who are not technologists, gained confidence in the use  of PowerPivot for their project. They are also now set up to use it in the future for similar projects or even their jobs. Because of its ease of use, it was a great demo and training session on using tools to analyze data.

I had a lot fun sharing the technology that I work in regularly with users who would not have tried to do this on their own.  Tools like PowerPivot enable users to turn their data into usable information on their own.  While there will always be a need to build enterprise solutions, this fills a gap in the marketplace with a tool many are already familiar with.

I hope the students are able to continue to use the tool and find a place for it in their workplace in the future.  If you have not yet given PowerPivot a test run on your own, you can find it here:  We used the 2008 version, but feel free to give either a test run.  Keep in mind that you need Excel 2010 to use PowerPivot.  Best of luck to all of them and any of you who give it a test run.  Feel free to share what your experience with PowerPivot here in the comments.

PowerPivot for Excel Install Issues

At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server 2008 R2) installed on a number of developer machines.  All of the machines were 64-bit running Windows 7. We had Office 2010 32 bit installed in all cases.  The frustration occurred around the error message.

PowerPivot Error Message

We verified we had downloaded the correct version and according to the following Microsoft Support article,, we also confirmed all of our prerequisites were in place.  After going through this verification process, we had one of the developers completely reinstall MS Office and then install the add-in.  However, we were still unsuccessful.  So, we did what all good developers do and got our local desktop support guy, Steve Schuler, involved.  He was able to successfully work through the issue.

Here are the steps that Steve discovered which allowed us to successfully get the PowerPivot add-in installed.

  1. Save PowerPivot_for_Excel_x86.msi to a local folder.
  1. Right click on Command Prompt and choose Run as Administrator.
  1. Type msiexec/i c:\data\PowerPivot_for_Excel_x86.msi  into the Command window.
  1. Launch Excel and choose Accept when prompted to install PowerPivot.

If PowerPivot does not show in the ribbon, go to File-Options-Add-Ins and select Com Add-In’s from Manage drop-down list and choose Go.  Confirm that PowerPivot for Excel is selected.  If it is not selected, select it and then choose OK.

The root cause of the issue appears to be related to the security policies and administrative privileges on the machines. In our case, we are all local admins and should not have encountered the issue.  We had inconsistent experiences on many machines that were tested.  In some cases there was no issue and then in other cases we could only install with the steps above.

Thanks again to Steve for a job well done.