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
