Thank you. I enjoyed the article very much.

___

It would have been helpful to know what prerequisites are required for a command to run successfully. For example,

-- Run this on each server instance participating in...

• This reply was modified 7 months, 2 weeks ago by  andre.quitta.

I very much enjoyed this article. One of the best ones I've seen in a while.

The nice part about this article is that it is generic and the principles could be applied to any database platform. Same with the execution, with Python just executing T-SQL...

Also Active Directory groups and reduced use of SQL logins helped us a lot. We also rename the SA account and disable it.

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...

Turns out they came from Visual Studio 2015 when defining an SSIS Data Source as a Project Data Source.

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.

for SSRS 2016 -- 

Agreed with the header and footer skewing the Excel column creation.

• Start out with just the table(s). Get rid of...

These are both really good. Will discuss with my Release Manager and my Architect which direction.
Thanks very much.
Andre

Sue,

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...

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...

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...