The Influence of the Cloud
This Friday Steve Jones is talking clouds. In the next year, will the cloud influence your job or will it be a fad for you?
Row Count Plus Transformation
As the name suggests we have taken the current Row Count Transform that is provided by Microsoft in the Integration Services toolbox and we have recreated the functionality and extended upon it. There are two things about the current version that we thought could do with cleaning up Lack of a custom UI You have to type the variable name yourself In the Row Count Plus Transformation we solve these issues for you.
Tell Us What You Think
Red Gate needs your help! Fill in our quick survey to help us improve our products – as a thank-you, you'll have the chance to win a Kindle Touch.
Marketing Data is Exploding
The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.
SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
Marcin Policht explores a method of running SSIS packages that relies on the dtexec.exe utility.
Learning C
As we use computers more and more, and more people must develop algorithms or simple programs, Steve Jones says everyone should learn C. Perhaps they should learn SQL as well.
Red Gate’s new custom metrics site - with a little help from our friends
With contributions from MVPs and the SQL Server community, the SQL Monitor team at Red Gate has put together a custom metrics site, SQL Monitor Metrics, to accompany the release of SQL Monitor 3.2. The site hosts T-SQL scripts which can be imported directly to SQL Monitor for custom metric monitoring.
Implement Continuous Integration In Your Software Project
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
PASS Data Architecture VC presents Louis Davidson on Designing for Common Problems in SQL Server
On Thursday August 16th 12PM noon Central, Louis Davidson will do a design and code review of several common patterns of solving problems that a typical programmer will come up against in SQL Server.
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