What are Schemas for? All of you are familiar with the default and built-in schema "dbo". When you create an object without a schema, "dbo" becomes the schema for the object. Generally, it is NOT considered a good practice from a manageability or security perspective to have everything owned by "dbo". The alternative is to … Continue reading SQL Server: Time To Switch Schema Of All Objects Away From “dbo”
Permissions are complex! Permissions management is not easy. You have a lot to deal with Direct user privileges via grants Privileges to AD Group login of which user is part of User could be part of multiple AD groups which have a login on the instance Privileges granted to the role that user is in … Continue reading SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!
I cannot imagine a life without PowerShell now. You would agreee after you find out why. This is what I had to do today. The very real problem: I have a list of about 30 servers. I need to add an AD group name to the local adminstrators group on all 30 servers Create a … Continue reading Using PowerShell – Add user or group to local Administrators group in Windows + Create SQL Server Login