3 min read
0
Checking Compatibility Level Of All Databases In SQL Server
SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is a server-based system that can be…
Year: 2022
5 min read
0
Find active transactions by duration
Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a…
1 min read
0
Certificate chain issued by authority that is not trusted
Certificate chain issued by authority that is not trusted Recently we moved whole on-premises resources to the cloud. In an…
3 min read
1
Check the Status of EMail Messages Sent With Database Mail
In SQL Server sp_send_dbmail use to send emails and the SQL Server log all the status of each message processed…
4 min read
0
Monitoring Database Backups Details using T-SQL SELECT Statement
Introduction As a database administrator, one of the crucial tasks is to ensure regular backups of databases. Monitoring the Database…