Category Archives: SQLCruise

Wanna win a trip on SQLCruise Miami?

You’ve gotta act fast.  Idera’s giving away a free trip for two on the next SQLCruise in their Get A Life Contest.  All you have to do is submit a picture of yourself enjoying your favorite pastime, along with a quote describing how SQL diagnostic manager has helped you get a life – then get people to vote for you.  It’s not as hard as you think – there’s only a couple dozen entries at the moment – but the deadline is coming up fast.

In case you’re wondering what all the SQLCruise fuss is about, here’s a reminder in the form of the SQLCruise Miami 2011 movie trailer:

And hey, one of the entrants will be chosen at random to get an iPad 2, and this is probably the best chance you’ve ever had to win one of those, so hop to it!  Enter now!

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

SQL Cruise 2012 Registrations Open

The schedule is out!  Here’s where we’re cruising next year:

Brent Ozar Presents

Me Presenting on SQL Cruise

SQL Cruise Miami 2012 departs from Miami, FL on Saturday, January 28th on the Norwegian Epic.  We spend two days at sea training, then spend all day Tuesday in beautiful St. Marten.  On Wednesday we hang out in St. Thomas just a ferry ride away from my favorite island on the planet, St. John.  Thursday we get our learn on again, and then Friday we spend an afternoon in the Bahamas before arriving back home on Saturday.

SQL Cruise Alaska 2012 leaves Seattle on Saturday, May 26th on the Norwegian Jewel. When we’re not learning at sea, we’re spending entire days in Ketchikan, Juneau, and Skagway, plus an evening in Victoria before returning to Seattle a week later.  You’ll come back home rested and ready to tackle old problems with new techniques.

Me, Doug Lane, and Tim Ford

Me, Doug Lane, and Tim Ford on SQLCruise Alaska 2011

My Sessions on SQL Cruise 2012

Scaling SQL with Solid State – SSD prices are coming down and adoption is going up.  My clients have used them to solve all kinds of performance problems, and we’ve found some surprising results.  In this session, I’ll explain the internals of these fast drives and show the pros and cons of the various connection methods (SATA, PCI Express, SAN).  Then we’ll switch over to the SQL Server world to see how to tell when and where you need SSDs.  You’ll even get real-world before-and-after metrics to help make the case to management.

Procedure Cache BI – SQL Server stores tons of data about SQL statements and execution plans in memory, but unfortunately a lot of it is hard-to-query XML.  I’ve got the fix: we’ll treat it like a BI project.  We’ll build an ETL process to get the data out, normalize it into a reporting structure, and then make smart tuning decisions based on the aggregated findings.  You’ll step off the boat armed with ready-to-go scripts to do consultant-style analysis right away.

SAN Features for Senior DBAs – SAN snapshots and SAN replication can be the DBA’s best friend.  They bring one-click disaster recovery options to antiquated SQL Server 2000 instances, and one-minute backup options to even the largest data warehouses.  In this session, we’ll cover how my clients have saved time, money, and manpower with these features.  We’ll briefly dig into the “how” using NetApp as an example SAN, and then cover the SQL Server management techniques that work regardless of the SAN vendor.

There’s more sessions from other presenters including:

  • Making You Look Smarter One DMO at a Time – Tim Ford (Miami & Alaska)
  • The Lazy DBA – Tim Ford (Miami & Alaska)
  • SQL Server in Amazon’s Cloud – Jeremiah Peschka (Alaska)
  • SQL Server Internals – Jeremiah Peschka (Alaska)
  • Faking Big Data – Kendra Little (Alaska)
  • Everyone Wants a Piece of This – Kendra Little (Alaska)

On SQL Cruise Alaska, I might never get off the boat, though, because Jeremiah, Kendra, and John & Yanni Robel teamed up with me to get the Garden Villa room.  Here’s a video tour:

That’s the perfect place for SQLCruisers to gather when we’re not in class.  SQL Cruise isn’t just about the classroom training: it’s about access to some of the brightest minds in the SQL community.  You get the ability to network with MCMs, MVPs, and SQL Server professionals in a relaxed, no-holds-barred environment where no question is off limits.  Bring your technical challenges and your career challenges.

Come join us – check out SQL Cruise and register today.

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

SQLCruise 2011 Miami: The Movie

Want to know what it’s like aboard SQLCruise?  Here’s our SQLCruise 2011 Miami movie trailer:

You can read more about our adventures in our day-by-day recaps:

Two months left before we set sail on SQLCruise Alaska.  I cannot believe this is my life.

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

SQLCruise News & Giveaway from Idera

When Tim and I launched SQLCruise, the first agenda focused mostly on junior-level training.  Much to my surprise, most of our attendees skewed much toward the expert tier.  So when we designed the SQLCruise 2011 agenda, we specifically came up with two separate cruises: a 7-day expert-level Alaska cruise, and a 5-day junior-level Caribbean cruise.  The expert-level cruise sold out in under twelve hours, but the junior-level one only halfway sold out.

SQLCruise 2010

SQLCruise 2010

We started asking the Alaska attendees and our friends, “Why did the Alaska one sell out?”  They had one unanimous answer: they all want expert-level training.  My guess – and this is just a guess – is that the junior-level attendees can’t usually get a training budget, or they get junior-level training on the web for free.

Then we asked the Miami attendees, “Why did you sign up?”  Their answers were pretty funny: most of them expected us to change the agenda or sneak in some expert-level training!  (Well, except for Mike Decuir, who works with Yanni Robel at AllRecipes.com, a cool company that really does invest in employees.)

I give up – the customers have spoken!  We’ve upgraded the SQLCruise 2011 Miami agenda.  The Miami cruise will get the same level of training as Alaska, but just less of it since it’s a shorter cruise.  There’s 7 spots left, too!

But wait – now that I’ve got you ready to sign up for the Miami cruise, I’m going to throw you a curveball.  Idera is giving away a free spot on the cruise! Should you sign up now and get a guaranteed spot on the cruise, or enter the contest hoping you’ll win?  Decisions, decisions…

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

SQLCruise 2011 Registrations Open

We’re open for bookings!

SQLCruise Classroom at Sea

SQLCruise Classroom at Sea

March 6th – Miami to Grand Cayman and Cozumel for 5 days – this cruise will provide introductions to high availability, performance tuning, DMVs, and of course the team-building, blog-building, and you-building that SQLCruise is known for.  This cruise is aimed at database administrators who’ve been working with SQL Server for 1-3 years.

May 29th – Seattle to Alaska for 7 days SOLD OUT! – this cruise will be a deeper dive into HA, tuning, SAN storage, and MDVs.  This one will be technical alright – this is aimed at DBAs with more than 5 years experience working with SQL Server.  I want to cover the kinds of topics you don’t usually get to play with as a DBA, but that really affect your performance and recoverability.  It’s not every day you get to spend quality time talking SAN internals, and that’s what this cruise will be like.

From my Alaska cruise this year

From my Alaska cruise this year

Spots are going fast already, and I credit that to the experience our cruisers had the first time around:

“Without a connection to work I could learn and focus without distraction. Not being able to disconnect myself has ruined many training opportunities for me so I was excited to be able to chuck my cell phone into my room and go.” – Crys Manson on SQL Cruise I Miss You (and yes, she signed up already for the 2011 Alaska cruise)

“Third, and I can’t stress this enough, you not only get back an employee with a deeper understanding of how the training applies to your environment but you get one that now brings a whole team of people to call upon if the situation arises.  What do I mean?  When, the social aspects of this tight net group and the dynamics that were developed in five days were pretty amazing.” – John Robel on Where has all the good training gone (and yes, he and his wife Yanni were the very first to sign up for the 2011 Alaska cruise)

It’s not just repeat signups either – we’ve already got new bookings from Colin Stasiuk, Gareth Swanepoel, Gavin Payne, Neil Hambly, and more.

