|
|
|
|
Browse by Tags
All Tags » Writing (RSS)
-
In this last kind of “creative” chapter, I will look at some of the ways you implement common problems in your relational database, and some of the ways you probably shouldn’t. The “should” sections will deal with: Uniqueness – Beyond the simple uniqueness Read More...
|
-
As the book progresses, I find myself veering from the original stated outline quite a bit, because as I teach about this more (and I am teaching a daylong db design class in August at http://www.sqlsolstice.com/ … shameless plug, but it is on topic :) Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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. Read More...
|
-
I guess eventually I had to admit that performance matters. Whenever I speak, and in all of my books, I try to stress over and over that performance is NOT the only thing. The fact is all too much time is spent trying to make database applications run Read More...
|
-
A project that I worked on a while back is finally coming to fruition, and it is one of the coolest around. Usually when I see a book that has 5+ authors, I am a bit concerned about quality. In this case however, there are 53 authors and even Read More...
|
-
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, Read More...
|
-
I have gotten a few more reviews in, and interestingly I appreciate the negative ones almost as much as the positive ones. I prefer the negative ones that have decent star ratings better… but what are you going to do. The most recent review was critical Read More...
|
-
When I wrote the 2005 book, I promised that I would take the time to respond to reviews as much as possible. From the good ones if I didn’t really believe that the person read the book (there were a few I have seen, but not too many people tend to write Read More...
|
|
|
|
|
|