Restore All Backups
SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED
ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'
2010-06-30 (first published: 2010-06-08)
2,825 reads
Scripts
2010-06-29 (first published: 2010-06-09)
1,168 reads
Finding Ratio between two numbers
This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.
2010-06-23 (first published: 2010-06-01)
2,227 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,420 reads
fn_getfiledetails - a replacement for xp_getfiledetails
As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...
2010-06-14 (first published: 2010-05-07)
3,606 reads
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,482 reads
A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-09 (first published: 2010-05-04)
1,859 reads
2010-06-09 (first published: 2008-05-20)
3,052 reads
SQL 2005 Disaster Recovery Scripts: To Setup and Remove Mirroring
Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise
2010-06-07 (first published: 2009-03-17)
2,627 reads
Job History with Timeline
Similar to many other Job History scripts, but unique in that it has a timeline.
2010-06-01 (first published: 2009-04-03)
3,321 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers