View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,540 reads
Scripts
Change Monitor in SQL Server 2005
Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.
2010-05-14 (first published: 2009-06-24)
1,781 reads
2010-05-13 (first published: 2009-07-01)
3,903 reads
2010-05-12 (first published: 2009-07-09)
2,977 reads
Restore Database from network location
When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.
2010-05-11 (first published: 2009-07-11)
3,157 reads
The Complete SQL Server 2005 Permissions Report
The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.
2010-05-10 (first published: 2009-07-16)
7,970 reads
2010-05-07 (first published: 2009-07-31)
3,362 reads
Poor Man's Table Difference
Given a tablename and other parameters, this procedure will return a table made of foreign keys and a checksum for each
2010-05-06 (first published: 2010-05-02)
2,038 reads
Convert seconds to a timestring
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
2010-05-05 (first published: 2010-04-28)
1,481 reads
2010-05-03 (first published: 2010-04-23)
2,013 reads
Blogs
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...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers