Browsing articles tagged with " Normalization"

DMRadio: Modeling What Matters Recording Available

Sep 21, 2012   //   by Karen Lopez   //   Blog, Data, Data Modeling, NoSQL, Speaking  //  1 Comment


You can now download the recording from this past week on Modeling What Matters – Data Modeling Throughout, Beyond the Enterprise.  We had a great time chatting about the state of data modeling in a world of data sharing, standards, business alignment and NoSQL.

A wonderful set of panelists, too.

Registration is required, but you really should be registered on the Information Management website already.  Do it.

Also, at the end of the show I got a shout out for my presentation with Thomas LaRock (@sqlrockstar), Database Design Throwdown: The Blunder Games at ERWorld coming up in October.  You should go register now for that, too. 

Normalization Myth 142…

Jul 10, 2012   //   by Karen Lopez   //   Blog, Data, Data Modeling, Snark, SQL Server  //  No Comments


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.

Normalization Myths: 2 New Blog Posts

Aug 9, 2011   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database  //  No Comments

imageI have a series of blog posts going up on  The introduction went up a few weeks ago and now 2 new rants have been added. Head over there to check them out and leave comments. I love when people leave comments — even if the comments disagree.   One of the things I’ve learned over the years is that performance tuning is something we learn by sharing experiences with others.  It’s not something that one can apply a bunch of formulas and rules to.  So post away.

Normalization Myths that Really Make Me Crazy – Introduction to a Rant

Myth 1 – Normalization: Friend, Foe, or Frenemy The Survey 

Myth 1 – Normalization: Friend or Foe The Slogan




Perhaps what the data profession needs is a series of top-up courses, to be reviewed every couple of years.  Maybe what we need is an intervention to help people understand the why normalization is even a topic in design.  I think this would make for a wonderful lunchtime presentation.  Perhaps your boss could even buy lunch.  This presentation wouldn’t be the how of normalization, but the whys and why nots.  Mastering the normal forms is fairly easy.  Understanding which one to use for a specific solution is the hard part.  The more your teammates understand the whys, the more likely they are to going to support your efforts.

Dataversity: Zombies, Zachman, Mason-Dixon Line and Normalization Rants

Jun 16, 2011   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database, Professional Development  //  No Comments

Two of my posts are now up over on, a portal of all things data for data professionals.

The first, now with images working correctly, is Hiring Data Professionals: Mason Dixon Lines and Zombies in Your Job Postings. In that post I reflect on some of the craziness in job postings I’ve seen over the last few months.


In my most recent post, Normalization Myths that Really Make Me Crazy – Introduction to a Rant, I start a series on normalization myths. I expect this series to provide hours of new content for my Contentious Issues presentation.  In the introduction I talk about why a series and the emotions people feel about normalization.  Please stop by and leave your thoughts there.


I’ll be writing more than a dozen posts for Dataversity this year and I appreciate your reading my posts there as well as those here at InfoAdvisors.

Karen’s List of Irritating Normalization Myths – #EDW11

Apr 4, 2011   //   by Karen Lopez   //   Blog, Speaking  //  5 Comments

imageI’m giving a lightning talk as part of a round of them at Enterprise Data World today at 5PM ET.

The fun part about Lightning Talks is that they get to be full of snark.  This one of my snarkiest.  Think irritation-inspired snark.

Join us for a fun, fast, and chaotic set of 5 minute, auto-advanced presentations.

Also, there is still time to register for my half day seminar on Thursday afternoon.  Use the promotional code DATACHICK to get a rate of only $195 for the full day.


Subscribe via E-mail

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