SQL Server Database Compatibility Levels
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
467 reads
Blog Posts
Understanding Zonal Redundancy in Azure SQL MI
Do you know what happens when you enable zonal redundancy for your SQL managed instance? Lets define it first (in the context of Business-Critical tier) – zonal redundancy is...
2025-07-16
92 reads
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from failure — and why most companies still underestimate what it really takes to turn strategy...
2025-07-15 (first published: 2025-07-14)
37 reads
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary...
2025-07-15
120 reads
Free Cloud Environment Setup: A Beginner’s Guide
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up your first cloud environment is a valuable skill, and you can begin without spending any...
2025-07-15
40 reads
SQL Server Best Practices
Many technologists dislike the term ‘Best Practice’ because what works for one environment might not work for another. I prefer the term ‘Industry Best Practice,’ prefaced with the caveat: ‘For...
2025-07-15
4 reads
The PASS Summit on Tour in the Netherlands
The PASS Summit goes on tour this year, with the final date the first few days of October in the Netherlands, Utrect to be exact. This is the first...
2025-07-15
46 reads
Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading
2025-07-14
453 reads
Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming how we live, work, and interact with technology. From personalized recommendations to AI-generated art, the...
2025-07-14 (first published: 2025-06-23)
404 reads
IPv4 vs IPv6 Explained: Why IPv6 Still Hasn’t Replaced IPv4
The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...
2025-07-14
65 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers