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,407 reads
Scripts
2011-05-23
329 reads
Query Active Directory to Display Login Information
Query Active Directory to get information on user logins.
2011-05-19 (first published: 2011-05-16)
3,890 reads
Backup all databases & check backups
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
2011-05-13 (first published: 2011-05-06)
3,151 reads
Show SQL authentication login information
View login information for all accounts that use SQL authentication.
2011-05-12 (first published: 2011-05-09)
2,974 reads
Find Last Day of the Month
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,434 reads
Create Database User
This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.
2011-05-05 (first published: 2011-04-28)
1,818 reads
Create INSERT statements from Excel
Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.
2011-05-02 (first published: 2009-02-21)
16,637 reads
Index Fragmentation for All Databases
Returns Top 25 fragmented indexes complete with full object name and index name.
2011-04-29 (first published: 2009-05-29)
10,020 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,364 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers