Great minds discuss ideas!
Certificate 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 Azure cloud as IaaS. Now few users ran into this…
In 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 Mail Views you can query to find the status of…
Introduction 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 of backups can be challenging in a large SQL Server…
Mirror database stuck in the state of ‘Mirroring, Disconnected / In Recovery’ We have an interesting situation after configuring a mirror setup. We have configured mirroring between a list of databases between two physical SQL Server. It was working great…
Change Default TCP Port in SQL Server When any version or edition of MSSQL Server is installed, by default it’s installed on default port 1433. By default, we need to access SQL Server by use port 1433 while communicating with…
Things You Must Do After Installing SQL Server Rolling out SQL Servers is a key task for DBAs. While for some DBAs this can be a frequent exercise, others will have to face it one time or other throughout their…
Hi, Tech Giants! What new to me today? Yeah, We did a SQL Server migration activity or we can say a side-by-side up-gradation activity. From our DBA side, it’s almost done 90%, 10% percent is pending. We have some offline…
How to Change Product Key for SQL Server The Microsoft Evaluation Center brings you full-featured Microsoft product evaluation software available for downloads. We have downloaded from official website and install the product. Check all available SQL server version here: https://sqlserverbuilds.blogspot.com…
Convert or make SQL Server Named instance look like a Default instance Hi tech giants, today I have learn how to make a SQL server named instance look like a default instance. Recently I was trying to connect an application…
All of a sudden I received an email from the database owner – “pls share file growth if u have so that the sizing can be done better” We don’t have any mechanism or 3rd party tool that monitored such…