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   (RSS)
Showing page 5 of 8 (79 total posts)
  • Chapters Two, Three, and Four

    I am trying to blog all of the chapters of the book, but due to deadlines and a lot of shuffling about, I never got around it for these three chapters, two of which I have added since I wrote the original table of contents. All of these contain mostly material from previous editions of the book, updated a good amount, but nothing tremendously ...
    Posted to Louis Davidson (Weblog) by drsql on February 22, 2011
  • Adventures in the Land of CloudDB/NoSQL/NoAcid

    Cloud, Bunny, or CloudBunny? Last year, some of my friends from Quest Software attended Hadoop World in New York. In 2009, I never would've guessed that Quest would be there with products, community initiatives, as a major sponsor and with presenters? There were just under 1,000 attendees who weren’t the typical devheads and geekasaurs ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2011
  • 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
  • BNF – how to read syntax?

    A few days ago I read post of Jen McCown (blog) about her idea of blogging about random articles from Books Online. I think this is a great idea, even if Jen says that it’s not exciting or sexy. I noticed that many of the questions that appear on forums and other media arise from pure fact that people asking questions didn’t bother to read and ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on December 7, 2010
  • 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
  • Setting reporting database–what happens behind the scenes

    When you install reporting server, you have in general two options available – either you install the reporting server and configure its database at the same time, or install just reporting service and point it to an existing database later. We had recently opportunity to configure server to point to existing reporting database. We encountered a ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on November 28, 2010
  • Design Book– First Section (Skills)

    One of the main things that I haven’t always loved about the previous books is that it wasn’t a perfect reference book. I focused on having a flow throughout the book that, not unlike a school class, started at the beginning and finished at the end. Interspersed were semi-cohesive examples that followed along in an entire chapter (once even for ...
    Posted to Louis Davidson (Weblog) by drsql on November 22, 2010
  • Design Book–Top level outline

    The more I teach sessions about database design, the more I realize that two things are true. First, most people don’t dig the normalization stuff as much as I do (some do), and second, people really need the normalization stuff more than they think. The really hard part is how to flavor the medicine just enough such that it will be read by more ...
    Posted to Louis Davidson (Weblog) by drsql on November 16, 2010
  • PASS BOF Lunch – SQL Server and NoSQL alternatives

    Beside my BI workshop on Friday, this year at PASS Summit I’ll also contribute by participating at the Birth Of Feather Lunch on a very hot topic: “SQL Server and the NoSQL Alternatives” I’ve been watching closely the NoSQL movement right from the beginning (as soon as it started to grow also in Italy, so from January 2010), since I simply love ...
    Posted to Davide Mauri (Weblog) by manowar on October 13, 2010
  • DEFAULT constraints and sp_bindefault

    When you deal with old databases, with origins somewhere around second half of nineteen nineties, you can expect all kinds of oddities, like funny naming conventions, (lack of) referential integrity, absence of clustered indexes and things like rules and defaults created separately from tables DDL. I just happen to work with such database. I see ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 20, 2010
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement