3 min read 0 Interview Questions MSSQL SQL Server sysadmin vs serveradmin OTI 31 August 2023 Introduction Managing a SQL Server environment involves various roles and responsibilities. Two key roles in this context are the “serveradmin”…
3 min read 0 Interview Questions MSSQL How to set Maximum Memory for SQL Server OTI 31 August 2023 One crucial aspect is setting the maximum memory for SQL Server. Recently one of my friend was asked this question…
3 min read 0 MSSQL Understanding SQL Server Permissions: GRANT vs. WITH GRANT OTI 31 August 2023 Introduction We’ve ever worked with SQL Server, we’ve probably encountered the need to manage permissions. Permissions control who can access…
8 min read 0 MSSQL Renaming a SQL Server Database in an Always On Availability Group OTI 11 August 2023 Introduction Renaming a database in SQL Server that is part of an Always On Availability Group requires careful planning and…
2 min read 0 MSSQL Troubleshooting and Issue Resolution Unable to open the “Properties” window for databases on the Managed Instance OTI 7 August 2023 Issue Definition Unable to open the “Properties” window for databases on the Managed Instance using SSMS. Getting error message. Error…