2009-07-08 (first published: 2009-06-25)
1,186 reads
Scripts
Drive space checking monitoring procedure
This procedure can used to monitor the disk drive space details and we can set threshold and it can be enhanced to send an alert incase of reaching the threshold.
2009-07-07 (first published: 2009-06-23)
2,208 reads
2009-07-06 (first published: 2009-06-23)
4,960 reads
Estimating the table size...
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,809 reads
SQL 2000: Track Stored Procedure Changes
SQL Server 2000 does not log the procedures modified using ALTER statement. Here's the script to find out the same.
2009-07-06 (first published: 2009-03-02)
1,300 reads
Script to find latest backups for all databases
If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.
2009-07-01 (first published: 2009-06-19)
2,360 reads
Splitting the string with unique delimiter.
The statement is splited into columns according the delimter and it has been captured in the table datatype.
2009-06-29 (first published: 2009-06-22)
1,213 reads
The Automated DBA: Batch Database File Grower - SQL 2000 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-25 (first published: 2009-06-08)
605 reads
The Automated DBA: Batch Database File Grower - SQL 2005 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-23 (first published: 2009-06-08)
1,217 reads
The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-22 (first published: 2009-06-08)
1,064 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers