Tag Archive: sqlpass

Which Sessions Will YOU Send to the SQL PASS Summit?

It’s votin’ time, folks. SQL PASS 2011 community sessions have been selected by the Program Committee, but there are still five slots up for grabs. Those five sessions are up to you, the community.

My Potential Session – “No More Bad Dates: Best Practices for Working With Dates and Times”

Vote for me and save this kitten.

Your votes could send me to speak at SQL PASS!

My “No More Bad Dates” session is up for community choice. Here’s the abstract for my session:

Dates and times seem simple at first. Kendra Little will show you there’s more to it than you think. She’ll give you five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. She’ll also explain painful problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale well and save development and administrative time.

Why I’d Like to Present This Session

This presentation surprises people. Dates and times are tricky, and they’re significantly evolving. We got some seriously big improvements in SQL 2008 and more cool changes are coming in SQL Server Denali.

I would love the opportunity to share these changes with the community.

How to Vote for SQL PASS Community Choice Sessions

Follow this link to the PASS Summit 2011 site. Log in with your existing account or create a new one. It should redirect you afterward to the voting page.

Then: vote!

Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. Read more and contact Kendra.

Website - Twitter - Facebook - More Posts

How to Get Budget Approval for Conferences

If you’ve never been to a conference before, the PASS Summit and Dev Connections events seem like things that happen to Other People.  This year, I wanna help make you one of us.  You’re a geek, right?  Let’s break this down into numbers.

Lightning Talks at the PASS Summit

Lightning Talks at the PASS Summit

What It Costs to Attend a Conference

People usually think conference attendees fall into two buckets: people who paid everything, and people whose company picked up the tab.  Truth is, there’s a lot of gray area, and when you’re getting ready to attend for the first time, you want to aim for that gray area.  You don’t want to pay the full costs plus take vacation time to attend.  We need to make your attendance as easy-to-digest for everybody involved, so let’s break out the three costs to attend:

1. Your salary for the week. I bring this up first because it’s your negotiation tool.  Companies love paying your salary because it’s already built into the budget.  They don’t have to do any extra approvals or paperwork to get you paid.  It’s already happening.  Your goal is just to keep it going during the conference week.

2. The registration fee. Registration for a 3-day conference is around $1,500 for early-bird discounts and around $2,000 for late registrations.  Focus on the $1,500 number because we want to get you registered as fast as possible.

3. The travel & hotels. Companies hate paying for travel, and managers hate asking companies to pay for travel.  There’s a lot of opportunities here to save money by staying at cheaper hotels and eating fast food value meals.  Add these two things together, and this is actually a huge benefit for your negotiations.  Watch how this works….

How to Pitch It To Your Manager

Think like a boss: cost #1 is already covered, and they want to avoid touching cost #3.  Let’s make negotiation easier by starting from a place they might just approve immediately:

“Good morning, your highness, how’s it going?  Wow, you look fabulous this morning.  That combover takes fifteen pounds off for sure.  Just fifty more to go!  Comb harder.  Hey, I was thinking about going to training next quarter.  It’s not available locally, and I know it’s hard to get travel approved, so how about if the company just pays for the $1,500 registration and I’ll pay the travel?  Nobody needs to know it’s out of town.  Here’s the list of topics they’re covering, and I’ll brief everybody on what I learned when I get back.”

See what I did there?:

  • You erased the money and political problems of travel
  • You didn’t even mention your salary – it’s an assumed win for you
  • You’ve reduced the entire discussion down to $1,500 for a training class, which isn’t unreasonable
  • You didn’t say it was a conference – I know, it’s a little slimy, but negotiations are usually slimy
  • You gave a list of topics the manager wants his staff to learn more about
Don't tell your boss about this part.

Conference Downtime

Now that I’ve got your attention, I have to admit that I’ve skipped a few things.  Before you talk to the boss, you need to be armed with a few things ready to go.  When you walk into that office, you need to have the following:

A printed list of the most high-value sessions you’re going to attend. Don’t just print out the entire session list and dump it on your boss’s desk – cull through it to find the sessions that give the most value to your manager.  There’s no need to tell him that you’ll be attending those professional development sessions or the after-hours vendor parties.  Just keep it to 10 session abstracts max, one page front & back, and for every session, have one sentence about what the business will gain from you attending that session.

The registration link for the session. There is a slim chance your manager will say, “Sure, let’s do it,” and you want to be able to strike while the iron is hot.

Your next half-hour free. He may ask you to fill out some budgetary approval paperwork, and you’re going to need to track down the right people to do it.  Offer to do everything for him – just get the contact name of the person in accounting who manages this kind of thing, and hound that person.  Introduce yourself as the guy who makes sure their servers run.  (I play dirty.)

The Three Most Common Ways to Say No

Here’s some of the most common management objections to sending you to a conference, and how to neutralize them:

“I can’t have you gone for a week.” I’ll have my cell phone with me the entire time.  If there’s an emergency, I’ll leave the conference and walk across the street to my hotel where I’ve got free WiFi, and I’ll spend as long as it takes to fix the problem.  Work always comes first.  (If they continue to object, remind them about the last vacation you took.)

“We’ve already used up our training budget for this year.” Well, I really want to learn this stuff to do my job better.  How about we split the costs – I’ll eat the training cost as long as I don’t have to take vacation for the week?

