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.





Countdown to PASS Summit 2012 – 9 to Go – My First Summit

28 10 2012

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to put together a countdown blog series so here goes. My first blog is about my first PASS Summit. I attended my first PASS Summit in 2007 in Denver, Colorado. At the time, I was working for XATA Corporation as their data architect. I had attended a different conference a couple years before, but was introduced to PASS through my local user group (PASSMN). The Summit had a better list of topics and presenters and I was very interested.

I would travel to this conference alone and I really only knew a couple of the other attendees. As far as I remember, there was not as much there for first timers. I felt further out of place as a first time speaker (later on that) and did not know all of the regulars. Ironically, back then, I was not very interested in networking, I came to learn. Little did I know how that would change throughout the years that have followed. I wanted to attend a lot of sessions and learn as much as possible. (I heard Itzik for the first time, and learned to love T-SQL even more. J)

So, what how was your first Summit? What was your focus? Did you network, learn, or were you able to do both?

Only nine days to go. I hope to see you there! If it is your first time, take advantage of the first timer programs. It is a great event made even better as a result.





T-SQL Window Functions on LessThanDot and at SQL Saturday 149

26 09 2012

LessThanDot Sit LogoI recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions.  The enhancements to SQL Server 2012 in this area are phenomenal.  They solve a myriad of issues including calculating running totals with SQL.  Check it out if you want to learn more and get some simple examples related to the functions and structure related to the window functions.  Here is the series outline and links to each section.

T-SQL Window Functions:

I do a presentation related to T-SQL functions for SQL Saturdays and am presenting it at the PASS Summit this year.  Maybe I will see you there.

I recently presented this at SQL Saturday #149 in Minnesota.  Here is the presentation and the demo code. Thanks for attending.

 

Finally, if you use Oracle, you will find this series helpful as well.  Most of the syntax is supported in Oracle as well.  Look for an Oracle tip with the Oracle samples for your use soon.





SQL Saturday #149 and CodeMastery–Minnesota Events

18 09 2012

sqlsat149_webWe are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference sessions on September 28.  In case you haven’t heard, we are having the main event on a Saturday.  Yes, the precons are on Friday this year.  Check out the details here.  I am really excited about this event as we have a great group of local, regional, and national speakers at this event.  There are nine rooms being used for this event, so go out to the site and build your schedule.

cm-logoThe following Tuesday, Magenic is hosting CodeMastery with a BI track at the Microsoft Technology Center in Edina, MN.  This event includes a sessions on managing the BI stack in SharePoint and xVelocity.  The other track is Windows 8 development with sessions on WinRT and Game Development.

I’m a Speaker at Both Events

Besides plugging these two awesome events on their own, I am also a speaker for both events.  Here is what I will be speaking on at each event:

SQL Saturday #149: A Window into Your Data: Using SQL Window Functions

In this session, I will walk through the window functions enabled by the OVER clause in SQL Server.  Come join me as we celebrate the SQL Server 2012 release of analytic functions and expansion of aggregate functionality to support tasks such as running totals and previous row values.  Thankfully, this is a demo heavy session as it is one of the last sessions of the day.

CodeMastery: Data Mining with the Tools You Already Have

The next week, I will be presenting on data mining tools which Microsoft has made available to us in SSAS and Excel.  The goal of this session is to help developers understand how to implement data mining algorithms into their business intelligence solutions.

I look forward to seeing you at both events.  They are priced right, FREE!





Presenting at PASS Summit 2012

22 06 2012

I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”.  I get the privilege to present on some awesome new technologies released in SQL Server 2012.

Here are my sessions for this year’s Summit:

A Window into Your Data:  Using SQL Window Functions

Application & Database Development Track

Window functions are an underused feature in T-SQL that have been greatly expanded in SQL Server 2012. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for this demo-filled session on how and when to use SQL window functions.

Building a Tabular Model Database

BI Platform, Architecture, Development & Administration Track

Come learn about the tabular model in SQL Server 2012 Analysis Services and watch a model built from “Create Project” to deployment. Microsoft introduced the tabular model in SSAS 2012. Its supporting technology is based on the xVelocity query processor, which was introduced in PowerPivot. In this session, we will create a tabular model database in SSAS using SQL Server Data Tools. We will add data from various types of data sources and build relationships between them, then extend the solution by adding calculations, measures, and hierarchies. Finally, we will cover some of the management techniques required to support a tabular model in an enterprise solution.

Check out the other sessions that have been announced and get signed up soon to take advantage of the current price $1,395 which is good until June 30, 2012, at http://www.sqlpass.org/summit/2012/.  I will look forward to seeing you there and at other community events this year.








Follow

Get every new post delivered to your Inbox.

Join 733 other followers

%d bloggers like this: