THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Normalization   (RSS)
  • Upcoming Database Design Pre-Cons

    In July and October, I will be doing my "How To Design a Relational Database" full day conference in two places. First on July 26 for the East Iowa SQL Saturday, and then for the big daddy SQLPASS Summit in Charlotte, NC on October 14. You can see the entire abstract here on the SQL PASS site. It is essentially the same concept as last ...
    Posted to Louis Davidson (Weblog) by drsql on June 13, 2013
  • PASS Precon Countdown… See some of you Monday, and others on Tuesday Night

    As I finish up the plans for Monday’s database design precon, I am getting pretty excited for the day. This is the third time I have done this precon, and where the base slides are very similar, I have a few new twists in mind. One of my big ideas for my Database Design Workshop precon has always been to give people to do some design. So I am even ...
    Posted to Louis Davidson (Weblog) by drsql on November 2, 2012
  • Normalization and How to Know When You Are Done… The short version…

    A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in 2 pages or less, describe the process of normalization and help you to know when you have ...
    Posted to Louis Davidson (Weblog) by drsql on May 29, 2011
  • Will SQL Azure make Normalization popular again?

    Normalization should be very popular and widespread. Unfortunately I can say that the 99% of developers that work with database (and thus design the database schema) don’t know it. Even worse they don’t even realize that normalization is a key point in application development. AFAIK developers and project managers don’t care too much of ...
    Posted to Davide Mauri (Weblog) by manowar on August 30, 2010
  • Denormalize with consciousness (aka Constraint are not an option)

    Today I had to help a customer to make their upgraded invoicing system to work correctly…and as quite often, the source of the problem was a bad denormalization. From now on, each time I can do it without revelaing too much of the customer, I’ll try to write a post so to it will be clear to anyone (developers in particular) what are the dangers ...
    Posted to Davide Mauri (Weblog) by manowar on August 2, 2010
  • The second pillar - Normal

    The first pillar was easy, since no reasonable person is going to argue that having a design that is not coherent is desirable. No matter what the type of system, any design that isn’t easy to understand is likely to be a bad design (obvious caveats are that it must be understandable to other people of a given level of intelligence in the given ...
    Posted to Louis Davidson (Weblog) by drsql on March 1, 2009
  • Denormalize for Performance?

    Conventional wisdom says to “normalize to 3rd normal form then denormalize for performance.” Poppycock! I say for an OLTP operational database (not a reporting or BI database), a well normalized design will outperform a denormalized design for three good reasons: 1)      If the denormalization duplicates data, then the ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on October 3, 2008
  • Another Reason to Normalize

    Database can be measured by six properties – four determined by the design; Usability, Integrity, Performance/Scalability, and Extensibility; and two being more a function of implementation than design; Availability and Security. Of these six factors, I’d argue that in the long run, extensibility is the one that is more expensive to repair. All ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on October 16, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement