Glad you've moved on, and a nice editorial. I agree that these challenging jobs help you learn, but I agree with Andy. Easy to get stuck there.

I think you need...

http://www.jasonstrate.com/index.php/2010/08/sql-saturday-on-a-friday/

Jack Corbett (8/16/2010)

---

For choosing sessions, I personally think that having a selection committee nominate the top N for each category and then allowing the community to pick is a good...

First the Summit is typically around 1500 people that pay. Leave out volunteers, speakers, and that's about what the Summit is. Sometimes smaller. I suspect the Rally will be smaller,...

Home, and glad to be here.

The same article can be sent to multiple subscribers.

You set up a new subscriber, point to the existing articles. You can remove the first subscriber, or leave it there.

I'll play, and I'll toss in a prize.

Honestly, this is a place I'd use a CTE since it's cleaner, IMHO, to read. And it's becoming a bit of a convention in code.

With W (applnbr, application_count)

as

(

...

I'll see about sending an email/digest out.

This is one of those things that I'd like to push a little, experiment with, if I make it on the board. If not,...

I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers there. Personally I'd like to have people submit...

I think SSWUG is shaky, ethically. It's not illegal, but it feels like a trick, or scam. I clicked through, got a page to "register" for free, to get to...

Yes, you can back up and restore a database that has CDC enabled.

Yes, just setup a new subscriber for Server C. Then remove the subscriber for Server B is you want. You can replicate to two servers.

I tend to agree with Jeffrey. I use domain accounts, no domain permissions unless needed, and let Configuration Manager assign permissions.

I do separate out SSAS or Integration Services, but typically...

Upgrade Advisor here

http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en