-
Operating system error 50 in Azure SQL Managed Instance
8 December 2022We encountered an error while taking a backup of a database from Azure SQL Managed Instance to Blob. This issue is not specific to Azure Managed Instance (MI), but error…
-
Password reset of SQL service account
30 November 2022Impact of resetting password for SQL Server service account Resetting the password of your SQL Server service account is a critical security measure that should not be taken lightly. In…
-
Customizing the Status Bar Color in SQL Server Management Studio
25 November 2022Introduction In database management, it is common to work with multiple environments, such as development, staging, and production. Each environment has a different purpose, and making changes to the wrong…
-
How and Why to become a SQL Server DBA?
21 November 2022What is a SQL server dba? A database administrator (DBA) is responsible for the performance, integrity, and security of a database. They may also be involved in the planning and…
-
Get CPU Utilization Data from SQL Server
19 November 2022Monitoring the CPU utilization of a SQL Server instance is crucial for maintaining optimal performance and identifying any potential bottlenecks. In this blog post, we will explore how to analyze…
-
Driver could not establish a secure connection to SQL Server
17 November 2022Driver could not establish a secure connection to SQL Server Recently windows patching was done on a server and also SQL server security got update with the same patch. Later…
-
Migrating SQL Server Database Mail Settings
16 November 2022Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles, accounts and settings can be a complex and time-consuming process. This article will provide an overview of what…
-
Checking SQL Server Job History by Script
7 November 2022Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains all major information regarding the SQL Server job and its running status and history. We may directly query both objects and get the details or…
-
Checking Compatibility Level Of All Databases In SQL Server
28 October 2022SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is a server-based system that can be accessed by multiple users simultaneously. It offers many features, including…
-
Find active transactions by duration
15 July 2022Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a few SQL servers and migrated all databases to a single…