I found this one fairly easy. Good discussion, which adds to question.

Regarding Time in Service, I stay away from trying get into too much detail regarding how much time was spent writing stored procedures or triggers or view, and such. ...

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 appropriate conferences (PASS, SQL...

As I thought about the labs, even if Microsoft actually hosts the MCJ testing systems, these would probably be best accessed from certified testing centers to help reduce the possibilities...

Steve Jones - Editor (4/2/2010)

---

CirquedeSQLeil (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

If you spend 50% of your time coding, what were you doing with the other 50%? There is more than coding, so...

Paul White NZ (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

You know, if Paul keeps up this pace (100 pts/day average) in 2 months he'll be breathing down Barry's neck. Another 30 days, he'll...

Grant Fritchey (4/2/2010)

---

CirquedeSQLeil (4/2/2010)

---

You make a good argument against the Time in Service.

If we drop the time in service, would we implement more tests? I see more tests as...

You know, if Paul keeps up this pace (100 pts/day average) in 2 months he'll be breathing down Barry's neck. Another 30 days, he'll quite possibly be in 4th...

As an aside, I have toyed with SSAS since SQL Server 2000. I think it was easier to experiment with in SQL Server 2000 than it is now in...

If you spend 50% of your time coding, what were you doing with the other 50%? There is more than coding, so I have to say 1 year is...

GSquared (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

GilaMonster (4/2/2010)

---

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by...

Jason Shadonix (4/2/2010)

---

Thanks for the input (this turned into a neat discussion!).

I just switched everything over to use backup compression for my full and differential backups, and it seems to...

GilaMonster (4/2/2010)

---

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as...

In SQL Server 2005 you can create DDL triggers that can capture such events and log them to a table for reporting, and possibly prevent it.

I'd suggest that you start...

You can grant him (her) db_ddladmin, but this would give them rights to alter/drop as well as create.