Thanks one and all for the tips and advice...I plan to pass this thing in just under 30 days, or even sooner if I can. I need to get...

GilaMonster (1/7/2016)

---

Looking at the score, you probably missed it by one or two questions.

For aggregates, read up and practice group by, the aggregate functions (sum, count, min, max, etc), practice...

GilaMonster (1/7/2016)

---

Probably yes. You'll get...

FridayNightGiant (1/7/2016)

---

It is OK to reveal your score if you want to or discuss the top 3 weakest areas from your score record.

You shouldn't discuss anything to do with the...

So, I failed the 70-461 exam on Tuesday and in retrospect, I know why. Even though I've been an accidental DBA since roughly 2001, There are many things we...

I ended up using the SQL Data Compare utility from RedGate against a backup restored under a different name from just prior to the SP running. Easy peasy.

Should have...

GilaMonster (6/21/2015)

---

You become an 'expert' by studying, trying, reading, practicing and making...

Thank you both for the help, ideas and guidance! :w00t:

SqlSanctum (6/19/2015)

---

I have taken cert tests before actually, including current cert on Security+ from CompTia and a now useless certification in Microsoft Visual Basic 6 back in the day.

I thought...

SqlSanctum (6/19/2015)

---

If you are considering dropping 6k, then you can spend a lot less and get a lot more.

Buy all three Microsoft Toolkit books for the exams, you can find...

GilaMonster (6/19/2015)

---

Boot camps are typically designed to get you to pass the exams, not learn the material. They're a few of days of cramming what you need to pass the...

Should have checked first...there doesn't seem to be a 2014 path so answered my own (stupid) question.

ScottPletcher (6/18/2015)

---

With this method, the web login/user can use only procs that you're explicitly given the web app authority to execute. I don't know how to lessen the risk....

Ok, tried this approach and Viola!

However, in speaking with the dev, we are going to together attempt a different approach to solve the underlying problem that will not require such...

That might work. I'll try this when I get back to work tomorrow. Thanks!