“Let’s talk about this in a couple of months.” Only if you agree that the company will pay registration.  If I have to pay registration out of my own pocket, I need to have an answer this week because registration cost goes up.

After The Boss Says Yes

Optionally, Buy a Kilt

Optionally, Buy a Kilt

Register as fast as possible.  Ideally, you’ll get someone with a company credit card to pay the registration fee, but if not, use your own card and submit an expense report right away.  You don’t have to wait for the event to send an expense report.  You worked hard to get to yes for this cost, and it’s the single biggest barrier standing between you and a week of happiness.  Knock ‘er down fast.

During the registration process, you’ll be asked if you want to attend any pre-conference or post-conference sessions.  These are day-long events taught by a single instructor, so they tend to go much deeper into a single topic.  At the PASS Summit 2011 in Seattle, for example, I’m giving my day-long session on Virtualization and SAN Basics for the DBA.  These pre-cons typically cost around $400 and I think they’re a huge bargain.  You don’t have to sign up for these right away, but if you can get the company to pay for one, I’d highly recommend it.  It’s usually an easy sell to bosses, too: “I can spend a day learning about virtualization and SAN storage for just $400.”  Bam, out comes the credit card.

Block that week out in your group calendar.  When people try to schedule team meetings, software releases, projects, whatever, you want to be able to say, “No, I’m going to training that week, and I’ve had it blocked out in my calendar since June.  It’s already paid for.”

Book your airfare.  My personal favorite travel booking tool is Bing Travel because it has nifty sliders to change your arrival and departure times.  I would recommend flying in at least one day early, preferably two if you can afford it.  You’ll either decide to attend a pre-conference session, or you’ll want to join in as other geeks roam around town doing things like photo walks and tweet-ups.  It’s a great way to meet your fellow Twitterers in a relaxed session, and it pays huge dividends in your career.

Reserve your hotel room, but don’t pay for it.  Hotels will let you reserve a room with a credit card, thereby locking in your room and your rate, without charging your card.  It’s called guaranteeing the room.  You usually have to cancel by 6pm on the day of the arrival, but that’s plenty of time.  By prepaying your room, you get a discount, but you lose flexibility.  If you get the chance to share a room with someone else and they’ve already prepaid their room, you’re out of luck.

Finally, when it works, post a note here in the comments.  Your fellow geeks are just as scared as you are to approach The Boss, and they need encouragement to know it can be done.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2013 Location: Charlotte, NC!

This morning, the Professional Association for SQL Server announced that the annual Summit will be held in Charlotte, North Carolina.  For the last 5 years, it’s been held in Seattle, and PASS members have protested.  We wanted the Summit to move around from place to place to make it easier for other people to attend and to let us see some different scenery.  (I mean really, how many years can we try to talk our spouses into going to Seattle in the fall when it’s cold and rainy?)  This year, it’s moving!  I’m so happy to hear this.

You can read the announcement at SQLPass.org.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Jeremiah Peschka & Buck Woody Talk Database Communities

Two of my favorite members and best speakers in the SQL Server community have made big changes – they’re refocusing their careers and their community work outside of SQL Server.  Is it the beginning of a trend?  What’s going on in the NoSQL and cloud database world that’s so attractive to these guys?  I interviewed them to find out.

Brent Ozar and Buck Woody

Me, Buck Woody, and the coolest quilt ever.

Buck Woody (Blog@BuckWoody) has worked for Microsoft since 2006, and until recently, he was our Inside Man – a fighter for the SQL Server data professional.  He switched roles over to the Azure team a couple of months ago.

Jeremiah Peschka (Blog@Peschkaj) joined Quest Software this year as a sort of technology evangelist, working with NoSQL and cloud databases.  Prior to that, he’s worked with SQL Server as a developer, database administrator, and consultant.  He just resigned from the PASS Board of Directors to spend more time working with the NoSQL communities.

Brent: Question 1. WHAT, SQL SERVER ISN’T GOOD ENOUGH FOR YOU?  Okay, well, if I’m honest, it isn’t good enough for me either, because there’s always more stuff I wish it did.  But what is it about these other database movements that excited you enough to focus more on those?  Give me your elevator pitch.

Buck: No – it isn’t good enough :) . But then, nothing ever is when you’re a curious person – and I’m one of those! I feel that utility-based computing is inevitable, and it’s all just data anyway – so Azure was a slam-dunk for me, a natural progression in my career. The tougher part was actually getting the position, since lots of really smart folks at Microsoft wanted the job. But I have those pictures….

Jeremiah: I’m excited because these new databases focus on one thing and doing it well. They each scratch a particular itch. SQL Server is a great general purpose database, but there are some things it doesn’t do very well – batch processing, massive parallelism, and scale out.   Many of these databases build on the skills that developers already have (object-oriented programming) to create complex solutions for ETL, analytics, and distributed storage – they’re good frameworks for complex tasks.

Brent: You’ve both been transitioning away from SQL Server for a few months.  What’s the state of these new database communities?  What are they like compared to the SQL Server community today?

Buck: Vague, undefined, and unordered. No, wait, that’s the cloud! So of course the audience mimics the product structure. Since Azure is essentially an online operating system that you write almost any code you want against, the users have a huge – I mean absolutely huge – range of skills, ages, interests and so on. So the community isn’t anywhere near as defined as SQL Server is. Not only that, it’s a new product, so the community hasn’t had time to define itself. I think over time we’ll get enough vertical interest groups that communities will form. It will just take time.

SQLSaturday Chicago

Me, Aaron Nelson, and Jeremiah Peschka at SQLSaturday Chicago

Jeremiah: The emerging database communities are very young right now. It’s difficult to figure out which databases will stick around for a while, but the communities are vibrant, changing, and open to new ideas. There’s a lot of energy, enthusiasm, and passion. People want to share what they know.

Brent: What can the SQL Server community learn from the NoSQL and cloud communities?

Jeremiah: The biggest thing that I’ve had to re-learn is that it’s important to look at every problem fresh and evaluate all of the options available before determining what to use. Sometimes it only needs to be a cursory glance, but other times it’s worth really examining what’s going to be happening and figuring out the best solution for the problem.

Buck: Agility and adoption, and focus on solving a problem, regardless of the technology. I don’t see nearly the stratification of the developers as data professionals, and the developers seem very willing to try anything new, as long as it solves their problem. They are also ready to move to the latest technologies.

Brent: How far away are we from the time when European or financial customers can adopt these new technologies?

Jeremiah: A number of European and financial customers are already using a variety of NoSQL databases. Booz Allen Hamilton are providing consulting services around Hadoop and Bank of America is also using Hadoop. a number of companies are using other NoSQL databases – ComCast are using Riak, and the New York Times and Intuit are using MongoDB. There are a bunch of NoSQL conferences happening in Europe – NoSQL:EU and Business Cloud 9.  I think that some aspects of cloud computing are further away in Europe due to EU regulations, but I could be wrong. I’m not as familiar with cloud databases as I am with the NoSQL space.

Buck: They are doing it now. In fact, after I type this I’m off to meet with a financial firm on their latest Azure application. It’s moving faster than most people realize, to Azure, Google, and Amazon.

Brent: If I wanted to keep an eye on the databases you’re working with, what are the top few blogs I should check out?

Jeremiah: I’d keep your eye on the NoSQLPedia blog aggregator, for starters. We’re adding more people on a weekly basis. Outside of that site specifically, things are still pretty fragmented at the moment.   In general, I watch Lars George for Hadoop and HBase news, the Basho blog for Riak, MongoTips and Snail in a Turtleneck for MongoDB news, Planet CouchDB for CouchDB, antirez.com for Redis, and http://facility9.com (of course) for my take on the entire thing.

Buck: I tend to like http://blogs.msdn.com/buckwoody :) , but anything Wayne Walter Berry writes is tres-awesome.

Brent: If – okay, when – I talk to you again in a year about you’re doing, what do you hope to have pulled off?

Buck: A significant growth in the “Azure Marketplace” – a site where you can sell your Azure “Apps” to other devs or even end-users. I’d like to see that thing eventually become the iTunes of the cloud.

Jeremiah: I want to see people actively using hybrid database solutions in their production environments. If I hear about someone using SQL Server for their RDBMS, Hadoop for batch processing, Hive for analytics, and Riak for caching and data distribution, I’ll be a very happy guy.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

#SQLPASS Summit Keynote Day 1

You can refresh this page every couple of moments to see what’s happened.  The most recent updates are at the bottom.

You can watch the keynote live online too.

Tina Turner Onstage at #SQLPASS

Tina Turner Onstage at #SQLPASS

8:21AM – Today opened with Tina Turner singing “Simply the Best.”  It’s either that or I drank entirely too much last night and Rushabh opened with a musical number, I’m not quite sure.

8:28 – Rushabh keeps talking about how we’ve touched a lot of people.  I think I read about this in the harassment complaint.  They’re aiming to touch more people – or maybe be touched by more people, I’m not quite sure – by webcasting the keynote live for free.

8:35 – Microsoft’s Mark Souza is playing doctor onstage to talk about the 400+ Microsoft development team members here to answer your questions.

8:39 – Talk to Microsoft folks, and you’re eligible to win all kinds of prizes including an XBox Kinect.

8:40 – “Everybody, look under your chair – if you’ve got an envelope, you just won a Dell Alienware laptop!”  Dang, all I got was chewing gum.  And of course you know I just felt under there without looking.  Ewww.  I won some used chewing gum.

SQLPASS Keynote

SQLPASS Keynote

8:42 – Rushabh’s introducing Ted Kummert to talk about some upcoming news.  WOOHOO!

8:46 – Playing a video explaining the history of SQL Server.  Best quote so far: “I figured if I could build an even halfway decent database, Microsoft could sell the heck out of it.”  Oh, the jokes are just zipping around.  This is a great video, though – really helps build a connection with the people building this tool, makes them personal and identifiable.  This is one of the best marketing-ish videos I’ve seen.  Nice work.

8:49 – Ted Kummert took the stage, and immediately started off by saying that a lot of the SQL Server people live & work in Seattle, and having the Summit here helps them send more people.  Oooo.  Okay, got the message there.

