4 min read
0
Get CPU Utilization Data from SQL Server
Monitoring the CPU utilization of a SQL Server instance is…
Category: MSSQL
6 min read
0
Driver could not establish a secure connection to SQL Server
Driver could not establish a secure connection to SQL Server…
3 min read
0
Migrating SQL Server Database Mail Settings
Migrating SQL Server Database Mail Settings Migrating SQL Server Database…
2 min read
0
Checking SQL Server Job History by Script
Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains all major information regarding the…
3 min read
0
Checking Compatibility Level Of All Databases In SQL Server
SQL Server is a relational database management system (RDBMS) developed…
5 min read
0
Find active transactions by duration
Recently frequently we faced blocking issues on our production server.…
1 min read
0
Certificate chain issued by authority that is not trusted
Certificate chain issued by authority that is not trusted Recently…
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…
4 min read
0
Monitoring Database Backups Details using T-SQL SELECT Statement
Introduction As a database administrator, one of the crucial tasks…
3 min read
2
Database stuck in Mirroring, Disconnected / In Recovery
Mirror database stuck in the state of ‘Mirroring, Disconnected /…