CirquedeSQLeil (4/2/2010)

---

Steve Jones - Editor (4/2/2010)

---

You should read Brent Ozar's blog on the MCM (http://www.brentozar.com/archive/tag/mcm/) , especially today.

The QOD isn't appropriate. It's more for the junior people that are trying...

Lynn Pettis (4/2/2010)

---

Paul White NZ (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through...

It looks like the xp_readerrorlog is different in 2005 than in 2000. This is where you are getting the error message. You may need to add some fields...

Steve Jones - Editor (4/2/2010)

---

You should read Brent Ozar's blog on the MCM (http://www.brentozar.com/archive/tag/mcm/) , especially today.

The QOD isn't appropriate. It's more for the junior people that are trying to...

I disagree. The application should not manage database integrity.

Congrats - they are well written.

Trey Staker (4/2/2010)

---

Hmmm... makes me wonder how most of you study?

I know my knowledge gaps and constantly try and fill them. Occasionally through the forum discussions I've...

Paul White NZ (4/2/2010)

---

Ha. This is something I do quite a lot in real life: have a whole discussion in my head...

Paul White NZ (4/2/2010)

---

I find the whole TiS thing very difficult - it adds a fair amount of administrative overhead without really proving much. I guess maybe a year...

Alvin Ramard (4/2/2010)

---

Sometimes I'm still amazed by how fast technology moves. I just ordered a 2 TB HD for $150. The first computer I ever ordered included a...

Chad Crawford (4/2/2010)

---

Ah. I missed that. I was thinking of setting up the Snapshot to run once per week, and then maintaining that publication as procs or...

dmiller-745870 (4/1/2010)

---

Since we switched over to the new system (SQL Server 2008), I am having problems staying connected. If I leave the system for a bit when I go back...

I envision the MCM being completely different....

Grant Fritchey (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

Recertification should include testing, presenting original material at users groups/conferences, attending...

Paul White NZ (4/2/2010)

---

Jason,

Paul White NZ (4/2/2010)

---

I would be tempted to restore the production database to the staging server, and then run a script to set up snapshot replication with...