8:55 – SQL Server 2008 R2 Parallel Data Warehouse is now released to manufacturing.  This is a little tricky, though – it’s only sold through manufacturers along with hardware.  It isn’t available for download & testing on your own machine.  It’s sold as a big honkin’ appliance that you just plug in and go like hell.

9:00 – Demoing Parallel Data Warehouse with a 100TB copy of the TPC-H benchmark.  Eagle-eyed watchers will notice that this isn’t using SQL Server Management Studio – PDW has its own admin tool still.

Ted Kummert Onstage with a Parallel Data Warehouse

Ted Kummert Onstage with a Parallel Data Warehouse

9:01 – Running PowerPivot queries to suck a subset of the billions of rows – showing off the integration between PDW, Excel, PowerPivot, etc – talking about the whole-stack story.

9:04 – Here’s my thoughts on Parallel Data Warehouse from last year’s announcements and interviews.  I like the idea, but people need to remember that it’s not managed with traditional SQL Server tools or techniques or staff.  It’s a sealed box, and you can’t do anything with it – it’s manufacturer maintained.

9:05 – Yahoo’s onstage talking about their 12TB Analysis Services cube loading 60 50GB files per hour, 1.2TB per day, 3.5b events per day.  Less than 10 second average query times.

9:10 – Announcing Premier Mission Critical, Microsoft Critical Advantage Program for Parallel Data Warehouse.  No details on it though.

9:11 – Bob Ward announced & demoed Microsoft Atlanta – I’ve got a separate post with my thoughts on Microsoft Atlanta.  It’s a cloud-based SQL Server monitoring system that only works for SQL Server 2008 and R2 (and newer) that detects configuration problems.

9:18 – Cloud time!  Kummert says Azure needs to be self-managed, have elastic scale, and be agile & familiar.  It’s solving real business problems today.  Next up: we’ve got Community Technology Previews announced originally at PDC for Web Admin, Reporting, and Data Sync.

Demoing Azure DataMarket

Demoing Azure DataMarket

9:24 – Available now – the Windows Azure Marketplace DataMarket, something like the iTunes Store for data sets – both commercial and freely available.  They’re demoing how to add internet-accessible datasets from the DataMarket with, say, weather data, to enrich your reporting.  On rainy days, you sell less bicycles. I’m a big fan of this.

9:32 – Ted’s encouraging the audience to go sign up and get engaged in the cloud.

9:33 – “What’s Next for SQL Server?”  The next version is called SQL Server Denali for now as a code name, and I’ve got some quick information about SQL Server Denali.  They’ll be demoing it later, plus handing it out to attendees after tomorrow’s keynote.

9:37 – The changes in SQL Server Integration Services will be huge, he says – big improvements in management and servers.  R2 was a big release for reporting & analytics, plus Office 2010 focused on managed self-service analytics.  Excel users were empowered to build BI applications, and PowerPivot was embedded into SharePoint.

9:39 – Project Crescent is a new web-based reporting system letting end users tell their own stories about the data.  Amir Netz is demoing PowerPivot, then saying that’s good, but we need something bigger for enterprise datastores.  The new BI Development Studio, running on top of Visual Studio 2010 Premium, hooks into the same column-oriented storage engine that PowerPivot used, but now you can use it on a server so you get centralized security and bigger horsepower.

Demoing Column Store Indexes

Demoing Column Store Indexes

9:49 – SQL Server Denali will have columnar indexes built into the database engine.  Columnar indexes are what makes PowerPivot so insanely fast.  More on this later.

9:52 – They’re demoing Project Crescent to build reports.  Unfortunately, I gotta bail – off to set up for my session!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

The PASS Summit Location Survey Results

The Professional Association for SQL Server recently sent its members a survey asking where they should hold their next summit – in Seattle again, or rotate it around the country.  Initially we heard that the results wouldn’t be posted for a variety of reasons, but the PASS Board of Directors heard the community loud and clear.  PASS President Rushabh Mehta announced the survey results today.

Here’s a quote from the announcement:

“At first glance, the results seem fairly clear: 81% of the 1,573 respondents want a PASS Summit on the East Coast at least every four years.”

I was expecting a strong vote to move the Summit around, but 81% – that’s amazing.  Four out of every five people agreed.  It’s hard to achieve that kind of agreement in any kind of meeting at all!  The article continues to say:

“When we look at responses from only 2008 and 2009 Summit attendees (our most successful ones by far), the number who want a future Summit outside of Seattle drops to 69%.”

Let’s think about that for a second – if we want to increase PASS Summit attendance, that means getting new people to attend.  Forget the opinions of the people who’ve already been – what about the folks who haven’t been yet?  That’s the opinions we need to hear if we want to raise attendance.  Rushabh doesn’t quote that number, but it must be higher than 81% because the average went down 12% when these people were excluded.  Wow.

Seattle. Get Used To It.

Seattle. Get Used To It.

So PASS started investigating what it would take to move the Summit, and they said:

“We would not be able to achieve anywhere near the same level of support from Microsoft as we do when Summit is held in Seattle. We would lose out on at least 50% and likely 75% of Microsoft presenters, developers, and SQLCAT and CSS staff – all things a majority of survey respondents listed as important or very important.”

