My question is would your "monitor" be better off using:

1. dynamically created & remotely executed openquery(s)

2. using existing linked server coded (lazy...

cartesian products.

Archimedes was a DBA!

SP_WHO2 does not answer this ... it does not give you disk reads and writes. It gives their sums.

with all the possible choices, and p-o-s apple kids toys are mentioned more than anything else

This is how it starts. Steve wants us to police our language at work. Then the government passes laws banning curse words at work and at home for the children's...

WTF, Can we have some people with hair. I mean just cause Steve Jones is bald do we have to assume bald DBA's are exceptional? As DBA with hair,...

Social media like democrazy just highlights that well know fact that we humans are ignorant, self absorbed, self-centered animals barely able to coexist and highly likely to blow ourselves and...

If the password of a SQL service account is THAT important to your companies defense of it's data then you are already inside a hurt locker if you ask me...

When my wife asks my a question that she already asked me a few days ago, I stop and think OH NO I BETTER REALLY PAY ATTENTION AND GIVE THIS...

hmm strange error...

1 Dev environment

1 Integration environment

1 Acceptance Testing environment

1 Automated Testing environment

1 Production environment

Backups weekly full, nightly differentials (unless diff is 50% size of database then take fulls), hourly transactionals

We have...

I think Microsoft & Google have partnered up to use the Google engine to compute how many times Steve has mentioned cloud computing to dispute his cloud sponsorship payments. :w00t:...

a dba database is critical for CDC efforts and security during code releases, audits and dr checks where I work. I use performance collectors for monitoring my 2008 and higher...

Things needed to increase the next generation towards being better bosses would be higher education changes that bring back spanking, political policies that establish dueling as acceptable form of mediation,...

I monitor 100 plus servers, a couple K of databases, 70 to 187TB of space depending on who you want to believe using a home grown hodge podge mix of...