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)? In this post, we will explore the primary responsibilities of…
Read FullMonth: February 2023
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 a Microsoft SQL Server database, we can use several Dynamic…
Read Full
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 following steps. 1. Connect to your Azure SQL Managed Instance…
Read Full
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 on the server. As a general recommendation, it's best to…
Read Full
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 temporary data. Over time, TempDB can grow significantly, leading to…
Read Full