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 » Development   (RSS)
Showing page 2 of 2 (15 total posts)
  • 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
  • Big League Technical Staff

    So I was blissfully reading the twitter feed when @Tim_Mitchell tweeting the following article Consultants are pros, while corporate IT staff are minor leaguers by Erik Eckel, that for some reason seems to exist to feed the need that IT staffers have to despise consultants who come in and are listened to, often when there are hyper qualified IT ...
    Posted to Louis Davidson (Weblog) by drsql on April 12, 2011
  • What is a physical database?

    A bit of terminology that gets beaten to death is that of the “physical” database.  I would think most every DBA uses this term (I do), but…to mean what?  I think there are two common utilizations: The layer of tables, constraints, indexes, etc used to store data The actual on-disk structures. Frankly, until 3 years ago, I ...
    Posted to Louis Davidson (Weblog) by drsql on June 11, 2009
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
  • Data correctness during the development process

    During all phases of development, particularly when building a completely new system, it is very common to have a need for data to test with.  As important as this is for a UI system, the need is doubled is when you are working on a reporting system.  While Everyone knows that the process of getting test data can be a fickle ...
    Posted to Louis Davidson (Weblog) by drsql on October 9, 2006
Privacy Statement