3 min read
0
SQL Server sysadmin vs serveradmin
Introduction Managing a SQL Server environment involves various roles and responsibilities. Two key roles in this context are the “serveradmin”…
Month: August 2023
3 min read
0
How to set Maximum Memory for SQL Server
One crucial aspect is setting the maximum memory for SQL Server. Recently one of my friend was asked this question…
3 min read
0
Understanding SQL Server Permissions: GRANT vs. WITH GRANT
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
Renaming a SQL Server Database in an Always On Availability Group
Introduction Renaming a database in SQL Server that is part of an Always On Availability Group requires careful planning and…
2 min read
0
Unable to open the “Properties” window for databases on the Managed Instance
Issue Definition Unable to open the “Properties” window for databases on the Managed Instance using SSMS. Getting error message. Error…