1 DBA's Professional Blog
Every Database has a DBO or database owner set. Sometimes the owner is invalid, while most of the time the DBO is perfectly normal. It is easy to ignore whether a valid DBO is set or not. And then something breaks and you have to validate it. This article addresses the easy fix to validate the DBO.
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of SSCM.
This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a security group to grant a bunch of people the same sets of permissions.
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM reports working properly within Report Manager (via SSRS), the reports would fail in CRM.
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are greeted with the following error message.
Cannot connect to WMI provider. You do not have permission or the server is unreachable.
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way too much access.
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.