SQL Server Patching – server won’t start
|

SQL Server Patching – server won’t start

At times, specific topics come together simultaneously. In this case, several emails were received from the Data Platform MVP distribution list, and various customer reports and suitable posts in other blogs were found on “how DatabaseMailUserRole stops your patching,” so a German contribution was made to this. It’s about a bug that has appeared in…

Which SQL user has got which role and access on my SQL Server – analysis of roles & rights

Which SQL user has got which role and access on my SQL Server – analysis of roles & rights

Analyzing SQL Server User Roles and Permissions: Who Has Access? We often receive inquiries from our customer service team regarding needing an overview of all configured SQL users and their permissions on an SQL Server. When acquiring new servers, relying solely on scripts from experts like Brent Ozar may not always suffice. To address this…