Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,257 reads
Scripts
Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,753 reads
2012-01-11 (first published: 2008-04-16)
5,186 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,470 reads
2012-01-09 (first published: 2007-11-13)
4,942 reads
2012-01-06 (first published: 2008-02-15)
7,331 reads
2012-01-05 (first published: 2011-12-09)
2,606 reads
Restore database from a device containing multiple backups
Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.
2012-01-04 (first published: 2011-12-13)
2,217 reads
Quick check SQL connection and process details with current SQL text
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,550 reads
SQL Agent Jobs Summary
The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.
2011-12-29 (first published: 2011-11-30)
2,198 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers