24 Hours of PASS

February 17, 2012

Hooray – we’re ready to announce the details of the 24 Hours of PASS event that’s coming to an internet connection near you on March 21st! Read on for the day’s schedule, some of my thoughts on the 24 Hours of PASS concept, information about the platform, and an announcement which I think is really quite a big deal and worth making a fuss over.

24 Hours Straight

So – March 21st. No overlap with any other days, just 24 Hours of PASS, squeezed back into a single day. The last few events have been split over two days, running from noon to midnight (GMT), which conveniently fits in daylight hours of the Eastern United States. To help with the current push for internationalisation (and there’s more on that later in this post), we’re starting at midnight GMT (which is a perfectly reasonable 7pm in New York), and running through to the following midnight GMT (which is the next 7pm in New York, strangely enough). I’d like to be able to give prizes to people who attend all twenty-four, but I’m not quite that keen. Tell you what though – I’ll cheer on Twitter and my blog for anyone who tells me they’ve made it through all of them. I know people have done it before, and hopefully plenty will again.

VC involvement

The Virtual Chapter portfolio isn’t mine. It’s Denise McInerney’s. She’s doing a brilliant job, and we both see a strong correlation between 24HOP and the VCs. There are likely to be lots of people who tune in to 24HOP who haven’t really noticed that there are virtual chapters that meet, providing excellent online meetings, several times every month! We’ve roped in many of the VC leaders to help choose the sessions, host the sessions, and more. In fact, I suspect that many of the sessions that were submitted but not chosen could well be getting selected for the Virtual Chapters in the weeks and months to come. The Virtual Chapters are one of the best things about PASS, and it’s great that 24HOP can be showcasing them this time around. Most of the VCs are represented, including Performance, Data Architecture, PowerShell, Professional Development, and the larger ones like BI and AppDev. Even the newly forming BigData VC. The Oracle VC isn’t. Sorry, Scott.


LiveMeeting is such a great product. If you haven’t tried it out, you really should. It’s been our platform of choice here at 24HOP for ages now. Unfortunately, 24HOP seems to have outgrown it. People who have tuned in to recent events will have noticed that the video hasn’t always streamed as nicely as we’d like, and although we really do love LiveMeeting, we’re going to try a different platform – called IBTalk. This thing looks really impressive, and has some really cool features too. Most importantly, it should scale well. And record nicely. And allow eval forms nicely. And make coffee* (*feature list may not be completely accurate).


I know you’ve already read about how the event is going to be 24 hours straight, ignoring the fact that numbers may well be lower while the US sleeps. But that’s not the only way in which 24HOP is becoming more international…

During the event, the IBTalk people are going to provide Live Closed Captioning. So you can get subtitles during the event!

But there’s more…

This captioning will be available in fifteen different languages!

English, French, Spanish, Portuguese, Italian, Dutch, German, Russian, Turkish, Arabic, Traditional Chinese, Simplified Chinese, Japanese, Korean, and Thai. You want subtitles in Thai? No problem. Watching with a Turkish friend? Sure, no worries. Even if you’re just more comfortable in Dutch than English…

PASS is serious about trying to reach people around the world. With these languages, I think most people are covered. There are a few gaps, such as not having Swedish or Bangla – but apparently just about everyone in IT in those areas speaks English anyway (so I’m told).

The platform also has an amazing feature that translates questions, so if you’re more comfortable asking a question in Russian or Portguese, you can do that. The presenter will see the question in their own language, and the attendee will read the answer in theirs.

The Schedule!

As well as what you can see below, the schedule is live over at http://www.sqlpass.org/24hours/spring2012/SessionsbySchedule.aspx and http://www.sqlpass.org/24hours/spring2012/SessionsbyTrack.aspx. Please head over to the PASS site to register for the sessions you’re interested in. But in the meantime, check out this list! I’m sure you’ll recognise plenty of the names, but probably not all. You’ll also notice there are plenty of speakers from different parts of the world, including the UK (like Mark and Neil), Australia (like Julie), and Israel (like Ami).




Track / VC

00:00 – 01:00 GMT SSIS Tips & Tricks Josef Richberg AppDev
01:00 – 02:00 GMT Persistence In The Cloud: How to use Azure Storage David Giard Azure
02:00 – 03:00 GMT Tier-1 BI in the Age of Bees and Elephants Denny Lee BigData / BI
03:00 – 04:00 GMT Performance Tuning for Pirates! John Sterrett Perf
04:00 – 05:00 GMT Integrating DQS, MDS and Your Data Warehouse Christopher Price BI
05:00 – 06:00 GMT High Volume Data Processing Techniques Without Driving Your DBA Crazy! Julie Koesmarno Perf
06:00 – 07:00 GMT Upgrading and Overhauling Your SSIS Packages for 2012 Jessica Moss BI
07:00 – 08:00 GMT A Window into Your Data: Using Window Functions in T-SQL Steve Hughes AppDev
08:00 – 09:00 GMT VertiPaq under the hood Marco Russo BI
09:00 – 10:00 GMT STOP! Consolidate and Listen! Jorge Segarra Virtualization
10:00 – 11:00 GMT Where are my (primary) keys? Ami Levin Data Architecture
11:00 – 12:00 GMT SQL Server 2012 Memory Management Neil Hambly DBA
12:00 – 13:00 GMT Enterprise Data Mining with SQL Server Mark Tabladillo BI
13:00 – 14:00 GMT Automate Policy-Based Management using PowerShell Allen White PowerShell
14:00 – 15:00 GMT SQL Server First Responder Kit Kendra Little DBA
15:00 – 16:00 GMT Fitting Microsoft Hadoop into your Enterprise BI Strategy Cindy Gross BigData / BI
16:00 – 17:00 GMT Implementing SQL Server 2012 on Windows Server Core Edwin Sarmiento PowerShell
17:00 – 18:00 GMT A Deep Dive in SQL Server 2012 Data Warehousing Dejan Sarka BI
18:00 – 19:00 GMT Panel: I Was Young and Didn’t Know Any Better Karen Lopez ProfDev
19:00 – 20:00 GMT Introducing SQL Server Data Tools (SSDT) Nabeel Derhem AppDev
20:00 – 21:00 GMT Moves Like Jagger – Upgrading to SQL Server 2012 Mark Broadbent DBA
21:00 – 22:00 GMT What to Look For in SQL Server 2012 Execution Plans Grant Fritchey AppDev
22:00 – 23:00 GMT SQL 2012 – HA and DR Lots of New Options Joseph D’Antoni DBA
23:00 – 00:00 GMT Improving the Performance of your Data Warehouse Queries with Columnstore Indexes Benjamin Nevarez Perf

It’s going to be a massive event. Get registering soon!

[Edit: Most of this post also appears at: http://www.sqlpass.org/Community/PASSBlog/entryid/410/24-Hours-of-PASS.aspx]

This Post Has 2 Comments

  1. Rick Heiges

    Really looking forward to all of these enhancements!  Great Job!

  2. Paul Hunter

    I predict coffee sales will increase for a 24-hour period.

Leave a Reply

LobsterPot Blogs

Blog posts by Rob Farley and other LobsterPot Solutions team members.


Related Blogs