SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
Nuggets Of SQL Server Knowledge
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
One of the new features that I’m excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use Group Managed Service Accounts, or “gMSA” for short. …
Sometimes it becomes necessary to change the owner of a database. When a database is first created, SQL Server likes to set the owner of that database to the login …
Security and permissions are a big part of a DBA’s job, and being able to find out things such as who has elevated login permissions, or when the last time …
So, that title may be a little misleading to some. It is not meant as a blanket statement about all procedures and all permissions, but rather a specific situation that …
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.