Rochester – Welcome to the PASS MN Family

22 01 2014

It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At the time, Paul Timmerman ( T | B ) and I were discussing the fact that only one user group existed in Minnesota. As we looked at other areas and talked with SQL pros from St. Cloud and Rochester, a dream was born — what if PASSMN, a large and very mature user group, helped kick off meetings in other areas? Throughout the past year, Paul has been working with Patrick out of Rochester to make this a reality.

image Source: http://binged.it/1eB310K

Tonight was our first meeting in Rochester. We had an awesome turn out with over twenty people attending. Everyone is already looking forward to the next meeting.

Paul and the crowd Paul presenting

To begin with, the Rochester group will be supported by PASSMN as an extension group. The meetings are planned to be quarterly and we will be working with local and regional speakers to participate. Our hope is that the group will grow and can become a stand alone chapter. However, the goal of PASS is community and training. Whether independent or as extension group, the goal is to meet these needs within the SQL Server development community where ever we can.

PASSMNLogo

For more information about PASS MN and PASS MN – Rochester meetings, check out http://minnesota.sqlpass.org/.





Traveling, Talking, and a PASS Attack Have Happened

1 12 2013

Well, this fall has been crazy. As you may have noted from a couple of my previous posts, link to speaking and pass attack, I have been busy this fall. With multiple speaking engagements and additional travel for work, I have been on the road more than I have been home. Rather than handling each event independently, I will give some synopsis here.

SQL Saturday #235 – New York City 2013

This was my first trip to New York City which is kind of ironic since I was born in Avoca, New York and lived there for five years. I spoke on Building BI Solutions with Excel 2013. During the presentation, we had an energetic conversation about pushing more of the BI work to business users. My take is that those users know how to interpret the data better than the technology staff. Ironically, they are doing it already thanks to the prolific “Export to Excel” functionality available in most BI tools. The event was a lot of fun to participate in.

SQL Saturday #238 – Minnesota 2013

This was the first SQL Saturday in Minnesota that I did not have a lot of other responsibilities beyond speaking. I felt a little guilty, so I brought my sixteen year old son, Alex, and he volunteered in my place. Turns out he did awesome and had a great time as well. I spoke in back to back sessions to open up the day. The first session, Beyond Power Pivot – Building Tabular Model Solutions, covered the development of tabular model databases using SQL Server Data Tools and the “enterprise“ features only available in Analysis Services. The next session was “Power to the User: a Look at Power BI”. This session was a lot of fun and is a whirlwind demo of the Power BI features in Excel 2013. This was a huge event with around 400 attendees and 8 tracks. Kudos to the organizing committee for a job well done.

PASS Summit 2013

Summit this year was a good event. Due to a myriad of work related crisis, I was unable to enjoy the conference as much as I had hoped. We discussed the role of the user groups in SQL Saturdays during an organizer’s meeting. I hope that we begin to see the control of these events go back to user groups rather than treated as unrelated to user groups. As the event progressed, I was able to attend a few sessions. I am still asking for the single button install of SharePoint BI, but for now I will live with the 80 page install doc. One thing I like was having the vent in a warm location. That was definitely more enjoyable than a cold, damp Seattle fall. I still look forward to the next Summit and hope to see many of you there next year.

SQL Saturday #237 – Charlotte BI Edition 2013

Immediately following Summit was this SQL Saturday. There were a lot of big time speakers that came from the Summit and they still let me talk. This session was on using Power Pivot and Power Query to test ETL processes built with SSIS. The best part was when my computer died during the demo. When I got it restarted, an error message came up on SSIS and a number of people in the room gasped. We all knew that I would not be able to fix that right away, some moved on with half of the demo working. It all turned out okay as I had screenshots in the deck to show the changes. Overall, it was a good event and gave me a chance to see some peers one more time.

CodeMastery – Atlanta

This was the first of two CodeMastery events within a week of each other. This was a lot of fun for me as I was the keynote speaker and had the opportunity to speak about the Changing World of Business Intelligence. Having been trained as a preacher, this was the closest to that type of speaking I have done in some time. We had a good, interactive audience for this event. I also presented on Power BI at this event, once again introducing a lot of people to what Microsoft is doing with BI these days.

CodeMastery – Minneapolis

Back home in Minneapolis, I participated in this CodeMastery as a speaker as well. At this event, I once again discussed the power of Power BI and Microsoft’s strategy. We had about 80 at this midweek event which was great.

Live 360 – Orlando

At Live! 360, I had the opportunity to speak at two of the 360 events – Modern Apps Live! and SQL Server Live! This event was a lot of fun to participate in. I had the opportunity to speak five times between the two events. The part that made all of this interesting was losing my harddrive that weekend. I had to rebuild demos and recover presentations all week long. Through it all I was able to get all but one presentation’s demo up and running. Funny thing though, I tweaked the demo, and it worked partly during the presentation. Nice job by 1105 to put this together. I look forward to being at the Vegas event in March.

CodeMastery – Boston

This event was also supposed to have happened by now, however, it was rescheduled to next week. If you are in the Boston area at the time, register for the event and join us for some free training. Hopefully, I will see you there.

Thanksgiving Day Survivor

Kid Pic PumpkinsAs I wrap up this post, I have to say a big “Thank You” to my family who has had to put up with a lot of travel over the past few weeks. Without their love and support this would have been a really rough time.

Turkey Image Source: http://bit.ly/1bBFIF4





PASS Attack!

11 10 2013

It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013 on Sunday. I then wrap up the week at SQL Saturday #237 – Charlotte BI Edition.

I hope to see a variety of you at these different events.

If you come to SQL Saturday 238, you will find me in two sessions to kick off the day followed by time at the Magenic or PASS booths. I am presenting on Power BI and Tabular Models. If all goes well, my son will be joining me. He is a bit taller …

Next up is this years Summit. While I am not speaking at this event, I will be participating in the Community Zone as well as many of the volunteer meetings on Tuesday. If you are a user group leader, SQL Saturday leader, or other volunteer, be sure to connect with other volunteers to share ideas and generally grow the SQL Server community.

Finally, I will be at the SQL Saturday event in Charlotte. At this event, I will be presenting on Using Power Pivot to Drive Quality into ETL Processes. I am excited about this session as we used this method on a project with great success. This is just another great way to use Power Pivot to improve your development processes. You will likely be able to find me at the PASS booth during some of the day as well.

I hope PASS Attacks are deadly. But it should be fun and memorable. I look forward to seeing you all there.





Traveling and Talking to Wrap Up 2013

16 08 2013

I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly busy travel and speaking schedule for me this year. Having spent much of the summer at home with my family which was great, I now embark on some trips, primarily out east.

For starters, I am kicking off my busy end of summer, beginning of imagefall, in New York City. I am looking forward to being there for the second time. This should be a great event. As Regional Mentor for the NorthEast this trip allows me to be in that region for an event.  I will be speaking on Building BI Solutions with Microsoft Excel.

Next, up is some quality time in Boston. I have a contract that will put me in downtown Boston for about 4 weeks. After that trip, I cm-logoskip a week and then return to speak at CodeMastery which is a Magenic event in late September.  If you are in the Boston area, I will be speaking on the difference between SQL Server Analysis Services Models – the Multidimensional and Tabular Model Smackdown.  More details of this event will be coming soon, but pencil it in for Thursday 9/26.

While not traveling far, I am speaking at SQL Saturday #238 in Minneapolis right before PASS Summit in Charlotte. This is right in my backyard, so to speak, and I look forward to another great event in the Upper Midwest. I currently do not have the sessions that were picked, but look forward to seeing you there.

October will be spent at PASS Summit. While I was accepted to speak this year, I look forward to meeting a number of people at the Community Zone and the other events at the conference. I will follow that up by going to SQL Saturday # BI Edition in Charlotte. While I have not received word about speaking, I plan to attend the event in either case. Should be a nice way to wrap up my time there.

In November, I am headed to Atlanta for another CodeMastery event. This should be a nice time to visit there and spend some time with people there.

cm-logo  X 2

Upon returning from Atlanta, I am back in Minneapolis for a CodeMastery event there. Having had a major role in running this event over the past couple of years, I am truly looking forward to speaking there. Check out http://codemastery.com for details on all of the CodeMastery events as they are announced.

Modern Apps Live!SQL Server Live!

Finally, at least at this time, I will be presenting 5 times right before Thanksgiving. This will be my first time presenting at SQL Live and second time presenting at Modern Apps Live. Join us for this awesome 360 Live event in Orlando.

I look forward to meeting new people and visiting with old friends throughout all of these events and travels. If you see me there, say Hi and ask for one of my “famous” superhero cards! See you around.





SQL Saturday#197–Omaha Recap

12 04 2013

96791a10-4559-4bac-bb98-c25ebc5e52c6

This was the second SQL Saturday hosted in Omaha.  I loved to see how the event grew from the first event until now.  John Morehouse ( T | B ) and team did another stellar job organizing this event. I know they packed the house

Having taken part in the first event, I found it spectacular that the speaker list was so diverse.  It is great to see so many SQL Server pros come out and speak at these events.

Part of the fun for me was bringing my 11-year old daughter along.  Many of you, speakers, attendees, and sponsors were kind to her and she had a good time, even though much of it was spent using my Surface to watch Netflix.  Smile  As a speaker, this was a way to spend some time on the road with her and to introduce one of my children to what I do when I travel to these events (one of my sons will be joining me in Fargo).

I do have to say that the food, both at the speaker’s dinner and for lunch were awesome!  If you are looking for an event that will feed you well, be sure to try this event next time around.

I was able to attend a few of the sessions, but I wanted to mention that the SQL Server vs Oracle: The Throwdown! was really good.  As a cross-over platform developer (check out my Oracle for MSBI Tips), it was great having a SQL Server Pro, David Klee (@kleegeek), and an Oracle Pro, Joe Grant (@dba_jedi), co-present.  Nice work guys!

Finally, I presented on Building BI Solutions with Excel 2013.  I have uploaded the slides to the event site.  Until next time.





Are You Signed Up for 24 Hours of PASS–Business Analytics?

29 01 2013

If you have not signed up for the 24 Hours of PASS-Business Analytics you should be.  This is a great chance to hear 12 speakers (they will be repeated in the following 12 hours).  Topics are varied from Big Data to Strategy to Collaboration.  Most importantly you24 Hours of PASS Business Analytics can’t beat the price to hear speakers like Denny Lee, Peter Meyers, and Stacia Misner to name a few.

I get the privilege of moderating two of the sessions: Session 8:  What Is Big Data? by Mark Whitehorn and Session 10: Visualizing Data with Power View by Sean Boon.

Finally, I heard Marc Reguera talk about how Microsoft Finance uses Power View at a different event.  If you want to see Power View put into practical use by a business user, I highly recommend you check out his session.  I think it is the final piece of the puzzle to join the technology with the business.

I hope you all take the opportunity to join us for this compelling and free event preview to the PASS Business Analytics Conference in Chicago on April 10-12, 2013.





PASSMN–Passing the Baton: A Board Transition Story

12 12 2012

Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team.  I have been on the board for the past three years during which we switched term lengths to two years with staggered elections, but more about that later.

PASSMNLogoDuring the PASS Summit this past year I had the privilege of hosting a table during the Chapter Leaders meeting on building boards and recruiting leadership for SQL Server User Groups.  First, I have to say, leadership teams/boards come in many flavors, counts, etc.  For instance, some groups are managed by one or two people who are truly passionate about the community and really enjoy leading the groups.  Other groups, such as ours, have regular elections with as few as three and as many as eight on the board.  While I may spend more time later discussing the pros and cons of various approaches, this post is about the peaceful transition within our user group.

First a bit of history, I have worked with the Minnesota SQL Server User Group for a number of years.  We joined PASS quite a while ago but a few years after we started.  After joining we did not change our organizational structure.  We have always had a board of four or more.  We currently have six roles: Chair, Corporate Relations, Programs, Membership and Treasurer, Technology, and SQL Saturday.  We added SQL Saturday last year to have someone focused entirely on getting that program rolling, Paul (@mnDBA) did great!  I have held the Corporate Relations role and this year I was the Chair.

Elections and Role Distribution

Prior to last year, our terms were one year.  However, we rotated the entire board at least once which is very difficult. So, starting last year, we rotate 1/2 of the board each year with terms running twoelection button years.  What is really cool about our election process is that we are able to recruit new board members each year allowing PASSMN to take on some new ideas without issue.   We have also done a good job of mixing up members between consulting and nonconsulting members.  We also try to limit a company’s participation to one board member.  This process has been successful for years as this blend has motivated time changes, content direction and even sponsorships through the years.

Another unique part of our board election is that members are voted to the board, not to a role.  This is strategic as it allows the members to rotate roles as well as work with each other to find a good fit for them within the board.  It also means that the nominees understand that they will work with their fellow members to distribute responsibility.

Transition Lunch

That leads us to today.  We had our transition lunch 12/12/12 at 12:12. (Yes, that was the actual appointment time, and we survived.)  Once again we had a good time as volunteers reflecting on what happened in the past year, allowing the new board to select roles, and handing off insights as we have them.  And thus, it is the beginning of the end for me as a board member.

It’s Been Great!

Personally, it has been and will continue to be great working with such a good group of people.  Thanks to Andy (@SQLQuill)  and Tim (@tjplas) for the time these past couple of years and we welcome Shirley (@SQLLatina), Will (@williamweber), and Mike (@SQLMD) to the board along with returning members Paul, Josh (@SQLJosh) and Bill (@billpreachuk).  I plan to continue working with the board and helping with some of their new initiatives this next year.  Let’s keep the tradition of quality and fun going.








Follow

Get every new post delivered to your Inbox.

Join 787 other followers

%d bloggers like this: