Detect and Alert DBA of Blocking SPIDS
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,214 reads
Scripts
Script to obtain datadictionary from a SQL2000 db
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,127 reads
2001-08-26
1,412 reads
2001-08-22
405 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
550 reads
hx_dbMaintancePlans
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
380 reads
2001-08-22
724 reads
hx_GetPKLessTables
Returns a list of table names from the current database Which do not have primary keys assigned.
2001-08-22
425 reads
2001-08-22
568 reads
2001-08-22
726 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers