Since BCP is an external executable - all you can identify from either EE or Profiler will be the SQL statements that are generated and sent to the server.  SQL...

Using sp_executeSql - you can pass all parameters to the dynamic code and only use the parameters needed.  Instead of worrying about 'exceptions' - just pass them all.  The dynamic...

No, no, no, no....

Setup a proxy account and assign that proxy account to the Integration Services subsystem in SQL Server Agent.  Then - use that proxy account to run the...

Does...

Here is another take:

 --==== Create some test data
   Drop Table If Exists #testData;

Declare @startDate date = '2021-01-01'
      , @endDate...

Yes - when you run the SP2 install it will give you the option for each instance.  With that said - you should also be applying the latest CU and...

Yes - here is a template:

Set Nocount On;

Declare @body nvarchar(max)
    ...

Why are you changing the requirements now?  You started with a question about dynamic pivot - that was answered...

If I understand your requirement - you want to run this...

You don't need the CONVERT - you can just pass the datetime string and the value will be implicitly converted (assuming the columns data type is datetime and the string...

Are you using SSRS for the report - or some other reporting tool?  If so - then don't pivot the data in SQL Server, let SSRS (or other reporting tool)...

another complication for me personally is that amongst my officemates there are some vaccine refuseniks, with some presumably never having covid and at the same time being in...

I am not sure who manages this site - but it is my go to site for updates to SQL Server: https://sqlserverbuilds.blogspot.com/

There always seem to be up to date with...

To be honest - I think you are going to find that converting this to use CTE's isn't going to be easy nor worth the actual time spent.  The problem...

The reason it doesn't work is because the variable $p contains a list of all objects returned from get-dbaregserver.  Passing that object through the pipeline to where-object - is passing...