Year: 2023
Posted in MS SQL
Check SQL Server license in SQL Server
As a SQL Server DBA, I would rephrase the statement as follows:…
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…
Posted in MS SQL
Find All Permissions for All Users in SQL
We recently encountered an issue with one of our users being denied…
Posted in MS SQL
How to change SQL Server instance name
Scenario Troubleshooting host name changes. When the machine name is changed where…
Posted in MS SQL
SQL server database in SUSPECT MODE
Scenario A database in SUSPECT mode is one that is not fully…