I think I can answer both questions, but I would still recommend doing it in a test environment first.

So question 1 - my understanding is that SSRS hasn't had any...

Jeff - your approach is what our devs (myself included) are migrating to (I think).  Basically, the connection string gets stored in a settings file that is read on app...

As a guess - I would say that WinSCP probably has a list of valid fingerprints stored somewhere and when you connect, it checks the fingerprint against the known good...

That makes sense as the fingerprint is the fingerprint of the remote server.

I would recommend looking at some of the example scripts on the WinSCP site.  This one specifically should...

I would check to make sure the input is valid.  Double check the values you are passing into the properties of WinSCP.  For example, check the value of "$config.Configuration.HostName".  is...

On top of what ratbak indicated - when you say "Azure SQL", do you mean it is an Azure SQL Instance, an Azure SQL Managed Instance , or an Azure...

I expect you would get more help in a C# forum than a SQL Server forum, but I would reach out to your development team and work with them to...

Brandie - are you using SQL Aliases OR DNS Aliases?  If it is DNS aliases, you will likely need to include the instance name (for a named instance) when you...

I am pretty sure that SQL Configuration Manager aliases just put aliases on the server or on one individual workstation, not on all the client machines (don't quote me on...

One thing about the CPU - a lot of SQL Server operations are single-threaded, so having a lot of cores may not benefit you.  There are exceptions (as queries can...

hahaha... no, that isn't what I meant Grant... I am going to edit that to be 99% agree with that.

To me this sounds pretty easy to do and I expect there are multiple solutions, but my approach would be to break it up into multiple steps for the sake...

I 99% agree with Grant (that is not one ugly dude).  In-person events get you so much more interaction and discussion than virtual.  Both from the presenter side and from...

• This reply was modified 4 years, 2 months ago by Mr. Brian Gale.

My opinion - this is the wrong site for that.  This is a SQL Server forum, not an SEO forum.

My best guess though as to why some newly published blog...

Your story sounds a lot like mine, except I don't lead a team... I'm just a member of a team of 3 DBA's who do non-DBA things (like development work)...