Tag Archive: pass

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

Live-blogging the Seattle PASS Summit Keynotes

Whoa – I’ve hit the big time!  I got an email inviting me to be one of a handful of SQL Server industry bloggers who’ll get reserved seating with power and internet access during the PASS Summit keynotes.  Awesome!  That means I’ll be able to post live updates via my Twitter feed and here on the blog.  (Maybe Ustream too, but no promises.)

Last year was my first PASS summit and I did my best to convey as much information here in my blog recaps as I could for people who couldn’t attend.  I knew I was really lucky to get the expenses approved and get the week off to go to Denver, and I was in the minority.  This year, things aren’t any better for a lot of us: travel budgets have gotten slashed, and it’s even harder to get travel approved.  This year, thanks to the PASS staff, it sounds like I’ll be able to post my updates even faster live from the keynote.

I love it.  When I find out who thought of this, I’m gonna buy ‘em a beer.

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

To my readers who are traveling to one of the upcoming fall conferences, here’s a few of my favorite travel tips.

Use SeatGuru.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 different setups.

SeatGuru has maps of every airplane 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 that map on SeatGuru.  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.

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 being late to PASS.

Thinking about taking a late flight for a voucher?

Think again.  Those travel vouchers usually 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.

Not a frequent flyer?  Find someone who is.

If you only take one or two flights a year, and you’re not a member of any frequent flyer clubs, talk to people in your company who are frequent fliers.  Ask them if they want your miles for this trip.  If you’re doing a cross-country flight like Florida to Seattle, they might be willing to take you out to lunch and dinner in exchange for those free miles.  You just have to call the airline and tell them that you want to add your frequent flier number to your reservation, and give them your buddy’s account number.  There IS such a thing as a free lunch.

Leave a tip for the hotel maid on your pillow.

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.

Things to ask 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.

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, try to use a two-prong extension cord too, because not all outlets have three prongs.
  • 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.)

Set up your phone or PDA with my Twitter link

If you’re going to the PASS Summit 2008, bookmark these two links now on your phone or your PDA:

During the conference, I’ll Twitter 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.

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