Great Article.  It is interesting to note that this article came out on the 1 year anniversary of Chris's Article - Worst Practice - Not Qualifying Objects with the Owner.

hmmmm "Define Query"  Multiple Select statements joined by Union clauses are (is) still 1 query.  A query is a command that lets you interact with the DBMS. 

SELECT * FROM A...

This is a known problem with taskpad.  Change the view to detail, then taskpad again and it should be better.  Hopefully a fix for this will be in SP4

You maywant to consider using the Microsoft Data application block.  http://support.microsoft.com/default.aspx?scid=kb;en-us;829028  This way you don't need to worry about how to format and use datareaders, sql connection objects etc....

In case you can't use the sqlcrack program (I believe you must be sysadmin to run this software) you may need to think about another method.  Do you have access...

One of our test servers has 2 instances.  One is installed as a case sensitive instance to conform with a vendor's application, the other is a default install.

I am new to Data Warehousing myself, so I am just quoting from Ralph Kimball "The Data Warehouse Toolkit"

"Designers are often tempted to store to-date columns in fact tables.  Thet...

logon on to https://partnering.one.microsoft.com/Authenticate/login.aspx?ReturnUrl=https%3a%2f%2fpartnering.one.microsoft.com%2fmcp%2fDefault.aspx

If you have never signed on before you will need a passport id and your MCP id number.

I know for a fact that my MCDBA contributed to 2 different jobs. I didn't take any courses, Just experience, reading books, learning from various web...

I'm just guessing, but try to create the database first, then restore on top of this existing database. 

See http://www.llblgen.com/defaultgeneric.aspx.  This tool is really nifty if you are builing a .net project.

I too read the Database Daily whenever it comes out.  I often find useful of interesting tidbits that I might otherwise have missed.  Good work.

Just a thought in case you were planning to use sa.  You may want to reconsider this.  The sa user should never be used within an application.  A specific id...

See http://support.microsoft.com/kb/q100139/ if you need clarification between eliminating redundant data and eliminating repeating groups . They are not the same thing. This was a good question to make us remember (or check...

I only have 2 at home - an 2.8 GHz Dell running XP upstairs and an old Celeron 466 running Windows 98 in the basement.  The two machines are connected with...