Author: OTI

As a SQL DBA, there are various essential tasks to perform every day to ensure the smooth operation and security of the database system. These responsibilities include:

What is the use of DBCC commands?  DBCC stands for Database Console Commands, a few of us also call it database consistency checker. There are many DBCC commands in SQL Server. We generally use these commands to check the consistency of the…

Description This script generates a list of Logins, Users and the Database Roles that the user belongs to in all the databases in A SQL Server; with a couple of other useful information detailed below. Other benefit: you can use…

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 connected and what application they are running. In this blog,…

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 installed edition and version. To ensure proper licensing, it is…

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 a SQL Server DBA and shed light on their crucial…

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 Management Views (DMVs) to gather information about the status of…

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 have one tempdb data file for each logical processor, up…