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…
Year: 2021
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…
2 min read
0
Make Named instance look like a Default instance
Convert or make SQL Server Named instance look like a Default instance Hi tech giants, today I have learn how…
3 min read
2
Find database growth size in SQL Server
All of a sudden I received an email from the database owner – “pls share file growth if u have…
3 min read
0
How to Configure MSSQL Backup Compression as the Default Option
Introduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups,…