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,237 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,695 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,024 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,501 reads
2013-12-19 (first published: 2007-08-27)
20,837 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,666 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,923 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
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers