Capturing errors and auditing in Azure SQL DB
Logging is a necessity in the database world, well, the entire tech world. You need to know what is happening in and around your databases. It’s easy to setup...
2025-07-07
233 reads
Blog Posts
Cloud Database Security vs. On-Premises: Challenges, Tools, and Real-World Insights
☁️ Cloud vs. On-Premises Database Security: A Strategic Transformation The approach to securing databases has evolved significantly with the rise of cloud computing. In a traditional on-premises setup, organizations...
2025-07-07
12 reads
ColumnStore Indexes: The Secret to Fast SQL Queries
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
1,003 reads
Stepping into Event Streaming with Microsoft Fabric
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media logs, website user interactions, and financial transactions. So, working with streaming datasets can place you...
2025-07-07
174 reads
Upgrading SQL Server in a Container
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
354 reads
Sabbatical le Troisième: A Recharge Week
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
14 reads
SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
89 reads
AI Destroying Creativity or Creative Industry
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in the creative world. From music and film to fashion, literature, and visual arts, AI is...
2025-07-04
20 reads
DP-300 : How to Pass Azure Database Administrator Certification
As businesses increasingly migrate their databases to the cloud, the demand for skilled database administrators is skyrocketing. The DP-300: Administering Microsoft Azure SQL Solutions certification is designed for professionals...
2025-07-04
75 reads
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-07-04 (first published: 2025-06-19)
239 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers