-
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…