Fun, database with thousands of tables and no foreign keys

Things that are interesting in SQL 2019 are the accelerated database recovery and the new oracle driver for SSIS (preview)

Also verify the host-configuration as the processor is virtualized (Common KVM) it must run on some host. Is power-saving disabled ? how are the resources distributed between VM's? Are the...

You can try

Invoke-Sqlcmd -ServerInstance "$serverinstance" -database "Gestion_BO_Stats" -Query "exec SP_EQUITE_SANTE_CDC_Contrats" |export-csv -path "$path\SP_EQUITE_SANTE_CDC_Contrats_$((Get-Date).ToString('MM-dd-yyyy_hh-mm-ss')).csv"

as powershell variables are expanded when used between double qoutes

How do you did it?

Why not rename the logins / logingroup with ALTER LOGIN ...  to keep the same SID ?

Can anyone recommend a powershell forum? Invoke-webrequest loses some of its parsing in powershell 6 (especially the forms part)

Perhaps you can start with readcommited snapshot isolation instead of in-memory? The optimistic locking should reduce blocking from reporting

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

I did have the same problem with excels exported from SSRS. Haven't tried to fix it beyond opening the excel and saving it again with excel

• This reply was modified 5 years, 8 months ago by Jo Pattyn.

Which version of SSMS is it? because is has been decoupled from the sql server installation. 18.4 , ... ?

--to be validated
--cte or tablealias for selfjoin
WITH TABLEDATA AS
(
SELECT ...
FROM TABLE_DATA
)
SELECT TYTD.COLUMNS, TMTD.COLUMNS
FROM TABLEDATA TYTD
LEFT JOIN TABLEDATA TMTD
ON TYTD.NAME=TMTD.NAME
AND TYTD.COMPANY = TMTD.COMPANY
AND TMTD.Flag='MTD'
...
WHERE TYTD.Flag='YTD'; 
--also possible
SELECT YTD.columns,...

• This reply was modified 5 years, 9 months ago by Jo Pattyn. Reason: where flag

Reasons to use SSIS:

• Already made a large investment
• Drag-drop synchronisation. If A+B complete, run C
• Microsoft Oracle SSIS - driver (speed improvement over the normal Oracle OLE DB driver)

...

I use https://sqlserverbuilds.blogspot.com/ to track the latest builds.

You can also use https://www.sqlservercentral.com/articles/sql-server-build-lists or https://sqlserverupdates.com/

For 2016 it is SP2  + CU 11

Didn't get much improvement with the current Oracle OLEDB driver. Even with balanced data distrubutor.

The new microsoft oracle connecter is promising (SQL Server 2019 CU1+).

https://techcommunity.microsoft.com/t5/sql-server-integration-services/microsoft-connector-for-oracle-is-released-for-sql-server-2019/ba-p/565923

Processing speed goes up from...

We try to implement them every 2 months. First a testing period of 1 month in dev and acceptance. So far the updates didn't break anything