Great article overall.

I respectfully disagree with this statement, "Bob quickly found himself preferring the SELECT, JOIN, and WHERE syntax over the designer" even as a professional database admin\developer I...

Yes this would be a good enterprise solution. But our business is a non-profit that runs budgets close to the wire so there is no money for cool solutions like...

On a forum like this you should post at the TOP of the article that this is not a free product so people don't waste their time reading about a...

TravisDBA (11/29/2012)

---

I also agree Dizzy and krowley. There are ways to communicate/explain this to a manager without getting too technical and still get the basic point across. However, after explaining...

I am not sure I agree about explaining. This assumes that managers have no technical abilities and couldn't really understand the explanation. This also assumes that every developer is going...

I would extend this further and say management should have to spend some time doing or at least shadowing both of these jobs.

Then again I believe everyone should have...

I think

i = 0

Do While i < 1

Should be

i = 0

Do While i < 10

I am going to go less serious and more geeky. Geordi La Forge from Star Trek. The ultimate problem solver. If it could be done Gordi could do it. And...

Ours is a small shop with a relatively small 3-4 GB database for our primary app.

We have 4 copies of the DB plus backups.

1 Production

1 Development\Testing

1 Training

1 out of date...

Makes sense if this was a SQL 2005 project. We still have a lot of stuff running on SQL 2005 as well.

Travis,

Its all lawyer speak. The lawyers require companies put that kind of thing in to CYA and because it keeps them employed. Also like any powerful tool it...

Ahh the embarrassment of looking back at our attempts to predict the future from the past. The truth is Amazon does care because they have made it their business to...

I noticed you were using and passing floats rather than the new spacial data types introduce in SQL Server 2008. Any reason why?

I found a way to do this by adding

AND T2.NAME is not null

to the where clause of the top select. Still not sure if this is the best way...

We take image backups of the server partition for system restore purposes along with our SQL Server backups. Is there any way to have this script only consider SQL Server...