Patching involving everything - hardware, virtualization, OS, database instance. All of these things should be in similar cadence, they are all written to work with each other at the same...

Its more involved than that, you need to know the text encoding and the specific compression algorithm as well. You will have to know how that was written to the...

max memory only applies to the instance you are configuring it in.

In each SSRS instance, there are memory management configurations you can make in rsReportServer.config. Personally, I have never found...

The vendor app code has NOLOCK all over the places for almost 10 years even before I joined this org(3 years back). now, RCSI is also enabled and we...

be aware that depending on which MI SKU you have, that shrinking the database may reduce the disk performance available to the instance. I suspect the database is the size...

BACKUP DATABASE TO DISK = 'file path' WITH COPY_ONLY,CHECKSUM;

WITH CTE AS (
SELECT
     [tradeId]
     ,[date]
,other columns that uniqueify the record...

I'll second that.

But for your tempdb sizing, whatever you choose, I would recommend statically setting the file sizes and not allowing them to autogrow. Jeff I believe has different thoughts...

I would look closer into veeam. I have succeeded in getting it off of and keeping it off of my SQL servers for the last few years, but it tended...

I am not sure profiler would be of much use to you even if it did support it, Synapse doesn't work the same way as a traditional SQL server does....

Have you attempted suspending and resuming replication? That doesn't resolve the problem but may be less of a hassle rebooting until the issue is resolved.

Is your organization using snapshot backups...

Ola Hallengren's scripts alone won't address the restore speed of 10k databases.

Even if your databases are on the megabyte scale and you use PowerShell to loop through your backups to...

That is how the IN operator functions, it interprets to a series of OR operators.

presumably your publisher database has some sort of encryption enabled and the subscriber server does not have the encryption hierarchy available to handle it. The master key is near the...

VSS snapshots are SQL consistent and the feature no longer requires SQL Enterprise. They are supposed to be very fast - they may not be fast without adequate...

Snapmanager for SQL allows you to database level backups and avoid the OS freeze. We implemented it as a solution to back up a 3-4 terabyte sharepoint site...