-
Check SQL Server Version & license details
12 March 2023As 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…
-
SQL Server DBA Roles and Responsibilities
25 February 2023Are 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…
-
Identify and Store Active Transactions
10 February 2023Scenario 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…
-
Backup TDE protected database on Azure Managed Instance
9 February 2023We 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…
-
TempDB files recommendation in SQL Server
8 February 2023The 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…
-
Shrinking TempDB in SQL Server: A Step-by-Step Guide
7 February 2023Introduction 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…
-
How to change SQL Server instance name
3 January 2023Scenario 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…
-
How to fix a suspect mode database?
2 January 2023Scenario 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…
-
How To Check Free Space in Data and Log Files in SQL Server
31 December 2022In a database, data and log files are used to store the data and log records, respectively. It is important to monitor the free space in these files to ensure…
-
Attachment size limit in SQL Database Mail
19 December 2022Overview of Database Mail Are you looking for the quickest and most efficient way to check the attachment size limits in your SQL Database Mail? Database Mail is a powerful…