Wednesday, January 30, 2008

Indexing Basics

This is an excellent read for a beginner just learning about indexing. Here is an excerpt from the article on SQLTeam.Com

Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.

Most developers and DBAs understand that indexes on database tables enable applications and reports to run more efficiently. But, do they really know whether the database system will take advantage of an index to process a particular query or update statement? Does the order of columns specified in the index matter? What is the difference between a clustered index and a non-clustered index? To understand some index concepts, I have found it useful to use some analogies.

Here is a link to the rest of the article - Indexing Basics

Friday, January 25, 2008

How I Code

  1. A good, comfortable pair of noise canceling head phones.
  2. A playlist of ambient or techno music
  3. Proper ergonomics
  4. A beverage depending on the task/time of day (water, Monster Energy, coffee...)
  5. A big flat screen monitor
  6. Inspirational items in my work area such as a plant, pictures, posters

How about you?

The Young DBA

Since I started this blog, almost a year ago now, I haven't been able to wrap my hands around what it is exactly that I want to blog about. First it started as a personal journal with random ramblings, but there are so many of those and besides who wants to read that type of material, not me. Then I went on a nutrition weight loss kick and started writing about that but my interest in subject quickly faded. Then I started blogging about SQL and MS SQL Server. I felt like I had finally found my niche, a topic I could easily write about and enjoy writing about.

I found myself having a hard time coming up with good solid material. There is such a large quantity of information about SQL and Microsoft SQL Server written by people more knowledable than me, how could I ever contribute worthwhile material? Hence the reason for my lack of posts. Just the other day it dawned on me, The Young DBA, write about my mission to further my career and expand my skill set, the challenges I face and the lessons I learn along the way.

Now If I was a student in college or even high school and I was thinking about pursuing a career in IT, more specifically Database Administration and Development, this would be material I would be interested in reading.

Monday, December 17, 2007

Pro SQL Server 2005 Database Design

I've recently purchased "Pro SQL Server 2005 Database Design" by Louis Davidson. I haven't had a whole lot of time to really dig in to this book but from what I read thus far, it seems like an excellent read. Once I finish up with the book I'll post a complete review. The best price I've found online are used books on I'm hoping this book will sharpen my database design skills for an upcoming application re-write project I'm working on.

Google Books Link

Tuesday, April 03, 2007

What I'm Reading

I would highly recommend Itzik Ben-Gan's book Inside Microsoft SQL Server 2005: T-SQL Programming to anyone who wants to build on their TSQL / SQL Server skill set.