3 min read 2 MSSQL Database stuck in Mirroring, Disconnected / In Recovery OTI 23 November 2021 Mirror database stuck in the state of ‘Mirroring, Disconnected / In Recovery’ We have an interesting situation after configuring a…
2 min read 0 MSSQL Change Default TCP Port in SQL Server OTI 22 September 2021 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 MSSQL Things You Must Do After Installing SQL Server OTI 13 July 2021 Things You Must Do After Installing SQL Server Rolling out SQL Servers is a key task for DBAs. While for…
2 min read 2 MSSQL Find database size when it is offline OTI 1 July 2021 Hi, Tech Giants! What new to me today? Yeah, We did a SQL Server migration activity or we can say…
2 min read 0 MSSQL Auto-open new query window in SSMS OTI 30 June 2021 How to Change Product Key for SQL Server The Microsoft Evaluation Center brings you full-featured Microsoft product evaluation software available…
2 min read 0 MSSQL Make Named instance look like a Default instance OTI 29 June 2021 Convert or make SQL Server Named instance look like a Default instance Hi tech giants, today I have learn how…
3 min read 2 MSSQL Find database growth size in SQL Server OTI 28 June 2021 All of a sudden I received an email from the database owner – “pls share file growth if u have…
3 min read 0 MSSQL How to Configure MSSQL Backup Compression as the Default Option OTI 28 February 2021 Introduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups,…