GilaMonster (12/1/2014)

The log is NOT an optional part of the database that can just be discarded and recreated. It's a critical part of the database that, if lost, cannot just...

In my case, we're hamstrung by our backup software. I fought the battle that the DBA's should be doing the database backups to disk and the Infrastructure group then pick...

Your friend is a big part of whats wrong with this industry.....

A little knowledge is a dangerous thing....be careful.

First off, my advice is: Change nothing.

Monitor monitor monitor. Get to know the environment. Check all of the agent jobs, what do...

I've used this tool in the past for the same type of thing, as well as anonymizing data for testing:

http://www.matturbanowski.co.uk/?page=AnonymousData

It works well and is cost efficient 😉

The tools should be more refined. Absolutely. Making the tools easy to use and intuitive is a bonus.

If companies put people in charge of their SQL Server platform and are...

I'd set up a SQL Agent job scheduled for whatever time you need this to happen.

One step that executes:

USE <database_name>;

BEGIN

ALTER DATABASE <database_name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE <database_name>...

Thanks, but you're a bit late 😉

IT has been dieing since IT began. Every new technology is the end of the world. Saw it with client/server replacing big iron in glass rooms, saw it with the...

Why oh why has this never come up in any of the sessions at PASS? Where do I send...

Wow, a bit more googling and I stumbled across this: http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

I've NEVER seen this behaviour before afaik. Guess, I'll be rolling my own version of sp_MSforeachdb.

Seem like such...

DRI should be the default, with very rare exceptions that need to be proven as exceptional 😉

I've been burned too many times, when the sh!t hits the fan and...

Am I the only one that is getting NOWHERE with this? I havent been able to get the voucher, just keep hitting one error after another.

I'll play, but with a slight twist, how about he scenario where the candidate did NOT lie, but the interviewers heard what THEY wanted to hear? "I've implemented SSRS and...