Legacy Cardinality Estimation: If performance regressions occur after upgrading, SQL Server 2019 allows enabling the legacy CE model for specific databases or queries. This can be done using the ALTER...

Execution Plan Differences: Compare execution plans before and after migration to identify bottlenecks.

Query Store Analysis: Use Query Store to analyze execution times and identify regression cases.

Locking and Blocking: Investigate any...

• This reply was modified 1 week, 5 days ago by  Tav29.

The database compatibility level determines how SQL Server interprets and optimizes queries based on the version's features. If your database was migrated from SQL Server 2017 to 2019, it may...

Your welcome.

Found this: https://stackoverflow.com/questions/18888457/allowing-excel-privileges-to-sql-server-agent

Check SSIS Package Configuration:   If you're using SSIS, ensure the package is configured to run under a domain account with access to both the file and the Excel object.

Could be a rendering issue if you are doing any calculations, Conditional formating or grouping with totals in the report.  Or if you have a embedded image. Take a look...

Double Post

Using SQL Queries on the ReportServer Database.  The and tables in the ReportServer database store information about data sources and reports.

You can get the "New Datasource Link "from Datasource Table...

CREATE TRIGGER TriggerName
ON YourTableName
AFTER DELETE
AS
BEGIN
    -- -- Check if any row was deleted (= 1 or True)
IF EXISTS (SELECT 1 FROM DELETED) 
 ...

Powershell & Python.

Backup your SSRS Databaes(ReportServer and Report Server Temp DB and Any other DB needed) using Microsoft SQL Server Managment Studio: 

And Backup your Encryption Key using...

double post.

You can set permisions per report or on entire folder. My hunch is you have permissions set on reports not the folder.

Found this:

Use Key Vault Insights: Azure provides Key Vault Insights, a feature in Azure Monitor, to visualize metrics like request frequency, latency, and failures.

Monitor SQL Server Activity: If you're using...