This script demonstrates step by step how to implement a dropped objects tracking flow. Important limitation to consider: The stored state of a dropped object is based on the most recent available snapshot and not necessarily on the state of the object immediately before it was dropped. The accuracy of the stored information depends on […]
2026-08-31
7 reads
The following script creates a procedure that returns a specified number of random columns and rows from a specified table or view. The number of columns and rows is determined by the @NumberOfColumns and @Rows parameters. The @RandomColumnOrder parameter specifies whether the selected columns are returned in random order or sorted by their ordinal position […]
2026-08-31
7 reads
This scripts creates a view containing data type information for columns in user-defined tables and views. It provides an overview of the data types in use and can help identify opportunities for data type optimization and standardization. The data types are formatted as they appear in Object Explorer in SSMS. For example, sysname is displayed […]
2026-08-25
31 reads
2025-12-29 (first published: 2025-12-25)
584 reads
This script will save your database permissions into a table.
2025-12-29
568 reads
This script is used to generate the output file as CSV format for list of server.
2025-11-03 (first published: 2025-10-20)
968 reads
The script gets the database health check whether synchronized or not from the primary or secondary. This code needs to scheduled through as a job to get alerts.
2025-10-20 (first published: 2025-10-13)
754 reads
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
2,253 reads
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025-09-12 (first published: 2025-09-04)
1,045 reads
This script will help DBAs to find inefficient indexes and duplicate indexes, by providing the following metrics: usage statistics, fragmentation levels, size, and index duplication analysis.
2025-09-10 (first published: 2025-06-27)
928 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Telp/WA 62 8218200233 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta...
Telp/WA 62 8218200174 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec....
Hi guys and gals, I've created a system that automatically allows you to "generate"...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers