Viewing 15 posts - 1 through 15 (of 45 total)
Also Active Directory groups and reduced use of SQL logins helped us a lot. We also rename the SA account and disable it.
October 7, 2019 at 2:03 pm
I've found that bigger teams require Leads to represent the group or else Stand Up takes a long time. You're right that management is very hard, especially in IT. I've...
September 23, 2019 at 4:16 pm
Turns out they came from Visual Studio 2015 when defining an SSIS Data Source as a Project Data Source.
December 17, 2018 at 2:30 pm
We created a pattern where setting up Always On was done with a remote login of a windows service account. It took care of a lot of problems.
October 25, 2018 at 9:43 am
for SSRS 2016 --
Agreed with the header and footer skewing the Excel column creation.
September 18, 2018 at 9:09 am
These are both really good. Will discuss with my Release Manager and my Architect which direction.Thanks very much.Andre
August 8, 2018 at 4:07 pm
Thanks for your reply.
I've looked through various RS.EXE web pages and I don't see examples on how to create a new Data Source with credentials...
August 8, 2018 at 2:26 pm
August 8, 2018 at 11:27 am
when I tried to run the code in Powershell, I got the following error.
[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module file was found...
March 31, 2016 at 10:00 am
We'd use a not dissimilar approach for creating test data and removing sensitive data when copying from production to development. Each of the tables had a corresponding table in a...
November 17, 2015 at 9:15 am
Yeah, I found a lot more since I first posted. For example, from the master server:
select server_name, *
or this, to help identify target servers that are failing:
September 21, 2015 at 8:42 am
You're right. I should have expanded on this. The archive data would be exported to a database on another server. If that is not possible, then an export to a...
August 17, 2015 at 9:56 am
You may also free up some space with a more aggressive archiving approach to your data, or install archiving at all.
I've seen a number of legacy systems have up 10...
August 17, 2015 at 9:34 am
I've had much better luck historically by creating a [font="Courier New"]#TempTable[/font] with a [font="Courier New"]Done = cast(0 as bit)[/font] extra column.
That way I can review the results at the end...
June 1, 2015 at 10:53 am
I didn't have any success with Adam Haines' approach. When trying to test this I got the error:
[font="Courier New"]The specified schema name "dbo" either does not exist or you do...
May 26, 2015 at 6:25 pm