Viewing 15 posts - 1 through 15 (of 9,629 total)
There are several uses:
March 31, 2020 at 7:37 pm
We had a person at my old job. She was ALWAYS on the phone. I got curious as to why and so I discreetly "hung around"...
December 6, 2019 at 10:12 pm
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...
December 6, 2019 at 3:06 pm
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...
December 6, 2019 at 2:15 pm
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...
November 15, 2019 at 6:19 pm
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...
October 21, 2019 at 2:46 pm
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...
October 17, 2019 at 7:10 pm
Ola's scripts are AG-Aware so they should do nothing on a secondary for databases that are in an AG.
August 31, 2019 at 1:41 pm
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,...
August 20, 2019 at 9:00 pm
You are not defining the array of jobs properly. You need to replace the curly braces with parenthesis.
$job = @( 'BASELINE_CaptureConfigData', ...
July 25, 2019 at 4:28 pm
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...
March 21, 2019 at 9:07 am
February 28, 2019 at 1:53 pm
I received a call this morning (2019-02-15) at approximately...
February 25, 2019 at 8:40 am
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...
October 18, 2018 at 7:30 pm
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.
May 30, 2018 at 12:37 pm