Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script
Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, based on use of Red Gate's SQL Backup and SQL Multi Script.
Measure TSQL Statement Performance
Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
The In-House Expert - iPod
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
The In-House Expert - MP3
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
The In-House Expert - WMV
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
A Pay Raise
There's a shortage of IT workers, which should lead to a pay raise for some people. Steve Jones takes a look at some recent news about IT salaries.
A Reporting System Architecture
This article describes one method of implementing a reporting system in SQL Server 2005
SUN DB
The purchase of MySQL by Sun is an interesting move by Sun, which has pondered it's own database product.
Using Data Warehouse for CRM
Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system.
Blogs
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers