6 min read
0
Driver could not establish a secure connection to SQL Server
Driver could not establish a secure connection to SQL Server…
Author: OTI
Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
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 /…
2 min read
0