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 » Database design » Best Practices   (RSS)
Showing page 1 of 2 (18 total posts)
  • Now Playing on SSWUG TV!

    Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the ...
    Posted to Kevin Kline (Weblog) by KKline on September 10, 2013
  • Database Trends & Applications column: Database Benchmarking from A to Z

    Have you heard of the monthly print and web magazine Database Trends & Applications (DBTA)? Did you know I'm the regular columnist covering SQL Server?  For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database ...
    Posted to Kevin Kline (Weblog) by KKline on July 24, 2013
  • My Last "Catch-Up" Post for 2010 Content

    I did a lot of writing in 2010. Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active. So here are a few more posts from my blog, put on-line during the months of November and December 2010, that I didn't get posted here on SQLBlog.com: 1. It's Time to ...
    Posted to Kevin Kline (Weblog) by KKline on December 31, 2010
  • See You in St Louis, and then London, Amsterdam, Copenhagen, Stockholm, and York, UK

    Good grief, there's a lot of travel in my future. <sigh ... deep breath> It'll be exhausting and it'll be hard to lose so much time with the family. But if I'm able to avoid travel mishaps, it'll be fun.  Meet Me In St. Louis I'll be speaking in St. Louis, MO on Tuesday, September 14th for their mid-day meeting. The details, ...
    Posted to Kevin Kline (Weblog) by KKline on September 7, 2010
  • It's the Atlanta Attendance Contest!

    I'm speaking tonight on Top 10 Mistakes DBAs Make at the Atlanta SQL Server User Group meeting in Alpharetta, GA.  You can find all of the details here.The Best Dang Design Book for SQL Server Professionals - EVER!I thought I'd liven things up a bit with a little contest.  The rules are simple: A. If you don't follow me on ...
    Posted to Kevin Kline (Weblog) by KKline on July 12, 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
  • 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
  • Checkpoint – Four pillars down, Three to Go

    With the previous post on the fourth pillar, I have reached the “end” of the design posts.  To review, these were: Coherent – cohesive, comprehendible, standards based, names/datatypes all make sense, needs little documentation Normal – normalized as much as possible without harming usability/performance (based on testing) ...
    Posted to Louis Davidson (Weblog) by drsql on May 14, 2009
  • The fourth pillar – Documented

    This blog probably won’t stir up a hornet’s nest or anything, but I would also expect that it would be the least popular in practice. The person who feels they can disagree with the need for a reasonable amount of documentation is probably nuts. In the first post, I defined documented as “Anything that cannot be gathered from the previous four is ...
    Posted to Louis Davidson (Weblog) by drsql on April 15, 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement