-
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…
-
Certificate chain issued by authority that is not trusted
21 June 2022Certificate chain issued by authority that is not trusted Recently we moved whole on-premises resources to the cloud. In an easy word, we have moved SQL Server from on-premises to…
-
Check the Status of EMail Messages Sent With Database Mail
13 June 2022In SQL Server sp_send_dbmail use to send emails and the SQL Server log all the status of each message processed by Database Mail. Below is the quick list of Database…
-
Monitoring Database Backups Details using T-SQL SELECT Statement
27 May 2022Introduction As a database administrator, one of the crucial tasks is to ensure regular backups of databases. Monitoring the Database Backups Details including backup status and locations of different types…
-
Database stuck in Mirroring, Disconnected / In Recovery
23 November 2021Mirror database stuck in the state of ‘Mirroring, Disconnected / In Recovery’ We have an interesting situation after configuring a mirror setup. We have configured mirroring between a list of…
-
Change Default TCP Port in SQL Server
22 September 2021Change Default TCP Port in SQL Server When any version or edition of MSSQL Server is installed, by default it’s installed on default port 1433. By default, we need to…
-
Things You Must Do After Installing SQL Server
13 July 2021Things You Must Do After Installing SQL Server Rolling out SQL Servers is a key task for DBAs. While for some DBAs this can be a frequent exercise, others will…