List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
45,230 reads
Scripts
Get all user def table info
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,694 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
17,022 reads
Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
2013-12-24 (first published: 2007-11-06)
12,498 reads
2013-12-19 (first published: 2007-08-27)
20,829 reads
SQL 2005 IndexDefrag solution
Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night
2013-12-17 (first published: 2008-05-07)
3,663 reads
Scripting SQL jobs using PowerShell
Using powershell to create different sql scripts in different files.
2013-12-13 (first published: 2012-04-19)
2,919 reads
How we can move the login which has Sysadmin role.
We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.
2013-12-09 (first published: 2013-11-29)
1,030 reads
2013-12-06 (first published: 2011-01-31)
4,804 reads
Find all Job Relationships with SSIS Config files
Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.
2013-12-05 (first published: 2011-03-02)
1,736 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers