James, there are really no worries around replication. Replication will maintain transactional consistency and pick back up again when the agent is restarted. More difficult is the scenario where one...

Thanks for your comments so far!

- There is no way to disable the shutdown command that I know of. Using it requires the user to be in sysadmin or serveradmin...

We"ll have to work harder on our messaging. The 'SSC' code is valid every year, it's a standing arrangement with PASS. I think next year we'll send out a special...

Thanks to all for the comments so far.

Certainly this question is presented in person and the candidate encouraged to offer questions to help clarify any scenario presented. Few ask...

Steve mentioned this to me and initially I thought it was pretty interesting since it could reduce the time needed for your backup - freeing up time in the maintenance...

Adding reporting services to all versions is definitely a nice touch.

I do the same, for much the same reasons. One of the things I teach anyone doing DBA/Jr DBA work is to always have a plan if you do something...

Congratulations Frank and well done!

My two cents...

One way would be to write a little code, use the filesystem object to loop through the files and folders, attach any mdf/ldf found. Lots of variations possible.

Another...

First one is doing well, 2nd one...we shall see. Now that I've mastered the technique, all things are possible!

Congratulations Frank!

It's been a while since I looked, but I think you can use MSDE as a subscriber of transactional, dont think you can publish from it (double check me if...

Slightly off topic, but perhaps worthy of mentioning here considering the references to training (does it count that I mentioned it earlier?) - how many of you (or your employers)...

I think a lot of it is networking. Which to me should be a part of the agenda, but not the main part.

At its peak Orlando had 15 attendees, averages a lot less now. I think the .Net group has 30-50 attendees per meeting. That's from metro Orlando, not the smallest city...