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.
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.
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]