SQLServerCentral Editorial

A Matter of Degree

So we had an interesting debate on college degrees and how much weight to give them in an interview recently. Near the end someone mentioned they were curious what types of degrees people had as well as those the worked with. There were some interesting comments, and I decided that this might make a nice Friday poll.

SQLServerCentral Article

Designing Cross Database Queries

As systems get bigger, servers consolidated, and SQL Server back ends more types of applications, the need for cross database queries for reports, updates, and more will continue to grow. Steve Jones looks at a few ways that you can design your linkages and talks about why he prefers one over the other.

Blogs

Looking Back at the Redgate 2026 Company Kickoff

By

Last week I spent a few days in Cambridge, UK for the Redgate Company...

Using AI for Git Hooks

By

Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....

Flyway Tips: AI Helps with Commit Messages

By

At Redgate, we’re experimenting with how AI can help developers and DBAs become better...

Read the latest Blogs

Forums

SQL Agent job running gMSA cannot backup to NAS target

By DataMatt43

I'm running a group MSA for the database engine and SQL Agent in a...

sys.query_store_query question

By as_1234

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

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding Strings

Visit the forum

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