This is interesting, because this is where we need the raw data to answer a deeper question.  My question is, “Of people who haven’t attended the Summit before, how important is access to Microsoft staff?”  If we asked them to rank the following in order of importance, I’d be curious what they chose:

  • Access to Microsoft staff
  • Access to Microsoft MVPs
  • Access to your peers, SQL Server community members
  • Low hotel and food costs (under $150/day as opposed to over $200/day)
  • Summit location nearby (within 4 hours driving distance)

When I was a DBA, I didn’t attend the PASS Summit to talk to Microsoft folks, although that was a nice fringe benefit.  I wanted to spend more time with people who had the same job, challenges, and duties that I had.  I wanted to get tips on how to do my job better, and that’s something I didn’t get from Microsoft.

But back to the press release, which notes:

“Based on Microsoft’s release cycle history (major release cycles run approximately every 3 years, with minor ones often coming in between), 2011 or 2012 will likely be a launch year. It would be disappointing for the community to lose out on the advantages of being in Seattle during a potential release year.”

Uh, hold on a second here.  If major release cycles run every 3 years, and minor ones come in between, then the odds of having a release on any given year is 2/3!  Every year is a potential release year.  As far as I’m concerned, if Microsoft wants to promote a release, they can come to the community.  This is exactly their strategy in Europe – they’re coordinating with community leaders to host regional events all over Europe for the launch of SQL Server 2008 R2.  Why does the community have to come begging to Microsoft’s doorstep?  They’re the ones making money off us.

The final word is that we’ll be in Seattle for the foreseeable future:

“The Board has decided to hold PASS Summit 2011 and PASS Summit 2012 in Seattle for the reasons listed above.”

Well, the good news is that they laid out their rationale in public for all to see.  That’s awesome, and I cheer their movement toward transparency.  I don’t agree with their decision, but I’m glad they didn’t try to hide the poll results from us.  The users clearly don’t agree with the leadership, but we elected ‘em.  I’m also excited to see that this little ruckus has caused at least one person, Jack Corbett, to consider running for election this year.  If you don’t like the way things go, this might be a great year to run.  Having 81% of the members on your side on a given issue makes for a great campaign platform, that’s for sure.  “My name is ___, and I’m committed to bringing the PASS Summit to the East Coast, unlike the current Board who wants to keep it in Seattle through 2012.”  Presto, you’re in.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Recap: Discussions with PASS Board Members

During the Summit, I had the chance to talk to most of the PASS Board of Directors members in hallways, bars, and other off-the-record places.  I didn’t conduct formal interviews with them, but a few things consistently stood out when talking to each of them.

These are smart people. I’ve never had a conversation with any of the Board members and walked away shaking my head.  I’m not blowing sunshine up anybody’s rear, either – I’ve had my WTF moments with a handful of volunteers who haven’t made it up to the Board level.  (If you’re reading this, I’m probably not talking about you, because the people I don’t “get” also don’t seem to read blogs.  Or books about management, for that matter.  Don’t get me started.)

These are passionate people. There’s nothing in it for them other than the warm and fuzzy feelings they get knowing they helped people.  If you wanna get rich, become famous, or feed the poor, the PASS Board is not the route to success.  These folks just really, really want to help the community get its act together, and they care enough about it to devote their limited spare time to the cause.

These are patient people. Whenever I talk to Board members, I ask the same question: “Why on Earth would you run for reelection?”  Being on the Board is like a second full time job – it requires holding a whole lot of hands, some of which have claws.  Sit through a volunteer meeting and you quickly realize that you can’t pick (or fire) volunteers.  Every now and then I have my moments where I fire off direct messages to Steve Jones telling him we gotta run next year, but sitting in volunteer meetings I snap back to reality.  I don’t have the patience to deal with some of the crazy issues that come up, and I salute the Board for being able to pull it off.

They welcome input and help. Just like you and me – especially me – they don’t know everything, and they acknowledge that fact.  Like Jeff Atwood’s joke about starting StackOverflow, “None of us is as dumb as all of us.” They want your ideas about improving the community, and they need your elbow grease to make it happen.  Take a minute to talk to one of the Board members with a suggestion, and you’ll either hear a reasoned response or you’ll hear a pencil scratching down a note to figure the answer out.

The PASS Board isn’t perfect, but it’s the best thing we’ve got, and it’s heading in the right direction.

That’s enough for my PASS recaps.  Next week, it’s back to our regularly scheduled SQL Server and community posts!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Recap: Interview with Bill Graziano

I interviewed Bill Graziano, the VP of Marketing for PASS, at the PASS Summit this year. Bill has a contagious upbeat excitement about him that makes him a good marketing guy. He started the Blogger’s Table at the PASS keynotes last year, and we started by talking about his accomplishments in marketing PASS.

Bill’s Recent Accomplishments

Bill is very proud (rightfully so) of PASS’s imagery and branding. PASS has built up a very recognizable look and feel that shows up across all of their marketing materials. The web site, Summit signage, emails, all of it has a repeated look. The imagery will be consistent from year to year at the Summit, and they’re extending it to the European events as well.

That repeatability was a theme I heard from several Board members including Wayne, Bill, Andy Warren, and Douglas McDowell. All of them were focused on putting solid, repeatable, measurable processes into place that could be consistent over time. The more day-to-day work that can be automated or turned into a checklist, the more the Board members can focus on long-term vision work instead of fighting fires. Heck, it’s no different than us DBAs adopting Policy-Based Management – done right, it frees you up to do the things you really enjoy.

