I’m Speaking at #SQLSat104 Colorado Springs 7 January 2012
I’ll be leading a discussion on Database Design Contentious Issues on 7 January in Colorado Springs. This event is FREE, and there’s a $10 charge if you’d like to have lunch. A full day of learning and networking all provided due to the support of vendors in the SQL Server community. How awesome is that?
Database Design Contentious Issues
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Session Level: Intermediate
This session is part debate, part therapy and part rant. It’s my most popular presentation and I’d love to see you there. This presentation also involves physical activity and hands on stuff. A perfect afternoon slot for this, too.
Women in Technology
I’m also participating in the Women in Technology table at lunch with Meredith Ryan-Smith (Web | Twitter), Rebecca Mitchell (Web | Twitter) and Thomas LaRock (Web | Twitter).
More Fun Than Should be Legal
There’s a whole lot of great stuff packed into this SQLSaturday. Did you know that there will be professional resume writers there to take a look at your resume and give you feedback? Or that there will be laser tag, bowling and miniature golf? There’s even a #SQLSki event planned.
On the Friday before, there are even 3 pre-cons scheduled:
1. “Scaling SQL Server” (Glenn Berry)
2. “Data Warehouse Dimensional Design and Architecture Planning” (Erik Veerman)
3. “What’s In Your Utility Belt?” (Chris Shaw and TJay Belt)
These cost only $100 — a great deal for a day of training.
The Schedule
| Track | Starts | Session Title | Speaker |
| BI | 8:30 AM | Introduction to Data Warehousing | Marc Beacom |
| BI | 8:30 AM | Kama Sutra of SSIS: A guide to loving ETL | Bill Fellows |
| BI | 9:30 AM | *GASP* Real-time user defined sets in SSAS | Josh Fennessy |
| BI | 9:30 AM | Dimenional Modeling 101 | Thomas LeBlanc |
| BI | 11:00 AM | ETL as MDM | Michael Sexton |
| BI | 11:00 AM | Using Columnstore Indexes in SQL Server 2012 | Carlos Bossy |
| BI | 1:30 PM | SQL Report Builder for Business Intelligence | David Eichner |
| BI | 1:30 PM | Predictive Analytics – You Can, Too! | Troy Ketsdever |
| BI | 2:30 PM | Reporting DBs behind Virtual IP’s | John Halunen |
| BI | 2:30 PM | Devs are from Mars, Report Servers are from Venus | Doug Lane |
| BI | 4:00 PM | Eating the Elephant: SQL Server Table Partitioning | Michael Fal |
| BI | 4:00 PM | PowerPivot for Excel | William E Pearson III |
| DBA | 8:30 AM | The Periodic Table of Dynamic Management Objects | Tim Ford |
| DBA | 9:30 AM | 7 Ways to Fix Bad Parameter Sniffing | Grant Fritchey |
| DBA | 11:00 AM | AlwaysOn – Finally, A usable ‘mirror’! | Jim Murphy |
| DBA | 1:30 PM | Discovering the Plan Cache | Jason Strate |
| DBA | 2:30 PM | Performance Issue Archetypes | Joe Sack |
| DBA | 4:00 PM | Database Design Contentious Issues | Karen Lopez |
| DBA / DEV | 8:30 AM | To the Cloud and Back Again! | Ted Malone |
| DBA / DEV | 8:30 AM | PowerShell for the Reluctant DBA / Developer | Jason Horner |
| DBA / DEV | 9:30 AM | Development Mise en Place | Keith Tate |
| DBA / DEV | 9:30 AM | SQL Azure: Future-Proofing Your SQL Career | Chris Randall |
| DBA / DEV | 11:00 AM | Your own Private Cloud for SQL | Ben DeBow |
| DBA / DEV | 11:00 AM | Edge Case Testing for the Database Professional | Vicky Harp |
| DBA / DEV | 1:30 PM | Backup Basics – Know your options | Meredith Ryan-Smith |
| DBA / DEV | 1:30 PM | PBM and you! | Tom Norman |
| DBA / DEV | 2:30 PM | Choose Your Own Adventure: Performance Tuning | Thomas LaRock |
| DBA / DEV | 2:30 PM | 10 Things That Every DBA Should Know! | John Morehouse |
| DBA / DEV | 4:00 PM | PowerShell and VBScript for the DBA | Mark Halstead |
| DBA / DEV | 4:00 PM | But it worked great in Dev! Perfomance for Devs | Randy Knight |
Isn’t that a great line up of speakers and content? Why wouldn’t you want to be there?
Join us for a fun day of socializing, networking and fun.
Canada’s Smartest and Greenest IT Awards – 17 Nov – Toronto
I had the honour of judging the Canada’s Smarted and Canada’s Greenest IT awards along with James Alexander, CEO of the Quest for Canada’s Smartest IT (@JamesFAlexander) and Shirley Blayney, General Business Solutions Manager at IBM. There were some fabulous nominations. I was happy to see how Canadian organizations are providing advanced business solutions while taking care of the planet.
What are the awards?
The Quest for Canada’s Smartest IT is a competition that recognizes Canadian companies using technology to help their business, the environment and their communities. 2011 marks the second year of our wildly successful competition.
There are three categories of awards which you are eligible to apply for:
- Smartest IT rewards companies using IT in innovative ways to help their business and/or their community.
- Greenest IT recognizes companies using technology to help the environment, enhance sustainability, or demonstrate social responsibility.
- Wow Story is a wild card award that honours the best “story” that we hear over the course of the nominations process. We encourage you to tell us your story today – what is business-as-usual to you, to your peers may well be an eye-opening way of using IT.
The awards ceremony will be held Thursday, 17 November in Toronto. I will be presenting the Canada’s Smartest IT Award.
You can register now and participate in celebrating Smart IT/Green IT at no charge. There is a door charge if you can’t register in advance.
Handouts From My DAMA Speaking Tour
I had a fabulous time meeting DAMA Members in the US Midwest over the last couple of weeks. I was worried most about making all these flights, but they all worked out well. These DAMA Speaking Tours are something I look forward to every year. If you are interested in booking one, contact chapters in your general area and propose some dates.
Join Me & Panel of Data Modeling Experts on BI and Data Governance – 16 Nov – Noon EST

I’m moderating a panel on BI, Data Governance and Data Modeling using Embarcadero ER/Studio on 16 November 2011, at noon EST.
Panelists include
- Kevin Phelps – Data Architect, American Century Investments, Inc.,
- Chris Bradley, Business Consulting Director, Information Processing Limited
- Jason Tiret – Director of Modeling and Architecture Solutions, Embarcadero Technologies
In this webinar, you’ll learn how to:
- Increase visibility and buy-in with business users
- Ensure smooth compliance with changing data privacy regulations
- Enable data stewards to meet requirements strategically
What makes this even more interesting is that audience members, like you, will have a chance to submit questions beforehand and during the event.
Details of the event:
Wednesday, November 16, 2011
9 a.m. Pacific, noon Eastern and 5 p.m. in the UK
When you register you’ll be asked to submit your questions. Please do so. We love having questions from YOU!
I’m deeming the hashtag for this event to be #DMExperts I will try to take Tweeted questions, too.
Speaking: #SQLSat96 Washington, DC …well… Chevy Chase, MD 5 Nov
I’ll be presenting Model Driven Database Design on Saturday, 5 November at the SQL Saturday Washington DC. Which is being held in Chevy Chase, Maryland. Yes, I know this is the greater DC area. Last year it was held in Reston, Virginia. But these data things drive data architects crazy. That’s why you really don’t want to live with a data architect. Ever.
Anyway, I’ll be presenting a brand new presentation that covers:
Model-Driven Database Design
Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Finally, 10 tips for making model-driven database development successful in your organization’s culture and environment.
Session Level: Beginner
Karen Lopez
![]()
Karen López is Sr. Project Manager and Architect at InfoAdvisors, Inc. Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com.
I’m up against some fairly big name speakers, so I’m really hoping to see you in my session. Both of us can have a great time talking about data models. See you there.

Speaking: DAMA Day Nebraska (Omaha) 3 November – Data Modeling Contentious Issues
The final stop on my DAMA speaking tour is DAMA Nebraska for their DAMA Day.
Data Modeling Contentious Issues
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced data modeling issues, such as:
- Party/party role
- Natural vs. surrogate keys
- Class Models vs. Data Models
- SOAs, Ontologies, ESBs, New TLAs and Shoe Strings
- What is Logical? What is Physical? Why Do We Care?
- Politics vs. Customer Satisfaction
Participants in this session will be presented with an issue along with a range of responses or possible solutions. Participants will vote on their preferred response, then the group as a whole will discuss the results, along with the merits of each possible response. If the specific issue has been discussed in other presentations, a summary of the responses of the other groups will be presented. The goal of this workshop is to help practitioners identify potential points of conflict in data modeling, as well as alternative approaches to resolving the issues.
This DAMA Day is sponsored by Embarcadero and they will be making a presentation as well. Registration is requested.
Subscribe via E-mail
Recent Comments
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
- Joey D'Antoni on Strutting: We all Know When You are Doing It. So Stop.
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
- Thomas LaRock on Strutting: We all Know When You are Doing It. So Stop.
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
Recent Posts
Downloads
- EDW 2013 Karen Lopez Get Blogging
- Karen Lopez presentation DAMA PS 2012
- Data Modeling Contentious Issues - DAMA Nebraska
- Karen Lopez - 10 Physical Blunders - DAMA
- Career Success In Data Profession - DAMA
- The Straw Poll
- You've Just Inherited a Data Model CheckList
- KarenLopez - 5 Physical Blunders - 24HOP-2011
- Handouts for OEMUG / CA Global Modeling User Group Why Be Normal Webcast
- Handouts Database Design Contentious Issues - New York 2010
- Handouts Database Design Contentious Issues - DC 2010
Archive
- May 2013 (5)
- April 2013 (5)
- March 2013 (4)
- February 2013 (7)
- January 2013 (12)
- December 2012 (2)
- November 2012 (3)
- October 2012 (3)
- September 2012 (13)
- August 2012 (5)
- July 2012 (17)
- June 2012 (2)
- May 2012 (4)
- April 2012 (4)
- March 2012 (8)
- February 2012 (11)
- January 2012 (3)
- December 2011 (10)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (9)
- July 2011 (5)
- June 2011 (5)
- May 2011 (5)
- April 2011 (9)
- March 2011 (4)
- February 2011 (9)
- January 2011 (8)
- December 2010 (15)
- November 2010 (27)
- September 2010 (2)
- August 2010 (1)
- July 2010 (4)






