Upcoming 24 Hours of PASS

We are four weeks away from the next 24 Hours of PASS event, and the registrations continue to mount. I have participated in all four 24 HoP to date and each one holds a special memory for me. But when all is said and done this coming event has the potential to be my favorite of the bunch.

Past 24 HoP events have been focused on giving viewers a preview of PASS Summit content. The event last Spring was focused on SQL 2008 R2. This event is not a preview. Instead it is simply full of SQL-goodness and I can't wait for it to get started. I'll register, and likely watch, all 24 sessions so it would be hard for me to pick a few favorites that I want to see next month. But here goes anyway:

SQL SERVER PERFORMANCE TOOLS (Cindy Gross)

Tools for troubleshooting performance issues. Best practices around troubleshooting methodology, SQLDiag/PSSDiag, SQL Nexus, Profiler/Trace, and PerfMon. Narrow down a performance problem & focus on where to spend your time.

T-SQL CODE SINS: THE WORST THINGS WE DO TO CODE AND WHY (Jen McCown)

"Code sins" are those things we do to our code that make stored procedures wish they’d never been created. Learn common code sins that make it difficult to read, support, run and extend.

T-SQL AWESOMENESS: 3 WAYS TO WRITE COOL SQL (Audrey Hammonds)

There are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. Come learn new-school ways to expand your T-SQL repertoire.

INDEX INTERNALS FOR MERE MORTALS (Michelle Ufford)

This in-depth session covers the internals of indexes including index filtering and partitioning. Walk away with a better understanding of indexes, which is helpful when designing and tuning databases.

If you haven't taken a moment to visit the 24 HoP website and register, what are you waiting for?

SQLSaturday Round-Up (Feb. 10-16)

(This is Round 12 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

Last week, PASS SQLSaturday trekked its way up the Rockies and braved the altitude for SQLSaturday #66 in Colorado Springs.

From the looks of things, it wasn't just the thin air making people giddy - the event was held at Mr. Biggs Fun Center, complete with arcades, putt-putt, laser tag, and even a go-kart track. With so many fun distractions, it's amazing any learning got done, but got done it sure did!

(We're pretty sure Mr. Biggs Fun Center is not in this picture, but don't quote us on that - we've been wrong before.)

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK IN SQLSATURDAY...

+ Doug Lane attended SQLSaturday #66, Colorado Springs

+ Kelly Martinez attended SQLSaturday #66, Colorado Springs

+ Rebecca Mitchell helped organize SQLSaturday #66, Colorado Springs

+ Jeremiah Peschka presented at SQLSaturday #60, Cleveland (and forgot to post his resources in a timely manner... tsk tsk)

+ Chris Shaw helped organize SQLSaturday #66, Colorado Springs

+ Nancy Hidy Wilson helped plan SQLSaturday #57 (and provides recaps of all the recaps for your recap convenience)

COMING UP IN SQLSATURDAY...

There's talk of PASS SQLSaturday exploring borders beyond the North American continent. However, for now, it's still all happening between the Pacific and the Atlantic. You know, the smaller chunk between the two oceans, not the bigger chunk. Is that confusing? Probably. But we digress.

This coming Saturday, those of you in Phoenix get your chance to experience SQLSaturday #47. On Feb. 26, SQLSaturday #65 stops in beautiful British Columbia, Canada, for the Vancouver get-together - if you're heading that way, make sure to say hi to all the PASS HQ team members stopping by! And on Mar. 5, the City of Brotherly Love opens its arms wide for SQLSaturday #69, Philadelphia.

IN OTHER NEWS...

Event organizers at SQLSaturday #60, Cleveland, drew a substantial number of responses to their speaker evaluation forms by connecting completed entries with prize draws - presenters Aaron Bertrand, Grant Fritchey, and Tom LaRock all discuss their ratings from the event.

Finally, continuing from last week's prompt for more people to consider speaking at events like SQLSaturday, presenter Mike Walsh provides some tips on how to get started. And wouldn't you know it? He also presented in Cleveland! Not to be outdone, he, too, posted his feedback for all to see. Looks like Mike's willing to listen just as much as he's willing to teach - another key feature of a good speaker.

Want to attend or speak at a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

PASS Program Committee Management Transparency

[cross-posted from Allen Kinsel's blog at allenkinsel.com]

I occasionally get into trouble for thinking that no one cares what I’m (we’re) doing for PASS.  Frankly much of what I work on is BORING to a casual observer.  Im still not convinced anyone really cares about the minutiae that we have to deal with week in and week out on the Program Committee but, I don’t know if that’s just myself becoming desensitized to the amount & importance of what I (we) do.

My friend Andy Warren (Blog|Twitter) mentioned something the other day about their being minutes posted on the PASS site (somewhere) from the meetings that are held in relation to the SQL Rally.  In the Program Committee we’ve produced minutes for the meetings that we have for quite a long time (2+ years) and they were simply emailed about and stored on PASS’s intranet site, they’re mainly used for keeping track of deliverables.

Change

Starting with our last meeting (first substantial meeting of 2011) Ive asked that we publish a copy of the minutes to the Program Committee webpage on the PASS site.  http://www.sqlpass.org/Community/SpeakerResource.aspx Look near the bottom left of the page for the first meeting minutes.  At some point, we may have to look at separating the Program committee info from the actual speaker info on that page but, for now this was easy and took basically no extra work from HQ or anyone on the team.

Useful?

So, the question is (and I rarely get answers to questions in a blog post): Other than to be able to say, yes we publish those minutes, does anyone even care?  Will anyone read them with any regularity?  Ive personally never looked at the Rally minutes, so I’m thinking its not going to be that valuable..  I agree that in general transparency is a good thing but, to a point like this I wonder if anyone out there cares.

Information overload

We will meet bi-weekly for the next 6 or so weeks but from that point on we usually meet weekly, and often a few times a week when crunch time hits.  As you can imagine, that creates a huge amount of minutes.  I hope that we dont wind up burying good information people might want to see simply because we meet so often.

PASS needs you

[cross-posted from Allen Kinsel's blog at allenkinsel.com]

Help wanted Needed!!

This year my portfolio within the PASS board is “Summit program and speaker management”  Ive been involved with this portfolio for at least the last 4 years.  This year, I’m going to be transitioning into yet a different roll within the committee.  Ill still be heavily involved but,  I’m turning the majority of the day to day decision making over to Lori Edwards (Blog|Twitter)  She was hugely involved last year, and I have no doubt she will work her magic again this year!

Program Committee Changes

This year, there are going to be some changes to the processes in the program committee, Ill detail some of those in a later set of blog posts.  For now, Ive decided to split up the groups of volunteers in the program committee to hopefully enable some of the future process changes.

Help Wanted

For this year we’re going to need help in many areas

Abstract Review Teams (led by Lori Edwards)

  • DBA/Cloud/BI/AD/PD

Speaker Review Team (led by Tim Ford)

  • This group will review speakers independently of their abstracts

Speaker Enhancement team (Wes Brown & Grant Fritchey)

  • This will probably stay a small group and work on updating sample abstracts, selection info, generating info for new speakers etc.

PPT/Abstract Editing review/approval (Led by Tim Martin)

  • This group will be working on sessions after they are accepted (lots of new ideas here)

Special Projects (Led by AJ Mendo & Lance Harra)

  • This group will be working on finishing the Speaker Evaluation tool, coordinating changes to the Summit online tool as well as a few other projects that are envisioned.

Cutting edge

Its been said that what we do in the Program committee is on the bleeding edge of what PASS does in organizing groups of volunteers at the national level.  That is to say, we need lots of help but, sometimes things dont always work out quite how we (I) had expected.  I say this only to set expectations that its not always a smooth ride but, rarely is it not interesting.

We developed an online survey to help us capture all of the relevant info about everyone who wants to volunteer.  Don’t worry, its not a job app and it shouldn’t be resume quality, we’re primarily looking for general information

http://www.zoomerang.com/Survey/WEB22BSJTXJZEA/

Please consider this a personal invitation from me to join us in making the content at the PASS Summit 2011 the best ever!

PASS Summit 2013 - A Bunch of Blog Posts Recently

[cross-posted from Rick Heiges' blog at sqlblog.com]

Recently, there have been a number of blog posts about having the 2013 PASS Summit in Seattle or elsewhere.  I had a post in November about the process and some of the major factors that were on my mind.  You can read it here

There is value in moving the Summit to another venue.  There is value in having the Summit in the same location/venue year after year as well.  Many of the posts that I read recently make excellent arguments for each.  As time goes on and you hear another good argument for one or the other, I keep waiting for the definitive argument.  You know that someone will make some obvious point that everyone overlooked, and the decision will be a no-brainer.  Well, I'm not convinced that we will hear that definitive argument ever.

I believe that my post referenced earlier in this blog entry gives you a hint of which way I am leaning, but I emphasize that many factors must be considered in order to make an informed decision not only about the location of the Summit in 2013 but also how that may affect the budgeting aspects of our other support services and offerings.

 

Farewell to Director Christoph Stotz

Dear PASS Members,

It is with great sadness that the PASS Board must bid farewell to Christoph Stotz. Christoph has been with the organization since its infancy, and throughout has been a passionate advocate for its cause. 

He helped launch PASS Germany in the early 2000s, a Chapter which is currently over 2000 members strong and a major hub for all things SQL Server in Europe. Christoph was also a foundational driving force behind the PASS European Conference, his tireless efforts instrumental in the event's growth and success. The Board of Directors recognized his skills and verve, and in 2005 he was appointed to the Board as an advisor on European matters. In time, his role encompassed a wider scope, and he became a champion for the global cause.

Christoph is stepping down to concentrate on a number of personal goals. He leaves a legacy that will be incredibly difficult to match by any successor to the role. In all his dealings with PASS, whether as Chapter leader, event organizer, or regional Director, Christoph was known for providing thoughtful analysis and sage advice at just the right time. His combination of wisdom and experience will not be easy to replace.

But as they say, all good things must come to an end. We wish Christoph all the best of luck in his future endeavors and have no doubt that success will continue to follow him wherever he goes. He will be missed!

PASS: 2013 Summit Location

[cross-posted from Bill Graziano's blog at sqlteam.com]

HQ recently posted a brief update on our search for a location for 2013.  It includes links to posts by four Board members and two community members. I’d like to add my thoughts to the mix and ask you a question.  But I can’t give you a real understanding without telling you some history first.

So far we’ve had the Summit in Chicago, San Francisco, Orlando, Dallas, Denver and Seattle.  Each has a little different feel and distinct memories.  I enjoyed getting drinks by the pool in Orlando after the sessions ended.  I didn’t like that our location in Dallas was so far away from all the nightlife.  Denver was in downtown but we had real challenges with hotels.  I enjoyed the different locations.  I always enjoyed the announcement during the third keynote with the location of the next Summit.

There are two big events that impacted my thinking on the Summit location.  The first was our transition to the new management company in early 2007.  The event that September in Denver was put on with a six month planning cycle by a brand new headquarters staff.  It wasn’t perfect but came off much better than I had dared to hope.  It also moved us out of the cookie cutter conferences that we used to do into a model where we have a lot more control.  I think you’ll all agree that the production values of our last few Summits have been fantastic. 

That Summit also led to our changing relationship with Microsoft.  Microsoft holds two seats on the PASS Board.  All the PASS Board members face the same challenge: we all have full-time jobs and PASS comes in second place professionally (or sometimes further back).  Starting in 2008 we were assigned a liaison from Microsoft that had a much larger block of time to coordinate with us.  That changed everything between PASS and Microsoft.  Suddenly we were talking to product marketing, Microsoft PR, their event team, the Tech*Ed team, the education division, their user group team and their field sales team – locally and internationally.  We strengthened our relationship with CSS, SQLCAT and the engineering teams.  We had exposure at the executive level that we’d never had before.  And their level of participation at the Summit changed from under 100 people to 400-500 people.  I think those 400+ Microsoft employees have value at a conference on Microsoft SQL Server.  For the first time, Seattle had a real competitive advantage over other cities.

I’m one that looked very hard at staying in Seattle for a long, long time.  I think those Microsoft engineers have value to our attendees.  I think the increased support that Microsoft can provide when we’re in Seattle has value to our attendees.  But that doesn’t tell the whole story.  There’s a significant (and vocal!) percentage of our membership that wants the Summit outside Seattle.  Post-2007 PASS doesn’t know what it’s like to have a Summit outside of Seattle.  I think until we have a Summit in another city we won’t really know the trade-offs.

I think a model where we move every third or every other year is interesting.  But until we have another Summit outside Seattle and we can evaluate the logistics and how important it is to have depth and variety in our Microsoft participation we won’t really know.

Another benefit that comes with a move is variety or diversity.  I learn more when I’m exposed to new things and new people.  I believe that moving the Summit will give a different set of people an opportunity to attend.

Grant Fritchey writes “It seems that the board is leaning, extremely heavily, towards making it a permanent fixture in Seattle.”  I don’t believe that’s true.  I know there was discussion of that earlier but I don’t believe it’s true now.

And that brings me to my question.  Do we announce the city now or do we wait until the 2012 Summit?  I’m happy to announce Seattle vs. not-Seattle as soon as we sign the contract.  But I’d like to leave the actual city announcement until the 2011 Summit.  I like the drama and mystery of it.  I also like that it doesn’t give you a reason to skip a Summit and wait for the next one if it’s closer or back in Seattle.  The other side of the coin is that your planning is easier if you know where it is.  What do you think?

 

What’s important in a Summit Location

[cross-posted from Allen Kinsel's blog at allenkinsel.com]

I thought after my last post on Summit location that I wouldn’t need to write anymore about it but, I got a couple of responses(questions) wondering what I thought was important in a location for the summit. What I’m guessing these people really want to know is where Ill vote for, not, what I already wrote about which is what I’m essentially voting against.

Well, I’m not going to go so far as to say exactly where I’d like to see the Summit.  What I will do is list what I think are the top 3 most important things when looking at where to locate the summit.

  1. Accessibility – It needs to be as easy as possible to get to, as well as get around once you get there.  Both the city as well as the Convention Center should be easily accessibilty
  2. Cost – The convention center needs to be reasonably priced, the hotels, food, etc should all be (somewhat) affordable
  3. Local Support – I would prefer a location with a very strong local support structure, whether Microsoft or the local SQL Community.

There are many additional variables that no doubt will be considered but, these are the things that make the top of my list.

SQLSaturday Round-Up (Feb. 3-9)

(This is Round 11 of PASS's weekly round-up of SQLSaturday recaps. PASS community bloggers love their SQLSaturdays, and they love to tell everyone about their experiences, so who are we not to share that love?)

PASS SQLSaturday continues to go from strength to strength. Several new events are either in the works or have already been officially announced.

Last weekend it was Cleveland's turn to host the party. According to Ian Hunter, Cleveland rocks - after this past Saturday, we're sure* he wrote the song in anticipation of SQLSaturday #60!

*Okay, maybe just pretty sure.

For those of you on Twitter, follow @sqlpass and make sure to check out the #sqlsat and #sqlsaturday hashtags to stay up to date. Besides attendance at free learning events, there are many speaking and sponsorship opportunities available.

LAST WEEK IN SQLSATURDAY...

Nancy Hidy helped organize SQLSaturday #57, Houston (and reflects on what she and her team could've done better)

Ryan Adams presented at SQLSaturday #57, Houston

Aaron Bertrand presented at SQLSaturday #60, Cleveland (and also made sure to put his presentation slide decks out there post haste)

+ Wes Brown presented at SQLSaturday #57, Houston

+ Jack Corbett presented at SQLSaturday #62, Tampa (quite a few weeks ago now, eh, Jack?)

+ Grant Fritchey (miraculously) presented at SQLSaturday #60, Cleveland (this is truly a crazy story - we're impressed!)

COMING UP IN SQLSATURDAY...

Like we said, there are still lots of SQLSaturdays to look forward to in February. On Feb. 12 it's being held in Colorado Springs. On Feb. 19 you can attend the event in Phoenix. On Feb. 26 it stops near PASS management HQ in Vancouver, Canada - if you've been to PASS Summit, there might be quite a few familiar faces around!

IN OTHER NEWS...

Have you thought about presenting but just weren't sure what's in it for you? If you have the urge to share your knowledge, Mike Walsh tells you why you should present (next week he'll tell you how). Don't forget, SQLSaturday is the perfect venue for you to launch a speaking career and hone your skills. And if you're already presenting at SQLSaturdays, franchise founder Steve Jones wants you to know that it's always a good idea to upload your decks early, as his own experience proves!

For those of you who are busy planning a SQLSaturday of your own, Malathi Mahadevan has some hot tips gleaned from lessons learned hosting the recent event in Louisville. She provides lots of great pointers, so make sure you check it out.

Finally, PASS Director Andy Warren recently blogged about his PASS-related work goals for 2011. He has quite a few targets dedicated to SQLSaturday. An interesting read!

Want to attend or speak at a SQLSaturday? Check out the SQLSaturday website or "Upcoming In-Person Events" on the PASS Home page for upcoming dates near you.

Want to put on your own SQLSaturday? Click here to get started.

PASS SQLRally 2012 - Selection Process for Host City Now Underway!

Hello Chapter Leaders!

As you may know, we will be having our first PASS SQLRally in Orlando on May 11-13. This event is PASS' new regional event that fills the gap between the PASS SQLSaturday 1-day training events and the week-long PASS Summit.

We have recently begun the planning process for the 2012 event and are reaching out to the Chapters in the US to see who would be interested in hosting the event in May 2012.

If you are interested, please inform Anika at PASSHQ of your Expression of Interest before February 14th. Please include the following information in your submission: 

  • Geographical Location (Note: Preferred locations will be in the Central and Mountain time zones, along with locations in the North Eastern US)
  • Chapter Size as determined by number of members
  • Proven history of managing events (ie. SQLSaturdays)

The SQLRally Selection Committee will review all submissions. The Committee is made up of volunteers and PASS HQ event and logistics specialists. All submitters will be advised by February 17th if they meet the primary requirements. 

For Chapters that meet the requirements for the 2012 Host City, the next steps will be:

  • Chapter to submit the completed application (attached) by Feb. 20.
  • PASS HQ to summarize all applications and provide to the SQLRally Selection Committee.
  • Selection Committee to choose the top 5 likely candidates.
  • Anika to contact venues in the chosen cities for RFPs.
  • Review and analysis of RFPs; Selection Committee to select the top 3 potential candidate cities.
  • Community vote to select the 2012 location.
  • Winner will be announced at the Orlando SQLRally on May 13.

If you have any questions or to submit your Expression of Interest, please email Anika at PASSHQ at Anika.Poliseno@sqlpass.org. Anika will be available to assist at any step along the way so please don’t hesitate to contact her at 604-899-6009 x118.

Thank you for your interest and we look forward to the selection process!