2016-09-07
1,120 reads
Security
SQL Authentication Via AD Groups Part III: What About Orphaned Users?
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
2016-07-18
2,932 reads
2016-06-20
1,292 reads
2016-06-02
1,199 reads
2016-05-23
1,419 reads
2016-04-27
1,392 reads
2016-03-17
1,053 reads
2016-02-11
1,301 reads
Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,180 reads
2016-02-03
1,370 reads
Blogs
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
T-SQL Tuesday 185 - Produce a Video!
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Snapshot Replication: Pre-application script to check prerequisites
Is it possible to write a script that checks a subscriber's environment for prerequisites...
t-SQL help..
I have the following...anyone can point me the right direction to rewrite this code?...
install sql express
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers