4 min read
1
SQL Server DBA Roles and Responsibilities
Are you interested in the world of database management? Do you aspire to become a SQL Server Database Administrator (DBA)?…
Year: 2023
7 min read
0
Identify and Store Active Transactions
Scenario How to Identify and Store Currently Running Queries in a Table? To retrieve information about currently executing requests on…
4 min read
0
Backup TDE protected database on Azure Managed Instance
We can take a COPY_ONLY backup of a TDE protected (encryption enabled) database on Azure SQL Managed Instance using the…
2 min read
0
TempDB files recommendation in SQL Server
The number of tempdb data files in an SQL Server depends on several factors, including the number of logical processors…
3 min read
0
Shrinking TempDB in SQL Server: A Step-by-Step Guide
Introduction In SQL Server, TempDB is a system database used to store temporary objects, intermediate results of queries, and other…
2 min read
0
How to change SQL Server instance name
Scenario Troubleshooting host name changes. When the machine name is changed where we have installed SQL Server, all the instances…
3 min read
0
How to fix a suspect mode database?
Scenario A database in Suspect mode is one that is not fully operational and may have some form of corruption…