1 min read
0
Find the users connected to SQL Server
In a SQL Server environment, it can be useful to monitor the user activity and track who is connected to…
Category: MSSQL
4 min read
0
Check SQL Server Version & license details
As a SQL Server DBA, I would rephrase the statement as follows: While SQL Server does not keep track of…
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)?…
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…
6 min read
0
How To Check Free Space in Data and Log Files in SQL Server
In a database, data and log files are used to store the data and log records, respectively. It is important…