Flexable Rate Recursion
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-15 (first published: 2010-10-13)
602 reads
Scripts
T-SQL generator for sp_configure
The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
2010-10-14 (first published: 2010-10-05)
1,392 reads
A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,410 reads
Transcation Log space monitoring
This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value
2010-10-05 (first published: 2010-10-03)
3,510 reads
2010-10-04 (first published: 2010-09-29)
2,943 reads
List all columns in server
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,591 reads
2010-09-29 (first published: 2010-09-28)
1,644 reads
After Restoring MSDB perform the following two steps
This script has two essential Steps after restoring MSDB
2010-09-21 (first published: 2010-09-20)
2,343 reads
Way to Check Multiple LIKE without dynamic SQL
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,820 reads
Retreive the Schema of a Stored Procedure or Function
This script shows you code that retrives schema of a routine (Stored procedure or a function).
2010-09-09 (first published: 2010-09-04)
2,004 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers