Viewing 15 posts - 16 through 30 (of 9,640 total)
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
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...
May 30, 2018 at 7:11 am
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...
May 25, 2018 at 1:53 pm
Are there multiple SSIS Projects in the solution? You might need to go to the project and set it at that level.
May 25, 2018 at 1:45 pm
You could do a DDL trigger on create database as Sue has mentioned, but be sure to test that thoroughly because if the trigger fails the create database will fail. ...
May 25, 2018 at 1:44 pm
Viewing 15 posts - 16 through 30 (of 9,640 total)