Bill and the marketing team have built a strategy for how to deliver their messages, and they’ve built targeted messages for each month of the year, all driven to increase Summit attendance. They’re starting to repeat this year after year, and they’re working on finding other ways to reach new members. Historically, our first-time-attendee percentage has averaged around 42%, and he wants to continue to grow the number of first-time attendees. One of those ways uses social networking.

PASS and Twitter

A while back, Paul Nielsen got a @SQLPASS Twitter account, and over the last year it’s gotten more and more traction. Last year’s Twitter discussions about the Summit were real eye-openers for the Board, and they’ve been monitoring it ever since. This year, Twitter enabled real-time attendee feedback for even the most minor things (like a certain hallway needs more cookies) and helped PASS to react faster to attendee needs. Wayne’s story about including the keynote on the DVD is a great example.

Bill wants to broadcast the keynote videos live over the internet along with the Twitter #sqlpass stream like Microsoft does for the Mixx and PDC conferences. It all comes down to money – it’s free for one guy to do a home webcam, but it’s nowhere near free to do professional video the way PASS has done keynotes. The PASS keynotes have cameras, multiple live demos from different computers, slide decks, and more, and cost quickly goes up from there. I know somebody’s going to say volunteers could handle this, but I’d disagree. Even if we had free labor, we would need some expensive gear, and the Convention Center isn’t in the business of loaning that stuff out. Before we even think about letting volunteers try something like this, I’d ask the volunteers to prove themselves by doing a similar event at the regional level, like a SQLSaturday session with live video of multiple computers and speakers.

To me, PASS focusing on Twitter makes sense because PASS is going somewhere that the community’s already staked a claim. The community’s live and vibrant on Twitter, and PASS won’t be trying to bring people into foreign territory. It doesn’t cost a lot, doesn’t require building a new infrastructure, and doesn’t require volunteer time. PASS’s presence on LinkedIn is another no-brainer.

Some of PASS’s Recent Struggles

Unfortunately, a lot of PASS’s recent efforts (not necessarily marketing) haven’t been as successful. The wiki whitepaper and PASSPort projects have tried to get DBAs to go somewhere new and contribute new content, and they’ve failed miserably. (Bill’s face completely fell when I mentioned the word PASSport – it’s obviously a sore spot.) The vision for PASSport was a private Facebook with single-sign-on hooked up to the rest of PASS’s sites – but the reality just isn’t there yet. Nobody’s sure of what to do with it next, and finishing it requires money and time. Wiki whitepapers is even worse – the infrastructure is there, but nobody bothers to fill it out.

Given their limited resources, I asked why PASS had chosen to pursue a magazine (they’re relaunching the SQL Server Standard as a web-only publication.) Bill explained that sometimes what PASS does is based off the passion and hard work of a single board member. When someone wants something badly enough, they’ll make it happen. (This reminded me of Wayne’s remark about local chapters being built on the backs of heroic individuals.) In the case of the Standard, the primary driver was Andy Warren. Andy’s passionate about relaunching the magazine, and he helped make it happen. I asked why the Standard will succeed where PASS’s wiki whitepapers, another member-generated-content idea from last year, failed. He didn’t have an answer, but of course I shouldn’t have expected it – it’s not his endeavor. (I gotta ask Andy about that one.)

Bill echoed Wayne’s comments – PASS has no shortage of ideas, just a shortage of money and time. They need more HQ staff and more active volunteers. PASS can’t keep throwing new projects against the wall willy-nilly without a very long term plan because it runs the risk of not being taken seriously. Personally, I don’t take the Standard seriously because I don’t see a long-term future in magazines that pay contributors for content. Blogs are just evaporating that market. You can’t compete with free, especially if your goal is to diversify PASS’s revenue streams. There’s little money in paid content anymore.

PASS used to have forums, but they died off due to inactivity. They’ll be returning now that PASS members seem to be more active online. DBAs are solitary, Bill said, and they need a place to commiserate about their challenges. Forums might serve that need, although PASS doesn’t want to compete with other existing sites. I agree that PASS needs forums now that the community’s really starting to talk about PASS-specific things like voting, presentation selection, and PASS Summit topics. Bill says that as PASS matters more, people care more, and they talk more.

Bill’s New Role: Executive VP of Finance

I asked Bill what his first priority would be in his new position come January, and his response was pretty simple: ask people what they want. He intends to survey the daylights out of PASS members to find out what’s important to them in general, and what’s important to them about the Summit. Does the location matter? Does the social interactivity matter? Do the number of Microsoft-presented sessions matter? He wants to ask a lot of questions, and then set about delivering the kind of community people want.

Right now, PASS is a 2,000 person conference with a library of 40,000 reachable email addresses. He wants to plan for what happens in the future, and how we’ll be able to scale it all up to higher numbers. That’s the mark of a good DBA, too – picking metrics and trying to figure out how the system will react as those numbers increase. Bill asked some interesting questions, too, like why don’t we have a hundred virtual chapters, each with people who are really passionate about a specific narrow topic? How do we build up our virtual chapters to grow the same way our physical chapters have grown? I asked how he perceived the differences between virtual and physical chapters, and he didn’t have any preconceptions. He said they’re both needed, and an advantage of the physical chapters is that there’s a local job community with good recruiters. Virtual presence (LiveMeetings) are still hard now, but they’ll be easier in ten years. It’ll be interesting to see how things shape up.

As he leaves the VP of Marketing role, he wants to make sure that marketing is already a process. That way, the incoming VP of Marketing (Rick Heiges) can simply start marketing, rather than trying to figure out how PASS does marketing.

I asked Bill what it takes to succeed as a Board of Directors member. Bill’s idea of a blank-sheet, from-scratch board would include managers who can delegate tasks to people who have no need to do these tasks, and get them to do it. Talk about a tough role! You have to know how to use recognition and pride to encourage people to do a good job. I agree wholeheartedly, and I think future candidates would do wise to think about that. It takes someone with infectious enthusiasm like Bill’s to make the magic happen.

Next Up: Interview with Val Fontama

In my next PASS Summit interview post, I’ll recap my Project Madison conversations with Microsoft’s Val Fontama.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

My Weekly Bookmarks for October 30th

Here’s my bookmarked links for October 26th through October 30th:

SQL Server Links

#SQLPASS Links

Tech Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Travel Tips for Non-Frequent Flyers

If you’re traveling to one of the upcoming fall conferences, here’s a few of my favorite travel tips – as inspired by Kevin Kline’s recent travel tips post.  (If some of these familiar, it’s because I originally ran parts of it last fall before the conference season.)

Use SeatGuru.com or SeatExpert.com to get the best seat.

I’m not talking about first class versus coach – even in coach, not all seats are created equal.  Every plane has some surprise seats that have more room or awkward armrest setups.

SeatGuru and SeatExpert have maps of every plane flown by every airline.  Call your airline or check online to find out the exact make & model of plane you’re flying and then pull up the SeatGuru or SeatExpert map.  The seats are color-coded by comfort level.  Hover your mouse over your seat, and you’ll see detailed notes about the comfort level of that particular seat.  Then, with that map up on your screen, call your travel agent or go to your airline’s web site to change your seat.  You can sometimes do this online even when it’s too early to check in for your flight, and the earlier you do this, the better your chances are for getting a good seat.

I’m typing this from the comfort of a Continental Embraer RJ-135, seat 12A.  It’s an exit row seat with no seat on either side of me, so I have plenty of space in front of me for my legs, and plenty of space on either side for my arms.  It didn’t cost me any extra – I just went to Continental.com and tweaked the seat on my reservation.

For long flights, I recommend the aisle seats because it’s easier to get up and go to the bathroom and the bar.  What?  You didn’t know about the bar?  Anytime you’re thirsty, just head to the flight attendant area, and they’ve usually got water, soda, and snacks available for self-service customers.  If you’re right-handed, get the aisle seat on the left side of the plane so that you’ve got room to maneuver; I find it easier to type, move the touchpad around, and so on when I’ve got room for my right elbow.

If you don’t find a better seat, don’t give up: check again exactly 3 days and 2 days before departure.  Airlines automatically upgrade their elite frequent fliers to first class for free at those times, and guess what – that means their seats in coach are suddenly empty.  These people are exactly the kinds of people who usually know to grab exit row seats and those “special” seats with more room, so you’ll find these seats opening up again.

No assigned seat?  Check in online ASAP.

If your airline reservation doesn’t show an exact seat number, your flight may be overbooked.  Airlines routinely overbook flights because not everybody shows up for a flight.

Go to your airline’s web site and try to check in right now.  You won’t be able to, but it will tell you when the flight checkin will open up.  Set yourself a reminder to check in at that date/time.  The earlier you check in, the more likely that you’ll get an assigned seat.  The later you check in – well, let’s just say you don’t want to get a miserable $100 air travel voucher in exchange for missing the first day of PASS.

Knock yourself out on long flights.

Drool Not Shown

Drool Not Shown

Forget paying extra for a first class upgrade.  Get a travel pillow for under $10.  The one shown here is an inflatable model, which is nice because you can deflate it and stick it in a laptop bag.  If you don’t want to carry one around, you can usually pick up the non-inflatable ones in airport gift shops for around $20.

Now, I know what you’re thinking – you’re thinking that wearing an inflatable toilet seat around your neck will make you look stupid.  You’re wrong.  The drool coming out of your mouth is what’s going to make you look stupid.

As you’re boarding, take a sleeping pill.  Settle into your seat.  If you want a blanket, buckle your seatbelt on the outside of your blanket so that the flight attendant won’t have to wake you up to make sure you’re wearing it.  You’ll be out like a light in no time.

Conquer time zone changes with vitamin B12.

This tip comes from Douglas McDowell of SolidQ, and it’s saved my bacon more than a few times now.  Pick up some vitamin B12 pills at your local drugstore and keep ‘em in your laptop bag.  I prefer blister-packed sublingual pills – the sublingual ones that come in a bottle break up pretty quickly if they bang around.  Take one, and you’ll be comfortably awake for a couple of hours, but not wired or jittery.

Caffeine is the wrong answer – it dehydrates you, makes you jittery, and has other side effects that you want to avoid when traveling.

Be wary of taking late flights for travel vouchers.

Those travel vouchers sometimes have blackout dates, and the blackout dates are like “Valid only for trips with a Saturday stay on the third week of the month.”  If you really want to risk it, then talk to the airline staff before you volunteer the seat.  Ask whether the voucher has any restrictions at all, and ask them to show you one of the vouchers.  If it says anything about “Only valid for fare code X”, there’s a catch.

Oh, and whether you’re delayed by weather or you take a late flight by choice, call your hotel to let them know.  If you don’t show up by midnight, they have a tendency to give away your room to somebody else when they’re booked solid.  Don’t expect to be able to waltz in the next day thinking your room will still be held for you.  If you don’t show up on the day of your reservation, they might charge you for one night’s stay, but they won’t hold the room for your entire stay.

Leave a tip for the hotel maid on your pillow.

The Wrong Kind of Rock Star Behavior

The Wrong Kind of Rock Star Behavior

Hotel maids make minimum wage, and it’s common to leave them tips.  Some folks only leave the tip on the day of checkout, but I prefer to leave a tip daily because the same maid may not clean your room the entire time – they do get days off, ya know.

Also, make it as easy as possible for the maid.  Use just one trash can if you can, and dump your used towels in a single pile on the toilet seat (with the seat closed, speedy).  It’s less bending over for them.

Plan questions for vendors and peers.

Ahead of time, make a list of projects you’re working on, new products you want to implement, or large challenges that you’re facing.  Write this stuff down now, because you won’t remember it when somebody asks, “Do you have any questions?”  Us humans are terrible at that.

This is just my personal opinion, but I say do NOT ask tech support questions at a conference.  Tech support people aren’t usually the ones sent to conferences.  If you want support, call the support line.  If you have large architecture questions, implementation ideas, or tips and tricks, then you’ll find good answers at a conference.  If you’re getting error 0×8004005,search the web.

Make a list of things to bring to the conference.

Here’s a list of things you may not think to bring along:

  • A small, light extension cord or surge strip. There’s never enough outlets, especially at tech conferences.  If your laptop has a two-prong electric adapter, bring a two-prong extension cord too, because not all outlets have three prongs.  A 2-prong extension cord will get you into places other people can’t go.
  • An extra laptop battery. It ain’t cheap, but if you want to take notes during the sessions, it’s easier if you don’t have to fight over power outlets.
  • Business cards. If you have a personal web site you want to promote, or if you use Twitter, order business cards now.  They’re surprisingly inexpensive if you’re doing simple text with no logos – like $10 for 250-500.  I order a set just for conferences that have conference-relevant information like my work email, personal email, Twitter link, web site links, etc, but not mailing address.  (Nobody at a conference wants your snail mail address, although you can put city & state if you want an icebreaker.)  For ultra-personal cards, check out Moo.com.

Don’t feel guilty about skipping sessions to mingle.

I make a list of sessions that I absolutely can’t miss, but the rest of the time, I wing it.  If I get the chance to have a one-on-one impromptu chat session with somebody really brilliant, I’ll go for that, because frankly, that’s worth way more than a session.

For example, I got the chance last year to sit in the hallway during a session and do some impromptu data mining with Donald Farmer, and that’s one of my favorite memories from the Summit.  Did I miss a session?  Yep.  Did I feel guilty?  Only for about the first five minutes.

Leave the support calls at home, or bring your evidence.

PASS is a great place to get access to some of the brightest minds in the database business.

It’s a really crappy place to open a support case.

If you’re struggling with a problem that you just can’t fix, and you’ve opened a support case with Microsoft (or in my case, Quest), it can be tempting to approach Microsoft employees and ask for insight.  You know how when the doctor bangs your knee, your leg jerks up?  I have a really similar reaction.  When someone says they’re having a problem, I blurt out, “I need your Windows event logs – both system and application – plus the results from sp_configure and dbcc tracestatus.”

If you’re going to ask support questions, be fair – bring along your support case number, a folder with all of the evidence you’ve gathered so far in the case, and a laptop that can access the system remotely right now.  Armed with that, you stand a great chance of getting great minds to ponder your problem and cooperate with you pronto.  Without that, you’re probably going to get a polite smile-and-nod-I-feel-your-pain.

Never eat or drink alone – tweet with #SQLPass.

If you’re going to an upcoming conference, bookmark these two links now on your phone or your PDA:

During the conference, I’ll tweet whenever I find out about after-hours events, dinners, meetups, or spontaneous meetings during the day.

I remember what it was like going to PASS 2007 as an attendee who didn’t know anybody – man, it was tough to find out what was going on!  I ate lunch and dinner by myself most of the time.  Let’s face it, us DBAs aren’t always the best party people.  (Except for the PASSCamp Germany guys, they know how to put on a party!)  Now that I’m an insider (woohoo!) I’ll share the knowledge to get you folks into the action.

A lot of us will be roaming around downtown Seattle with our handheld gadgets, monitoring the Twittersphere for the phrase #SQLPASS in much the same way that truckers use their CB radios to monitor channel 19 looking for bears.  When you’re bored, get on Twitter and say so, but make sure to include the phrase #SQLPass.  Someone will hear your pain and tell you where the party’s at.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts