you read them in SQL Server as any other .xel file (or through powershell - google it)

folders like this should be owned by a group containing the domain administrators - and then these can grant required permissions to  local administrators and other accounts as needed

starting to get annoyed with this user https://www.sqlservercentral.com/forums/user/srinivasdba19

been posting scripts (and not his own for sure) as reply to a whole bunch of threads - some of the scripts are...

doesn't the hotfix work?

'{000C1B7A-164A-4243-9952-01BC82236EB0}' is not the same as '000C1B7A-164A-4243-9952-01BC82236EB0'

some changes on forums are acceptable - SQL ServerCentral change from old format was a "soft" change and not a "I will never use this again" change.

I used to be...

issue with using a "specific login" is that a sysadmin can execute as any login - so it will still not prevent a DBA from doing it which was the...

you can't - and if you don't trust your dba's not to use it then change the process of accessing that linked server so that it is on a black...

bump for visibility.

and speed differences may be to do with settings on ssms vs vb.net

it really shows a lack of understanding of how SSIS Catalog deployment works, even within VS (which does invoke a command line tool to deploy).

everything can be deployed from CI/CD...

what happens if you move that SP to another container, being executed after the other ones?

and most times its some settings on your sp's or locking between SP's - and...

the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.

while there are 2 ways...

doing a select * in SSMS will also be impacted by network speed between workstation and server, workstation processor (and available cpu %), memory, disk speed, and SSMS settings.

if you...

SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and...

This does not bring back any records unfortunately:

SELECT DISTINCT tp.client_id AS Member_ID
, tp.PaidDate AS Paid_Date
, tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate BETWEEN @startDate AND...