Audit SQL Logins - Updated
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server.
Update to Simon Facer's script.
2011-05-23 (first published: 2007-09-25)
13,373 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
Replace OLEDB source editor task with a powershell script
I want to replace all the oledb source editors as shown below with powershell...
Sending SQL Query Result via an Email in ADF
New to Azure Data Factory, and as a starting point, we're trying to see...
AlwaysOn Standard o Enterprise edition
Hi everyone, I need advice from the experts, this is the structure I created...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers