Education

SQLSaturday 41 Status Update

I know many people have been worried about me because of the recent personal issues that I’ve been dealing with, but things have finally started to stabilize.  I know I’ve promised that before, so no promises to return to blogging or getting more involved in the community, but I’m starting to climb out of the pit (and hey, I have light bulbs)!

Anyway, despite me, SQLSaturday 41 on April 24, 2010 is plugging along, thanks to a group of dedicated volunteers that have really pushed me to keep this on track.  Thankfully, I’ve been able to give them the information they need, and they’re quite capable of making this happen.  We’re a little more than a month out, and we’re almost full with our speaker’s list, and are sitting at nearly 60% registration.  Seats ARE filling up, so if you haven’t registered, now’s the time to do so.

Here’s a short list of topics so far (in no particular order):

A Lap Around SQL Server 2008 Master Data Services
Whitney Weaver
Beginner

Advanced Parameters in SQL Server Reporting Servic
Mike Davis
Intermediate

Can you control your reports?
Ryan Duclos
Intermediate

Common Table Expressions
Ryan Duclos
Beginner

Data Warehouse Assessments – What,Why, and How
Noah Subrin
Beginner

Database Design Fundamentals
Louis Davidson
Intermediate

Database Design Patterns
Louis Davidson
Intermediate

De-mystifying Execution Plan Analysis
Dave Turpin
Intermediate

Dynamically Configuring Packages
Mike Davis
Intermediate

Full Text Searching – A Guide for DBAs & Devs
Robert Cain
Beginner

Introduction to Data Warehousing / BI
Robert Cain
Beginner

Introduction to Performance Tuning
Mike Femenella
Beginner

Introduction to Performance Tuning
Mike Femenella
Beginner

Introduction to Transactional Replication
Troy Gallant
Beginner

Loading Data In Real Time
Mike Femenella
Intermediate

Off and Running with PowerPivot for Excel 2010
Robert Cain
Beginner

PowerShell for the Data Professional
Aaron Nelson
Intermediate

RESTful Data
Chris Eargle
Beginner

Slowly Changing Dimensions–Done Well.
Julie Smith
Beginner

Solving Real World Problems With DMVs
Whitney Weaver
Intermediate

SQL Server 2008 R2 Overview – Session 1
David Rodriguez
Beginner

SQL Server 2008 R2- BI Drill Down Session 2
David Rodriguez
Beginner

SQL Server 2008 R2- DBA Drill Down Session 3
David Rodriguez
Beginner

SS2008 Data Mining with Excel 2010 and PowerPivot
Mark Tabladillo
Intermediate

Survey of Windows Azure Platform Storage Options
Glen Gordon
Intermediate

The Art and Science of Data Modeling
Audrey Hammonds
Beginner

Tuna Helper for SQL Server DBA’s
Janis Griffin
Intermediate

Using Event Handlers in SSIS for Auditing and Noti
Mike Davis
Intermediate

Virtualize This!
Aaron Nelson
Beginner

Wait-Time Based SQL Server Performance Management
Janis Griffin
Intermediate

When GEO meets SQL: Hotwiring Data to Locations
Michael Clifford
Beginner

SQL Saturday 41 is official!

It’s live; we’re limited to 250 seats, so register now for a great day of training in Atlanta on April 24.  We’re also looking for speakers and sponsors, so please feel free to spread the word.  I’ll continue working on the stub in order to finish the site out, so check back often.

This will be a new challenge for me, since we’re planning on running this by committee (which has both benefits and challenges); I’ll keep you posted as to how that’s working out.

Stay tuned!

Shhhh! SQLSaturday Atlanta 2010 request has been submitted.

We’re looking at April 24 at the Microsoft facility in Alpharetta, GA.  I just submitted the request on the website tonight, so it probably won’t be official for a few days, but I a) needed something to blog about tonight, and b) wanted to get the word out to start some buzz.

Like last year, there will be a waiting list; we’re limited on space, and it will probably book quickly, so keep an eye out on this website for the official announcement.  We’re hoping to have several tracks again, as well as a mixture of experienced speakers and newcomers.

Watch and wait 🙂

PASS Summit Day 2: the brief wrapup #sqlpass

I’m writing this post quickly, because I have a 6:30 SQLSaturday alumni meeting at a local donut stop.  Please don’t let the brevity of the post throw you off; lots of goals accomplished yesterday.  Unfortunately, going to sessions was not one of them 🙂

  • I spent a lot of time networking, and discussing Agile techniques for database developers with a lot of different people, as well as looking at some of the latest and greatest tools for SQL Server.
  • Speaking of vendors, I shipped home two huge boxes of free stuff, most of it from Quest, Idera, and Red Gate.  My shipping costs were $80, so you can imagine the stuff I had.
  • Finally, and I’ll probably return to this in a later post, I met with the Board of Directors of PASS in an intimate session on governance.  It was fascinating, and I’m surprised that more chapter leaders were not there, because we discussed A LOT of issues related to the local chapters, and how PASS runs itself.  I don’t think that any particular goals were met, but I do believe that the following is true:
    • Change is coming for the local chapters; the PASS board is going to try to do more to connect with the local chapter, but will want more from the local chapter as well.  Think of it as having more concrete discussions about how the local community uses SQL Server, and what niche can PASS fill.
    • Steve Jones asked a series of great questions, including: “What have you done for me?”  He wanted the Board to be able to be more transparent, and expose their accomplishments beyond their individual audiences (for example, Greg Low’s work with the chapters should be available to those who are not chapter leaders).
    • More to come.
  • The day finally wrapped with an afterparty at a local arcade, hosted by Microsoft.  Lots of fun, but I was exhausted.

Gotta run; day 3 will be a blast.

PASS Summit Day 1.5

So this is the first official day of Summit, but since I got here in the middle of the day yesterday, I’m cramming a brief post in combining yesterday and today.  I could sum up the experience in one word:

Awesome.

I have met SO many people face to face that I normally follow on twitter and other social tools, and it’s been amazing to sit and chat with other SQL geeks.  I ended up buying the DVD set today because I had too many sessions to attend, and too many people to chat with.  It’s truly inspiring to hang out with a bunch of intelligent people who are really passionate about what they do.

Highlights:

  • Pinal Dave stole my pen.  Well, he actually borrowed it to fill out his sqlbingo card, and then forgot it.  It’s OK, because I know if I make him feel guilty, he’ll fly back to the States from India to bring it to me.  And I could make him speak at our newsgroup.
  • SQLBingo has not taken off as well as I had hoped, but it’s going OK.  They’re drawing the first two winners tomorrow morning, and I hope to pitch it harder tomorrow.  I forget that just because I’m a social person, not everyone else is.
  • I learned some new stuff at Michelle Ufford’s presentation on VLDB’s.  Need to check things when I get back in the office to see if they’ll help some performance issues.
  • Met Patrick Leblanc, Tim Mitchell, Lori Edwards, Jeff Rush, etc., etc.,etc…
  • Met Remus Rusanu today after Brent Ozar’s session, and was told by him that he liked some of my responses on StackOverflow.  That really made my day, because he gives some great advice on that website.
  • Kevin Kline gave me AND the user group autographed copies of his latest book.
  • MidnightDBA gave me free stuff.

LetDowns:

  • I didn’t win any blogging awards.  More incentive to keep working at it.
  • I realized I should have submitted something to present.  Paul Waters and I made a pact to come up with 3 submission ideas for next year.

OK, I’m officially out of steam.  More to do tomorrow.

Packing my bag for PASS Summit 2009

Flying out on Monday, and I’m so excited.  Here’s the stuff I’m throwing in my bag (as if any of you care).

  1. My Archos 5 IMT – 6+ hours and an extended battery.  Gotta load it up with all of the TV shows I’ve missed over the last few months on my SageTV rig.  Since I can’t find my boosteroo audio amp, I’ll need to go see if I can get a good set of headphones for the plane.
  2. Pad and pens.
  3. My laptop computer, complete with the Nokia softphone software.  I’ll still have to touch base with the office occasionally, and this way I can have portable VOIP.
  4. I’m writing a review for The Art of Unit Testing for the AtlantaMDF Reviews site.  Need to pack the book for the plane.
  5. Airborne Vitamin C.  I know it’s not likely to prevent germs, but boosting my vitamin C intake before I travel is almost a superstitious rite for me.
  6. My #sqlbingo cards and tag.
  7. My PASS Summit itinerary;  I was going to load it into Outlook, but I remember that the last time I did that, everything got screwed up because of the time change. 
  8. My phone, and an extra battery (for all of the twittering I plan on doing).
  9. Business cards.

And I still gotta pack clothing and essentials.  I’m hoping I can do it all with the carryon+laptop limitation, particularly since I have a layover on my way back.

SQLBingo: a few more things to consider…

SQLBingo is still on at Pass Summit 2009; we’re less than a week away, and this should be a lot of fun.  To sum up, a bunch of us SQL Tweeters are going to be wandering around Summit; if you want to play Bingo, you have to match the real person with their avatar on the card, meet the person, and get their codeword.  Should be a lot of fun, but I have a few more things to add.

If you haven’t read the following posts, you may want to start with them first:

SQL PASS Twitter Bingo: The rules so far…

A basic summary of the rules for squares (with some general advice for players).  I’d like to add some things to the “how to play” list, but we’ll get to that in a minute.

#SQLBingo: Meet nice people and learn their safewords.

Brent (as usual) writes a very succinct post on how to play if you’re not a square.  What’s important about Brent’s list is that he lays out some guidelines for things to do BEFORE you go to Summit.

Wanna play?  It takes some prep work…

It should be noted that this is a low-budget game at best; I think one of squares called it “guerrilla networking”, which I think is an awesome term for it.  What it means is that we’re trying to keep the rules and the play very simple, but unfortunately, that also means that the players have to provide some of their own resources for playing.

If you are playing, follow the steps at Brent’s blog:

  1. Print your cards ahead of time from http://sqlserverpedia.com/bingo. (Be sure to refresh in between)
  2. Find the tweeps.
  3. Turn in a card per day when you’ve filled out a row on Tuesday, 2 rows on Wednesday, and blackout on Thursday.

You may also want to set up a Twitter account between now and then.  If you’d like, you can check out sqlbingo’s profile; this is a dummy account set up by Aaron Nelson and myself to follow all of the squares.  The whole point of this account is to simply give you a quick list of all of the Twitter accounts that are on the cards.  You may also want to set up a search for the term #sqlbingo; remember, the squares will be broadcasting their location periodically throughout the day, and using this term will help find them.

Already a square? It takes some prep work…

Same rules for players applies to the squares; however, we’ve decided that squares are not eligible for prizes.  Sorry.  However, if you’d like to make it easy for your adoring fans to find you, you may want to print out a simple badge with your avatar and username on it.  Just a 2×4 scrap of paper, and tape it to your standard Summit badge.  If you forget, c’est la vie!  It’ll just be tougher for people to find you.

Looking forward to meeting all of you face to face!

Stu

SQL PASS Twitter Bingo: The rules so far…

Sorry for the late posting on this, but it’s been a heckuva day 🙂  Anyway, we (Brent Ozar, Blythe Morrow, several others and I) have had several logistical discussion about how Twitter Bingo will be played at PASS Summit 2009, and I thought I would post what we’ve discussed so far.

The goals!

The goal of the game is to increase networking opportunities between the SQL Twitter community and face-to-face PASS Attendees.  Our hope is to a) strengthen existing relationships between SQL tweople, and b) encourage new people to start using Twitter and contribute to the social interactions beyond Summit. 

What is NOT the goal!

To win fabulous prizes.  Quest and SQLServerPedia are putting together some encouragement for new people to play, but the focus isn’t on “winning”; it’s on community interaction.

“Squares” and players…

Squares will be the volunteers who agreed to have their Twitter avatars placed on the cards.   Squares may certainly play the game by printing out cards and pursuing other squares, but at this time, squares are discouraged from entering the prize drawing (Sorry about that; the prizes are fabulous, but not that fabulous).  Again, we want to encourage new people to join the community; if you’re a square, you’re already there (ooh, that was a horrible rhyme.)

How will players mark off squares on their cards?

Each square has a code word; when asked for that code word, they should provide it to the player, who can write it on their card.  I realized that code words will probably be shared among players, but again, the goal is to encourage community interaction even at the risk of minor “cheating”.   We may come up with a more secure scheme next time, but this time, it just seems easier for Quest/SQLServerPedia employees to validate code words.

Arlene Gray (@whimsql) suggested that she write her code word on the back of her business card; I think that’s a great idea.

How will players know where to find me?

Twitter is an option 🙂  If you can, tweet your location throughout the day using the hashtag #sqlbingo.

Brent also suggested that if you’re a speaker, you may want to ask squares in the room to stand up before you begin your session, so players can identify them.  We’re also planning on asking squares to print out a small badge to tape to their regular conference badge showing their avatar and username.

Where do players get their cards?

We’re going to ask players to print out their own cards and bring them with them; we’ll also have some cards available at the Quest/SQLServerPedia booth.  Blythe Morrow also suggested that we use the PASS help desk booth as well.

How do players play?

We’re planning on adding this to the card:

Here’s how the contest works: print out 3 Bingo cards.  Try to meet as many people as possible that are on your card each day.  Each person has their own code word, and you have to write down their code word in their space on the Bingo card.  When you get a straight line (5 people in any direction) on Tuesday, you can drop off your card in the SQLServerPedia booth in the exhibit hall.  Each day, we’ll draw 2 winners and email them with their prize package – things like signed books, gift cards, and more.  On Wednesday, it gets tougher – you have to have two straight lines filled out.  On Thursday, you have to have a blackout – all spaces covered!  Only one entry per person per day.

Who’s a square?

Below is the list of squares:

Square SquareUserName
Andy Leonard AndyLeonard
Aaron Bertrand AaronBertrand
Aaron Nelson SQLvariant
Adam Machanic AdamMachanic
Allen Kinsel sqlinsaneo
Andy Warren sqlAndy
Arlene Gray whimsql
Bill Fellows billinkc
Bill Graziano billgraziano
Blythe Morrow blythemorrow
Brent Ozar brento
Brian Kelley kbriankelley
Colin Stasiuk BenchmarkIT
Denny Cherry mrdenny
Eric Humphrey lotsahelp
Geoff Hiten SQLCraftsman
Grant Fritchey GFritchey
Jeff Rush JeffRush
Jeremiah Peschka peschkaj
Joe Webb JoeWebb
Ken Simmons kensimmons
Kendal Van Dyke SQLDBA
Lee Anne Pedersen leeannepedersen
Lori Edwards loriedwards
Mike Walsh Mike_Walsh
Mike Wells SarasotaSQL
Pat Wright SQLAsylum
Peter Schott paschott
Peter Shire Peter_Shire
Ross Mistry RossMistry
Rushabh Mehta rushabhmehta
Steve Jones way0utwest
Stuart Ainsworth stuarta
Tim Benninghoff bugboi
Tim Ford sqlagentman
Tim Mitchell Tim_Mitchell
TJay Belt tjaybelt
Todd McDermid Todd_McDermid
Tom LaRock SQLRockstar
Trevor Barkhouse SQLServerSleuth
Wendy Pastrick wendy_dance
Wesley Brown WesBrownSQL
William McKnight williammcknight

 

That’s all for now; I’m sure more will come up as I think about it 🙂

All aTwitter about PASS Nominations

Lots of interesting conversations about the PASS nominations happening on Twitter today; if you are not up to speed, you’ve got a lot of reading to do.  I’ll try to sum up as best I can:

  • Some people applied to be nominated for board positions; a nominating committed approved 4 applications for 3 open positions.
  • 3 of the 4 positions are well-established members of the SQL community; one is a bit more controversial.
  • All 4 candidates have been invited to express their opinions on various forums, and all have been “interviewed” by Brent Ozar on his blog.  Links are below.

