SP_DBA_AUTOTRANS_DUMP_LOG
Purpose : This routine will dump the transaction logs based on the percentage on how full the transaction logs are based on parmeter from the logthres table […]
2003-08-01
259 reads
sp_dba_spacealert_dmo.vbs
This vbscript is used to alert and email receipients on Filegroup space usageOuput: '% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroupThe process takes three arguments - SqlserverName , Threshold for percentage of available space to check ,Mininum MaxFileSize to checkExecute the script either from the command line or schedule the script via […]
2003-08-01
354 reads
Blogs
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....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers