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 …
SQL Server Permissions Manager Updates – January 2019
I recently made some updates to my SQL Server Permissions Manager project on GitHub. These updates mainly consisted of bug fixes and documentation updates, although I did also add the …
Notes From A SQL 2017 Azure Install – Using Group Managed Service Accounts
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. …
SQL Scripts: How To Change The Owner Of A Database
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 …
SQL Scripts: How To Check Logins And Permissions
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 …
Encrypting Passwords Using EncryptByPassPhrase
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is part of a storing passwords blog series where we will examine …
Storing Passwords In A SQL Server Database
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is the first of a series of posts where we will …
Stored Procedures Ignore User’s Permissions
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 …