If you haven’t read these interviews, you need to.  For the most part, they’re pretty insightful, and they suggest what direction each of the candidates is moving in when it comes to PASS.  Matt’s candidacy raises some interesting questions about the nomination process, and the role of the Board in determining the direction of PASS.  It also raises some definitional questions about what PASS is, and what it should be.  I applaud him for his comments on Brent’s blog, because it takes a lot of guts to stand up under fire (even though I disagree with some of his positions). 

EDIT: I should have also stated that I applaud ALL of the candidates for their willingness to engage the members of PASS, including the first step of applying for the job. 

Before I go too much further, let me say that this post is intended to be an indictment of myself; I did not apply to be on the Board, nor did I even express much interest in the nomination process before today. I also didn’t even blink before I voted; I picked the three candidates that I felt comfortable with, and was going about my business until the conversations began on Twitter today.  I will not be so lax in the future.

What bothers me most about Matt’s candidacy is not his position, nor his background, nor the responses he gave to the questions asked of him; it’s the fact that he’s the only candidate that the community seems to have engaged in this fashion.  Granted, many of the questions asked were for him to clarify how his professional expertise would make him a good fit for the Board, and those are legitimate questions.  There were also other questions that were asked to help clarify his vision of direction for PASS which would have been suitable for the other candidates as well.  All of that’s fair game, but why didn’t we challenge the other candidates as well?

When I asked the question on Twitter, the general response I got was that “we know the other candidates; we don’t know Matt”.  That may be true, but even though we know someone, that should give us the opportunity to engage them on a deeper level than the “dark horse” candidate.  Instead, we as a community let 3 out of 4 candidates express themselves with little or no interaction from us, and instead focused on 1 controversial candidate.  I am not suggesting that Matt should not have been questioned; I am suggesting that we should have taken more advantage of the opportunity to get to know the other candidates better.

EDIT: As pointed out in the comments below, Matt was not the only candidate to engage with questioners; I didn’t mean to overlook the efforts of the candidates to make themselves approachable, but I did want to point out that many of us didn’t take them up on that offer.

Again, I’m pointing the finger at myself as much as anyone else.  I should have applied for the position; at the very least, I should have asked more questions before casting my vote.

PASS Summit 2009 – Twitter Bingo Players

Last call!  If you’re planning on being at PASS Summit 2009, and you have an active Twitter account, and you’d like to be sought after by millions of screaming fans (OK, that last part’s an exaggeration, but there will be people looking for you), please let me know by Friday, 10/16/2009.  So far, the following tweeple have signed up to be squares on the card (please check your handle for accuracy; I’m a lousy typist):

@stuarta
@BrentO
@WesBrownSQL
@RossMistry
@lotsahelp
@mrdenny
@AndyLeonard
@peschkaj
@sqlinsaneo
@Bugboi
@billinkc
@williammcknight
@leeannepedersen
@paschott
@SarasotaSQL
@SQLDBA
@AdamMachanic
@SQLvariant
@whimsql
@kbriankelley
@SQLRockstar
@kensimmons
@way0utwest
@BenchmarkIT
@sqlagentman
@tjaybelt
@GFritchey

UPDATE (I either missed these, or they saw this post and wanted to play):

@SQLAsylum
@SQLServerSleuth
@loriedwards
@SQLCraftsman
@Todd_McDermid
@wendy_dance
@Peter_Shire
@blythemorrow  (who should definitely be the center square!)
@sqlAndy (who MAY actually post something<G>)
@rushabhmehta
@JoeWebb
@billgraziano

UPDATE II (last call<G>):

@AaronBertrand

 

Although we have more than enough players to fill up a card, we could use a few more so that we’d have a truly random configuration.  We’re still working on some of the logistical details, like how you’ll be recognized as a payer when you don’t look like your avatar, but this is coming together.

UPDATE (AGAIN): Rough draft of card is up: http://sqlserverpedia.com/bingo/