I’m Being Replaced by a Normalization Nut …Okay, a Crazy Talking @TheSmilingDBA

Aug 31, 2011   //   by Karen Lopez   //   Data, Data Modeling, Database, Speaking  //  No Comments

Due to some last minute travel plans, I have to fly during one of the days of 24 Hours of PASS (24HOP), so I won’t be able to do my teaser presentation scheduled for the PASS Summit.  I really hate when I have to step back from doing a presentation I’ve committed to doing, but it turns out that I couldn’t get to where I needed to be.  Time, location and distance worked against me.  The good news is that 24HOP has found a perfect replacement with Thomas LeBlanc,  MCDBA & MCITP (@TheSmilingDBA | blog ).  I know Smiling DBA from Twitter and I’m looking forward to seeing this excellent presentation at some point:

Standard Operating Procedure for Normalized Database Design

Join Database Normalization nut Thomas LeBlanc for a review of a Standard Operating Procedure used among DBAs as a template for database normalization. This session will touch on conceptual design, naming conventions, check list for creating a table and lookup table structure. These points are a preview of the PASS Summit 2011 talk 3rd Normal Form: That’s Crazy Talk! This discussion is based on 21+ years of developing databases for application developers. This session will include identity columns for primary keys and the need for a unique constraint on transaction and lookup tables. The creation of a SOP for DBAs can help developers follow a standard and DBAs code review the database design.

See, he even has a bit o’ the snark that I do in my abstracts.  A perfect session to fill in for my lapse in flight scheduling.  There should be a law that says that any Normalization presentation must be done with snark, humour, and a bit of craziness, don’t you think?  You should run right over and register for his session, plus all the others.  There’s lots to offer in these free, online presentations: ETL, BI, Data, DW, PowerShell, SANs…all things data for 24 hours over two days.

Look at all this goodness:

September 7, 2011

Session 01 – Start time 12:00 GMT on Sept 7
Introduction to Data Mining in SQL Server Analysis Services
Presenter: Brian Knight

Session 02 – Start time 13:00 GMT on Sept 7
SAN Basics for DBAs
Presenter: Brent Ozar

Session 03 – Start time 14:00 GMT on Sept 7
Diving Into Extended Events
Presenter: Jonathan Kehayias

Session 04 – Start time 15:00 GMT on Sept 7
Exploring PowerPivot for Excel in SQL Server Project "Denali"
Presenter: Peter Myers

Session 05 – Start time 16:00 GMT on Sept 7
Why PowerShell?
Presenter: Aaron Nelson

Session 06 – Start time 17:00 GMT on Sept 7
SSIS in the Enterprise
Presenter: Andy Leonard

Session 07 – Start time 18:00 GMT on Sept 7
Extracting Execution Plans
Presenter: Gail Shaw

Session 08 – Start time 19:00 GMT on Sept 7
Multi-Site Failover Clustering with SQL Server 2008, 2008 R2, and Denali
Presenter: Allan Hirt

Session 09 – Start time 20:00 GMT on Sept 7
So How Does the BI Workload Impact the DB Engine?
Presenter: Denny Cherry, Stacia Misner

Session 10 – Start time 21:00 GMT on Sept 7
Hardware 301: Diving Deeper into Database Hardware
Presenter: Glenn Berry

Session 11 – Start time 22:00 GMT on Sept 7
Secrets of the SQLOS – Leveraging Microsoft SQL Server Internal Operating System for Improved Scalability and Performance
Presenter: Maciej Pilecki

Session 12 – Start time 23:00 GMT on Sept 7
All About Execution Plans: Reading Execution Plans
Presenters: Grant Fritchey

September 8, 2011

Session 13 – Start time 12:00 GMT on Sept 8
Zero to Cube – Fast Track to SSAS Development
Presenter: Adam Jorgensen

Session 14 – Start time 13:00 GMT on Sept 8
Fixing Queries with Uniqueness
Presenter: Rob Farley

Session 15 – Start time 14:00 GMT on Sept 8
Disaster Recovery Is Not Just About Technology
Presenter: Edwin Sarmiento

Session 16 – Start time 15:00 GMT on Sept 8
Reporting Services 201: From Basic to WOW!
Presenter: Jes Schultz Borland

Session 17 – Start time 16:00 GMT on Sept 8
Standard Operating Procedure for Normalized Database Design
Presenter: Thomas LeBlanc

Session 18 – Start time 17:00 GMT on Sept 8
Baseline Basics or: Who Broke the Database
Presenter: Adam Machanic

Session 19 – Start time 18:00 GMT on Sept 8
T-SQL Awesomeness – 3 Ways to Write Cool SQL
Presenter: Audrey Hammonds

Session 20 – Start time 19:00 GMT on Sept 8
Code-First Development with the Entity Framework
Presenter: Don Kiely

Session 21 – Start time 20:00 GMT on Sept 8
Advanced Reporting Services
Presenter: Simon Sabin

Session 22 – Start time 21:00 GMT on Sept 8
Important Trace Flags That Every DBA Should Know
Presenter: Victor Isakov

Session 23 – Start time 22:00 GMT on Sept 8
Policy-Based Management in a Nutshell
Presenter: Jorge Segarra


Session 24 – Start time 23:00 GMT on Sept 8
Visual Report Design: Bringing Sexy Back
Presenter: Paul Turley

My presentation was supposed to be 5 (NEW) Database Design Blunders.  I’ll be giving a more extended and even snarkier spotlight version of that at the PASS Summit in October, so I hope to see you there.  And if you have already registered for my session at 24HOP, go ahead and be part of the new one.  You won’t regret it.

Leave a comment

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1