24 (Hours of SQL Training Delivered to Your Computer)

The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16 starting at 12:00 GMT (UTC) each day! I and 23 of my awesome techie womenfolk will dazzle your SQL sesnses with two days of Business Intelligence, DBA, and Development sessions!  Be sure to register right now to reserve your spot today.

I would also like to suggest that you pick key sessions, and set up a learning day (or two!) at your office for your database and dev teams.  Your boss will flip over two free days of training from SQL Server authors, MVPs, and MCMs!

My session is a SQL Saturday favorite: T-SQL Code Sins: The Worst Things We Do to Code and Why.  It starts at 19:00 GMT on March 15

Abstract: It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.

Session Goals

  • Identify common bad practices in database development.
  • Identify common-sense solutions to database development bad practices.

All 24HOP Sessions!

I tried to pick a few sessions that I’m really looking forward to, but the list was too long to qualify as “a few”. Instead, here is the full schedue, for your perusal:

March 15, 2011 

 Session 01 (DBA) – Start time 12:00 GMT on March 15
SQL Server AlwaysOn: the Next Generation High Availability Solution
Presenter: Lara Rubbelke

Session 02 (BI) – Start time 13:00 GMT on March 15
Dashboards Design and Practice using SSRS
Presenter: Jen Stirrup

Session 03 (Dev) – Start time 14:00 GMT on March 15
Spatial Data: Cooler Than You’d Think
Presenter: Hope Foley

Session 04  (DBA) – Start time 15:00 GMT on March 15
SQL Server Performance Tools
Presenter: Cindy Gross

Session 05 (BI) – Start time: 16:00 GMT on March 15
Cool Tricks to Pull From Your SSIS Hat
Presenter: Julie Smith

Session 06 (Dev) – Start time 17:00 GMT on March 15
No More Bad Dates: Using Temporal Data Wisely
Presenter: Kendra Little

Session 07 (DBA) – Start time 18:00 GMT on March 15
SQL Server Performance
Presenter: Isabel de la Barra

Session 08 (Dev) – Start time 19:00 GMT on March 15
T-SQL Code Sins: The Worst Things We Do to Code and Why
Presenter: Jen McCown (Hey look, it’s me!)

Session 09 (BI) – Start time 20:00 GMT on March 15
Multidimensional Thinking
Presenter: Stacia Misner

Session 10 (DBA) – Start time 21:00 GMT on March 15
Bad Plan! Sit!
Presenter: Gail Shaw

Session 11 (DBA) – Start time 22:00 GMT on March 15
Indexes and Execution Plans
Presenter: Kim Tessereau

Session 12 (BI) – Start time 23:00 GMT on March 15
Many-to-Many Dimensions – ETL to Cube
Presenters: Lisa Phillip

 March 16, 2011

 Session 13 (BI) – Start time: 12:00 GMT on March 16
Reporting Services 201: the Next Level
Presenter: Jes Borland

Session 14 (DBA): Start time 13:00 GMT on March 16
Replication, Log Shipping and Mirroring: Oh My!
Presenter: Wendy Pastrick

Session 15 (Dev) – Start time 14:00 GMT on March16
Entity Framework: Not as Evil as You May Think
Presenter: Julie Lerman

Session 16 (DBA) – Start time 15:00 GMT on March 16
All about SQL Server Memory Settings for DBAs
Presenter: Vyshnavi Thota

Session 17 (BI) – Start time 16:00 GMT on March 16
Tips & Tricks for Dynamic Reporting Services Reports
Presenter: Pam Shaw

Session 18 (Dev) – Start time 17:00 GMT on March 16
T-SQL Awesomeness: 3 Ways to Write Cool SQL
Presenter: Audrey Hammonds

Session 19 (BI) – Start time 18:00 GMT on March 16
Intelligent ETL with SQL Server
Presenter: Jyoti Gupta

Session 20 (BI) – Start time 19:00 GMT on March 16
Clever Queries: Crafting MDX Queries to get the Most out of SSRS
Presenter: Erika Bakse

Session 21 (Dev) – Start time 20:00 GMT on March 16
Five Physical Database Design Blunders and How to Avoid Them
Presenter: Karen Lopez

Session 22 (BI) – Start time 21:00 GMT on March 16
What You Don’t Know about SSRS 2008R2
Presenter: Kathi Kellenberger

Session 23 (DBA) – Start time 22:00 GMT on March 16
Index Internals for Mere Mortals
Presenter: Michelle Ufford

Session 24 (DBA) – Start time 23:00 GMT on March 16
TwitterData on Azure (end-to-end demo) – How We Did It
Presenter: Lynn Langit

Happy days,

Jen McCown

http://www.MidnightDBA.com/Jen