4 min read 1 MSSQL SQL Server DBA Roles and Responsibilities OTI 25 February 2023 Are you interested in the world of database management? Do you aspire to become a SQL Server Database Administrator (DBA)?…
7 min read 0 MSSQL Identify and Store Active Transactions OTI 10 February 2023 Scenario How to Identify and Store Currently Running Queries in a Table? To retrieve information about currently executing requests on…
4 min read 0 MSSQL Backup TDE protected database on Azure Managed Instance OTI 9 February 2023 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 MSSQL TempDB files recommendation in SQL Server OTI 8 February 2023 The number of tempdb data files in an SQL Server depends on several factors, including the number of logical processors…
3 min read 0 MSSQL Shrinking TempDB in SQL Server: A Step-by-Step Guide OTI 7 February 2023 Introduction In SQL Server, TempDB is a system database used to store temporary objects, intermediate results of queries, and other…