ETL Performance Auditing - Part 2: Auditing Data Staging Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Backup and Restore Strategies in SQL Server – Part 2
In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.
Is Database Mirroring Causing The Transaction Log To Fill Up
In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.
Free SQL in the City Seminar Washington DC – Dec 5, 2014
SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Washington DC again this December. Learn how to build an efficient development and deployment process for your organization. Register for this free event.
Stop Relying on Cloud File Stores as a Backup Strategy
There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.
SSRS - Report for Stored Procedure with Parameters
You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
URL Safe or Not?
Comments posted to this topic are about the item URL Safe or Not?
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers