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 » Design   (RSS)
Showing page 2 of 2 (16 total posts)
  • 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
  • Design Book–Dimensional or No Dimensional, that is..the question

    So, it is right there in the title of the book “Relational Database Design” etc (the title is kinda long :)  But as I consider what to cover and, conversely, what not to cover, dimensional design inevitably pops up. So I am considering including it in the book. One thing I try to do is to cover topics to a level where you can start using it ...
    Posted to Louis Davidson (Weblog) by drsql on November 30, 2010
  • Seventh pillar - Encapsulated

    The final numbered post in this version of my “pillar” series of posts ends in the most contestable part of the design/implementation process.  Encapsulation. The concept of encapsulation is not contested (or even contestable by sane programmers in any field of the art of system creation. Every time you use a Windows API call you are ...
    Posted to Louis Davidson (Weblog) by drsql on October 23, 2009
  • Bad habits to kick : choosing the wrong data type

    In my last post in this series, I talked about the assumptions many people make about IDENTITY columns.  In this post, I want to focus on choosing data types.  There are several areas where I see frequent mistakes in data type choice, and I'll mention a few here. Using CHAR / VARCHAR / INT for date / time values Countless times I have ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 12, 2009
  • 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
  • Requirements vs Architecture

    Okay, so on the first look this sounds like the most boring Japanese action movie ever. Requirements is tearing through the village, and Architecture is in the city.  Developers by the horde are trying to code both of these into oblivion…Maybe not.  Clearly I am talking about something a little more exciting…the battle between the forces ...
    Posted to Louis Davidson (Weblog) by drsql on April 12, 2009
Privacy Statement