Script DB Level Permissions v4.5
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
1,759 reads
login
2019-04-22
944 reads
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
5,685 reads
Instance wide script to add user (the 4th way)
The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
592 reads
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
SUM multiple tables GROUP BY column
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
SUM multiple tables GROUP BY column
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
Interesting bug in SQL 2016 CHOOSE
While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...
Ask SSC