Time-Series Data Analysis with Apache Druid
Learn the basics of Apache Druid and how it can be used to ingest data into a data lake.
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points
Is MongoDB in use within your organization? The Flyway development team is adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey.
Using Notebooks in Azure Data Studio
Learn how to use the notebook feature of Azure Data Studio to keep a set of queries together with some documentation.
Does Management Care About the Database?
In the past, Steve hasn't often felt management considered databases to be important, but that is changing.
The Basics of Dynamic Data Masking - Step 1 of the Stairway to Dynamic Data Masking
Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and Peak-Allocation Pay Models
New solution allows developers and teams to “buy the base and rent the peak” when provisioning for variable workloads without wastage or performance tradeoffs
Something’s Up with Parallelism in Azure SQL DB Serverless
Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know how long it’s been this way – could even be since the launch of Azure SQL DB Serverless – but I just now noticed it while helping a client with a slow query.
Don't (Always) Be a Hero
When we need to be heroes in IT on a regular basis, that's a problem for Steve.
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
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 Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers