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
Export/import relational data across SQL Servers
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-03 (first published: 2009-06-22)
1,580 reads
Estimating the table size...
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-02 (first published: 2009-06-19)
1,811 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,361 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,214 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)
606 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,218 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,065 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers