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…
Category: MSSQL
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…
3 min read
2
Database stuck in Mirroring, Disconnected / In Recovery
Mirror database stuck in the state of ‘Mirroring, Disconnected / In Recovery’ We have an interesting situation after configuring a…
2 min read
0
Change Default TCP Port in SQL Server
Change Default TCP Port in SQL Server When any version or edition of MSSQL Server is installed, by default it’s…
15 min read
0
Things You Must Do After Installing SQL Server
Things You Must Do After Installing SQL Server Rolling out SQL Servers is a key task for DBAs. While for…
2 min read
2
Find database size when it is offline
Hi, Tech Giants! What new to me today? Yeah, We did a SQL Server migration activity or we can say…
2 min read
0
Auto-open new query window in SSMS
How to Change Product Key for SQL Server The Microsoft Evaluation Center brings you full-featured Microsoft product evaluation software available…