2013-04-17 (first published: 2013-04-03)
1,510 reads
Scripts
Restore Latest Backup with Powershell
Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.
2013-04-16 (first published: 2013-03-30)
1,781 reads
Search for an object across multiple databases on a server.
There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.
2013-04-15 (first published: 2012-08-23)
2,880 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,496 reads
2013-04-05 (first published: 2009-03-27)
4,646 reads
2013-04-03 (first published: 2013-03-08)
1,736 reads
2013-04-02 (first published: 2008-09-11)
15,425 reads
2013-04-01 (first published: 2013-03-08)
1,829 reads
2013-03-29 (first published: 2013-03-08)
1,461 reads
Backup history details EMAIL (past 24 hours) in HTML format
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,422 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