Update – we sold out the spots on the Alaska cruise in one day! Spots are still available on the Miami cruise though.

Get on over to SQLCruise.com and check out what we’re up to.  See on you on the boat!

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

#SQLCruise 2011 Schedule Announcement Tomorrow

It’s hard for me to call our first SQLCruise anything but a success.  We sold out, every cruiser actually attended every session, and nobody fell off the boat.  However, we did learn a few things, and we’re applying those lessons to our upcoming 2011 schedule.

We’re doing two 2011 SQLCruises for two different audiences. We’re doing a 5-day cruise out of Miami targeted at production database administrators with 2-4 years of experience, and a 7-day Alaskan cruise out of Seattle targeted at production database administrators with 4-6 years of experience.  Here’s how I think of the audience: if you’re aiming to get an MCITP certification, attend the 5-day cruise.  If you’re the kind of person who wishes they could get the MCM, attend the 7-day one.  In both cruises, we’re going to cover advanced topics, though – this isn’t your typical 45-minute lightweight training session.

Both cruises have two full days at sea. We wanted two interrupted days of activities – not necessarily 10 hours straight of training per day, though.  There’s only so much time you can spend sitting in a classroom taking notes, and we want to mix things up.  We’ll be breaking up the learnin’ with the lighter, more interactive sessions, and we’ll also be getting some training in on the partial-sea days.

We’re going to let attendees do some of the talking. Several of our original cruisers had fantastic experience with subject areas that are way, way outside of the typical DBA’s work.  For example, Crys Manson (Blog@CrysManson) works with SQL Servers behind load balancers, and just ten minutes of whiteboarding about how that works would totally intrigue the rest of us.  I’ll be working with attendees to lead discussions about some of the more unusual things about their jobs and their businesses.

We’re going to give you a better picture of where you’re at. Overwhelmingly, all of our cruisers kept asking questions like:

  • “I’ve got X years of experience, but am I a senior DBA?”
  • “Am I the only person who spends X hours a day doing ___?”
  • “How do other people solve this problem?”
  • “What’s supposed to be the next step in my career?”
SQLBBQ 2010 at the Swanepoels

SQLBBQ 2010 at the Swanepoels

We’re going to cover those in detail on both cruises.  I’ll be handing out a checklist of common tasks, and attendees will rate their comfort level with each of ‘em.  We’ll gather the results and then discuss where the “average” DBA is based on what I see in the field.

We’re going to stick with what worked. Before the Miami cruise, Gareth and Jennifer Swanepoel (@GarethSwan) were gracious enough to host a #SQLBBQ at their house before we embarked on the cruise.  It was a fantastic way to get to know each other, and they’re doing it for us again!  Gareth and Jen will even be joining us on the Miami cruise, too, so we get to spend more time with my favorite South African.  (Sorry, Nelson Mandela.)

We’re going to get the sponsors even more involved. Coming from a software vendor background, I know how much talent our sponsors have in-house.  Sure, you see guys like Kevin Kline, Jeremiah Peschka, Steve Jones, Brad McGehee, and Aaron Bertrand because they’re the public faces of Quest Software, SQL Sentry, and Red Gate, but it’s bigger than that.  They have developers in-house who write software tightly integrated with SQL Server, and they have support teams who see some crazy implementations.  Vendor staff aren’t just salespeople, and they have a lot to bring to the discussions and questions.  During the first cruise, the cruisers asked how various problems could be solved, and I want a technical person on board from each vendor to help answer those questions.  I’m excited to announce that Quest, SQL Sentry, and Red Gate have signed on as sponsors for both 2011 cruises!

So now you wanna know when the cruises are, right? Well, you’re about to find out – tomorrow (Thursday) at 8AM Eastern, we’ll be announcing the cruise dates & locations on SQLCruise.com and on @SQLCruise’s Twitter feed.  We’re still limiting each cruise to just 15 attendees, and we’ve opened up registration to our past cruisers first.  They’ve already taken a handful of slots, so we expect the cruises to sell out fast.  See you online tomorrow morning!

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.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube