OTI

Introduction Data security is a critical aspect of database management, and encrypting sensitive data is crucial to safeguarding it from unauthorized access. In SQL Server, Transparent Data Encryption (TDE) provides…

In a SQL Server environment, it can be useful to monitor the user activity and track who is connected to the databases, from which machine they are connected, when they…

As a SQL Server DBA, I would rephrase the statement as follows: While SQL Server does not keep track of license information, it can provide you with details about the…

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…

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…

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…

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…

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…

Scenario Troubleshooting host name changes. When the machine name is changed where we have installed SQL Server, all the instances services are started but replication, Jobs, Alerts, Maintenance plans causes…

Scenario A database in Suspect mode is one that is not fully operational and may have some form of corruption or problem. If you are experiencing this issue, you will…