database weekly

SQLServerCentral Editorial

Of Hedgehogs and Database Design

  • Editorial

One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]

(2)

You rated this post out of 5. Change rating

2020-08-22

370 reads

SQLServerCentral Editorial

What is Azure SQL Database Serverless?

  • Editorial

I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]

You rated this post out of 5. Change rating

2020-06-13

578 reads

SQLServerCentral Editorial

Bad Managers

  • Editorial

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

(1)

You rated this post out of 5. Change rating

2020-05-16

193 reads

Blogs

The Book of Redgate: Spread across the world

By

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Merry Christmas

By

Today is Christmas and while I do not expect anybody to actual be reading...

Self-Hosting a Photo Server the Whole Family Can Use

By

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Read the latest Blogs

Forums

SQL Server 2025 Backup Compression Algorithm

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Backup Compression...

The Large Encoded Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Large Encoded Value

The Side Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Side Job

Visit the forum

Question of the Day

The Large Encoded Value

I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?

See possible answers