2015-05-01 (first published: 2013-08-13)
3,777 reads
Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,227 reads
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,649 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
673 reads
2011-09-15 (first published: 2011-09-05)
2,918 reads
2011-08-05 (first published: 2011-07-23)
2,230 reads
A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,383 reads
Blogs
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Forums
Azure Database Watcher Monitoring
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Stored Procedure Generation Script
Comments posted to this topic are about the item Stored Procedure Generation Script
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers