Month: February 2023
Posted in MS SQL
How to Identify and Store Long Running Queries in a Table
Scenario How to Identify and Store Currently Long Running Queries in a…
Posted in MS SQL
How to backup a TDE protected database on Azure SQL Managed Instance
We can take a COPY_ONLY backup of a TDE-protected (encryption enabled) database…
Posted in MS SQL
TempDB files recommendation in SQL Server
The number of tempdb data files in an SQL Server depends on…