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,253 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,751 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,456 reads
2012-01-09 (first published: 2007-11-13)
4,938 reads
2012-01-06 (first published: 2008-02-15)
7,329 reads
2012-01-05 (first published: 2011-12-09)
2,602 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,215 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,548 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,195 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers