Add User to SQL Server Database Role with PowerShell and Quickly Creating Test Users
There is a newer up to date version of this post here using the dbatools module and the sqlserver module
Rob Sewell
Rob was a SQL Server DBA.
Now he just helps people with Powershell, Azure, Automation, and Data.
He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK user group and PSConfEU organiser. One of the Admins for Data Saturdays https://datasaturdays.com
He is a proud supporter of the Data and Powershell communities.
He has a fabulous beard
Recent Posts
Creating SQL User and adding to Server Role with PowerShell
Another post in the PowerShell Box of Tricks series.
Creating a Windows User and adding to a SQL Server Role with PowerShell
Another post in the PowerShell Box of Tricks series. In a previous post Checking SQL Server User Role Membership we showed how to check which roles users wer...
Displaying the Windows Event Log with PowerShell
The latest post in the PowerShell Box of tricks series is here.
Showing and Killing SQL Server Processes with PowerShell
Another post in the PowerShell Box of Tricks series. There are much better ways of doing this I admit but as you can do it with PowerShell I created a functi...