p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't...

I don't think it helps that there are many, on certain websites (cough Stack overflow cough) that don't help the situation by answering the questions for these people, just...

I don't know where you are located, but you can always reach out to local non-profits to see if they use SQL Server and if they do they are always...

I'll be the dissenting voice here.  I've used SSIS quite successfully for migrations, data warehouse loads, and file loads into databases.  In my opinion, SSIS, particularly since 2012 with the...

As has already been shared, while Profiler/SQL Trace has been deprecated, it really means that no new features will be supported by SQL Trace.  For instance as soon as you...

Ola's scripts are AG-Aware so they should do nothing on a secondary for databases that are in an AG.

Thanks.  I haven't had the opportunity to trace through all that SSRS is submitting.  It looks like this query is being passed as shown without a parameter for the user,...

You are not defining the array of jobs properly.   You need to replace the curly braces with parenthesis.

$job = @(
    'BASELINE_CaptureConfigData',
   ...

Had an interesting one the other day.  Client had a corrupt database and had broken the log chain by setting DB to SIMPLE and then back to FULL so had...

I know you have said you updates stats, but did you do the update stats on both databases AFTER you restored them to this instance?

What is the source...

Awesome!  Thanks for sharing the solution.  I honestly never would have thought of this since I don't think I have ever used a configuration in an SSIS project.

Sorry Brandie, I didn't get email notifications about your new posts until this morning because I would have replied had I seen your questions.

First, I still think you...

Sounds like a data issue in DEV where one of the functions you are using, likely FINDSTRING is not returning a value > 3 so the -3 is causing a...