MB, TB, whatever. The hours relate more to how much of your life you are willing to commit. I spent more hours managing a single server single db...

Exactly the problem with current IT management. I spent 42 yeas in IT, including 11 years in managemnt. Figured out that you can't stay current if your focus...

Added Note to above:

I use SQL Job History Visualization mentioned, and it is an excellent aid in figuring out what is happening in parallel in SQL Agent. This is...

Hi CEWII. You're right, I'm the crazy one. But only for another 9 weeks. Then I'm off to the high country for the summer. I'll probably...

We keep two days of full backups and transaction log (varies 1 to 3 hour backups) files on-server, with entire backup directory backed up to tape nightly. Maintenance plans...

hey, SSC-enthusiastic, if you trained your replacement in 6 months, I'd guess the company 'did it' to themselves. What is 6 months training for a DBA? A good...

Comments regarding working at home remind me that my suggestion several years ago that our 4 DBA's take a rotating day each week to work at home during high fuel...

Hi, folks. I'm back online, on my late lunch hour this time. I appreciate the comments about my thoughts on 'company time'. I agree that we all...

Well, folks, I'm so seasoned that I'm pretty salty. I've been helped by a number of good folks over a 40 year career, and have helped train a number...

Right on, Gila Monster. If you have high blood pressure or hives, you genarlly can 'get by' going to a GP. If you have cancer, don't you go...

To everyone following this train of thought, I think maybe the reality is that there are any number of ways of testing SQL, and I suspect that each of us...

Yes, lots of DBA's don't know .Net very well. I know probably the least. But I'm a *&^% good DBA and I do far more than rerunning failing...

"...few DBAs and Database Developers have the required .NET skills..."

I heartily agree witih this statement. And from my experience I would add:

"...few application developers have the required database and...

I have to say I prefer the CASE approach to code such as this. Also remember that proper indexing of tables and thoughtful arrangement of parameters according to most...

I have to say I prefer the CASE approach to code such as this. Also remember that proper indexing of tables and thoughtful arrangement of parameters according to most...