Several years ago Microsoft and other went out of their way to promote education. They talked about a need for tech workers and how they could not find the employees...

I got my opinion of certification when I once worked with a newly certified CCNA. We were work on a router when the CCNA guys says "wait while I hook...

The easiest way with with a calendar table. See....

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Simi

I worked on a problem just like this yesterday.

Use CTE to create 3 queries. 2 to sum for each store. One to get the a list of weeks. Then join...

You might consider a service like box.net where you can upload the file and they can download it. They have a limited free memebership that should work in this situatuion....

If you do not require the in a table just

exec sp_MSforeachdb 'exec sp_helpdb ''?'''

I think most DBA's are of the accidental variety rather then the "I want to be a DBA when I grow up" variety.

Being a DBA or programming in general, is...

There are toasters, then there are better mouse traps.

7Zip format is a better mouse trap. I have to compress lots of PDF files and it is amazing compared to zip....

I think the best book for any newbie is "Murach's SQL Server 2005 for developers". It stays on my desktop. Easy to read, straight forward examples.

Simi

An old supervisor of mine used to say "it is better to lock them down in the beginning, because you can always get them more permissions but it becomes nearly...