Our Tech Ideas | Great minds discuss ideas!
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…
Read FullChange 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…
Read FullThings 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…
Read FullHi, 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…
Read FullHow 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…
Read FullConvert 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…
Read FullAll 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…
Read FullIntroduction In Microsoft SQL Server, backup compression is a powerful feature that can significantly reduce the size of database backups, thereby saving storage space and improving backup and restore performance.…
Read Full
