It happened several years ago but feels like it was just yesterday...

I was at this company maybe a month or two. We had a third party app with thousands...

@Paul.knibbs

I ran into this early in my career and here's why you want to roll back individual transactions: if you restore and stop at a time before the...

Yeah, I do the same thing. I found it odd as well because I use dynamic SQL to traverse a database list regularly. It caught me by surprise...

Thanks for taking that so gracefully. Here's the script and the errors, one for ReportServer and one for ReportServerTempDB.

SET NOCOUNT ON

/*

** "Challenger, go at throttle up..."

*/

-- Create variables

DECLARE @dbname...

Brandie

I apologize - I'd run the script as a script rather than a stored procedure (some servers I manage don't have a utility db to create procedures in) and it...

Brandie

Thanks for the script - I'm sure it'll come in handy. One FYI though: the dynamic SQL didn't handle collation conflicts (doggone that ReportServer db... <grin>).

Cheers,

Ken

I agree with the majority: Feeling sorry for the replaced workers. My opinion is that if I lost my current position, I'd still be valuable to another company that...

Assuming the service account has access all the way down the folder hierarchy to the target folder, start at the topmost folder and try to have the job write the...

Hey, Grant!

Excellent topic. I get the jab at "one size fits all just doesn't work". I haven't had a ton of experience with multi-platform apps ("Oracle, SQL, MySQL,...

I jotted down some ideas. This is meant as a cheat sheet, not really an entire game plan. (read: "your mileage may vary")

[font="Courier New"]

Pre-disaster prep

- Document the current server...

Fly Girl

Did you get a chance to practice your DR yet? Reply if you run into any snags.

Cheers,

Ken

In my humble opinion automation gives you more time to focus on other tasks but it also gives you a thorough understanding of the task you've automated and a better...

Yeah, that's the way it usually goes. You see it in the classifieds all the time - "Wanted: IT Manager. Responsibilities include administration of Exchange, SQL Server, Oracle,...

I believe the phrase is "accidental DBA" <grin>

Hopefully the new CIO will recognize this mess for what it is and allocate resources/budget/etc. to fix it properly.

Re: "High end consulting firm"

<sarcasm>...

I've had the opportunity to see this Qure Workload Analyzer gizmo in action (http://www.dbsophic.com/qure-analyzer.html) and it [might] help your cause. I think it's still free. The...