24 Hours of PASS

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]

BigData featuring in 24 Hours of PASS

This is not the big announcement that I’ve promised about 24 Hours of PASS (which starts in five weeks from now!) – that’s coming later this week (and for those of you who haven’t picked up on it – 24HOP is the portfolio I’ve been given since becoming an elected director of PASS).

The announcement that is coming later in the week will contain the full schedule (which is being finalised as we speak), and will also include another piece of news that I’m very excited to be able to announce. (Although by now I’m curious about whether this will end up being an anti-climax for those of you expecting me to announce that we’re going to be broadcasting from the moon or something)

TSQL2sDay150x150But in keeping with this month’s T-SQL Tuesday (which feels like one of the only things that gets me taking time out to write – hard to think that it’s two years since I hosted), I thought I’d mention what’s happening on the Big Data side with 24 Hours of PASS.

If you haven’t been paying attention, Big Data is the Big Topic du jour. Microsoft is running with the Apache Hadoop platform – which is hugely significant when you consider the power of open source here. I’m not going to suggest that you’re missing out if you’re not already jumping in with both feet – but I think this area is set to grow significantly.

Anyway – I’m going to leak the details for two of the 24 Hours of PASS sessions. You’ll be able to register for these in a few days’ time.

At 02:00 – 03:00 GMT (what is this in your time zone?), we have:

Denny Lee: Tier-1 BI in the Age of Bees and Elephants

In this age of Big Data, data volumes become exceedingly larger while the technical problems and business scenarios become more complex.  This session dives provides concrete examples of how these can be solved. Highlighted will be the use of Big Data technologies including Hadoop (elephants) and Hive (bees) with Analysis Services.  Customer examples including Klout and Yahoo! (with their 24TB cube) will highlight both the complexities and solutions to these problems.

And at 15:00 – 16:00 GMT (what is this in your time zone?), we have:

Cindy Gross: Fitting Microsoft Hadoop into your Enterprise BI Strategy

What is this Big Data thing and why should you care? Learn about Microsoft's Hadoop connectors, our Hive add-in for Excel, what Pig and Hive are, and more. Big Data is an exciting foray into the world of data previously too big to load and query in an affordable manner. With the new Big Data tools you can expand your BI reach be the hero who helps your company make better business decisions.

Both these sessions are going to be great. If you’ve heard either Denny or Cindy present before, you know that they’re both technically excellent and fantastic presenters too. What’s more, with these sessions being roughly 12 hours apart, hopefully you can get to at least one, no matter where in the world you are. (In fact, Denny’s session is in the timeslot that the Adelaide SQL Server User Group uses – so we’ll be showing this on the big screen at our regular event).