sp_GetBackupInfo
This will report all backup activity for all databases, sorted by date, so you see the last backup activity first. You can filter this one by a db name as well, and only see the backup info for said database.
2002-03-07
803 reads
TJay Belt
sp_GetLastBackup
This will get the last date a database was backuped. It allows you to report this date on all databases on a server, or pass in a db name, and it'll report the date that db was last backed up
2002-03-07
443 reads
spAddField
spAddField is the proc I use to add all fields to the db in our upgrade scripts. With this proc, you pass it the tablename, fieldname, datatype, and null or not null. This will call spGetFieldsExists and see if the fields exists or not. If it does, spAddField will drop that column. Then it readds […]
2002-03-05
218 reads
spDropField
spDropField does exactly the opposite of spAddField. It checks for existence, then drops it, if it does exist.
2002-03-05
143 reads
spFindTableInfo
spFindTableInfo is a great proc for finding info about your database. It will accept parameters like tablename, fieldname, size, datatype. So you can run it with no params, and it'll report every table, every field in those tables, and the size, datatype and whether its nullable or not. You can filter it by Table name […]
2002-03-05
379 reads
spGetFieldsExists
spGetFieldsExists takes a tablename and a field name, and checks if that field exists in that table.It simply returns 0 or 1 (false or true).
2002-03-05
169 reads
Blogs
Capturing errors and auditing in Azure SQL DB
Logging is a necessity in the database world, well, the entire tech world. You...
Stepping into Event Streaming with Microsoft Fabric
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
Sabbatical le Troisième: A Recharge Week
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
Forums
FARE Labs is a proficiency testing lab
India's top proficiency testing laboratory facility is Fare Labs. Using particular metrics or evaluations,...
The Mindset of a Database Administrator: A Love Letter to Risk Aversion
Comments posted to this topic are about the item The Mindset of a Database...
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers