Thomas Kejser's Database Blog

Happy new year everyone. First of all, thanks for staying in touch and reading my site. According to Google Analytics, I have over 27K unique page hits and there is a steady traffic of over 50 hits/day of “not search engine crawler and not spam” traffic. Considering that I have done very little to expand my reach (with the exception of picking the inevitable fight with Dan Lindstedt in the Kimball forums) I think that is pretty nice. Peak traffic is now 500 page views in a single day for the most popular post (“Boosting INSERT speed Generating Scalable Keys” in case you were wondering)

The structure of my writing is beginning to converge on a well defined set of categories. One may even argue that I am becoming a grumpy old man with set opinions. Because of this, I have updated the taxonomy of the site to make it easier for you to track the stuff you are interested in.

Basically, it works like this (and I will keep it “insert only” after this – promise)

• Engines: Advise and observations specific to one database engines (and I use that term broadly).
• Grade of the Steel: My performance testing experiments and crazy tuning, where I try to squeeze out the max throughput of large systems.
• Modeling: Everything related to modeling, sub grouped by the type of modeling. There will be engine specific things in here too, but I will strive for it to be stuff everyone can benefit from reading. Readers who are only interested in my data warehouse series should RSS subscribe here.
• Musings: My personal views on the world, where I get to practice my writing and exhibit my freedom of speech. If you like my content, but hate my guts (or if you just are easily offended) you may want to skip past these posts.
• Utilities: Small utilities I sometimes create (under GPL) and a bag of tricks that did not fit in anywhere else.

Note that there is a many-to-many relation between posts and categories: posts can appear in more than one category at a time. Of course, you can still subscribe to the “master level” directly at blog.kejser.org/feed where all posts will appear to track it all.

The tag cloud will evolve over time and helps the search engines categorize what is going on here. It also has the narcissistic effect of showing me a “mental map” of what I am most interested in.

I will be going OOF until end of January. After this, the plan is to pick up the Data Warehouse series again.

Again, thanks to everyone who is reading and commenting. Here’s a toast to yet another year of arguments and strong opinions…

Cheers!

Thomas

This week, I welcome friend, coffee connoisseur, large cube runner and coder Pete Adshead to the blogosphere.

Pete is blogging at: http://peteadshead.wordpress.com/.  His first blog is about managing SSAS through AMO – and the “interesting” coding pattern you have to adopt.

Have fun reading

You can now access my blog at http://blog.kejser.org. Please point permalinks to that domain.

Today, I was asked a good question: "What material do you read to stay up to date on SQL Server, computers and data modeling" (thanks Chris). Let me try to answer this:

Twitter

I am not a big fan of Twitter – I find the noise to signal ratio horrible. But I just don’t need to stay up to date with the bleeding edge of the chatter on the net

Blogs

I AM a big fan of following individuals that I respect for their opinions. I read blogs a lot. It is my observation that when people take the time to sit down and write a longer text (i.e. a blog, not a Tweet) , their ideas are often expressed with more clarity. I highly recommend the links to the right. Note that only 10 are shown at a time, so they will occasionally change.

I also track a variety of other blog sources that I may not always keep up to date on this web page – so if you are not on my list here, don’t take that the wrong way. If you are interested in sharing good reading material with me, then feel free to add me for "following" in Google Reader (which is my blog aggregator). My Gmail account is thomas<at>kejser.org.

Some major blogs that give me daily ideas on the subjects I blog about myself:

• http://www.gamasutra.com/ – Great blog about making computer games. Highly relevant to learn about scalable designs
• http://dbmsmusings.blogspot.com/ – Professor Daniel Abadi (of Hadapt/HadoopDB) thoughts on databases
• http://highscalability.com/ – News on scalable designs
• https://blogs.oracle.com/optimizer/ – information on Oracle’s optimizer
• http://blogs.msdn.com/b/conor_cunningham_msft/ – Information about SQL Servers optimizer

Books, Articles and whitepapers

I have a rather extensive library at home, though I am currently in the process of buying Kindle editions of most books on my shelves.

Here is a list of books I would consider the “bare minimum” to acquaint yourself with as a DBA or architect to be on the Microsoft platform.

Basics of computers and databases:

Before you can work with computers, operating systems and databases, I think it is crucial to understand how they are built.

• Mark Russinovich: “Windows Internals” – THE reference on how windows works
• Donald Knuth: “The Art of Computer Programming” (AKA: TAO)– THE reference on algorithms and optimizing code. You will not have to read this from one end to the other, but browse though and try to understand the key messages Knuth has to tell you.
• Andrew S. Tannenbaum: “Modern Operating System” and “Structured Computer Organization” – Some of the greatest books on operating system design and behavior ever written. Though I am not in the “micro kernel camp” – I greatly admire Tannenbaum for being such a great educator.
• Kalen Delaney: “SQL Server Internals” – Great reference guide on how SQL Server works
• Ken Henderson: “The Guru’s Guide to SQL Server architecture and Internals” – By the late Ken Henderson, this book is IMHO still the best book ever written about SQL Server. It deals with old versions, but Ken’s technique for learning is simply superb and is just as relevant today as it was back when it was written
• Dan Tow: “SQL Tuning” – A surprisingly unknown book in the SQL Server community. Great resource on how to find the best query plan. I attended Dan’s course once, and this guy knows what he is talking about.
• I would recommend reading about the latest servers from the big hardware vendors: HP, Dell, IBM, Fujitsu etc. Try to understand the design tradeoffs they make
• Intel’s and AMD’s chip roadmaps are crucial to understand too (and ARM if you are into that)
• Follow the storage vendors websites, and try to track the NAND revolution as it is happening
• Read the latest TPC full disclosure reports for your favourite database engine and hardware vendor. Try to understand the thinking behind the configuration of the database and hardware.

Becoming a great developer or architect:

My personal belief is that if you don’t have a full overview of everything from the storage all the way up the stack to organization of code modules and networking (you can skip the GUI), you are not yet ready to become an architect. Thus, the first step is to learn how to code and tune well, and get familiar with the intricate details of systems. There is really no shortcut here. But once you know how to code, how to tune and how to build a good data model, architecture discussion become trivial to you.

• Steve McConnel: “Code Complete” – A really good resource on writing good code and remaining passionate about your job
• Andrew Hunt & Dave Thomas: “The Pragmatic Programmer” – A great view on the mindset required to become a good programmer/architect
• Frederick P. Brooks: “The Mythical Man Month” – wise words about organising large software projects. As relevant today as it was back then, we didn’t learn a thing
• Christopher Duncan: “The Career Programmer – Guerilla tactics for an imperfect world” – I think this one fits the world I observe better than Steve McConnel’s: “Rapid Development”. But both are really good. Duncan is probably a better primer for the programmer to be, Steve has a more mature outlook.

I have not yet found really good resources on data modeling. Which is one of the reasons I started this blog.