Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These silos lead to ineffective decisions from incomplete data, wasted resources through redundant efforts, and missed...
2025-05-30 (first published: 2025-05-12)
411 reads
As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” (Amazon), organizations are often challenged with...
2025-05-28 (first published: 2025-05-06)
708 reads
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...
2025-05-28 (first published: 2025-05-14)
545 reads
The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when...
2025-05-28
107 reads
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET...
2025-05-28
144 reads
Wondering which database to tackle first? I’ve got the lowdown on the top free choices for anyone new to SQL, and I’ll tell you exactly why they’re stellar for...
2025-05-28
610 reads
SQL Server 2025 introduces a new compression algorithm, ZSTD (Zstandard), which can help with database backup performance. The implementation of ZSTD gives you more control over your backup performance...
2025-05-27
59 reads
Regarding managing databases in the cloud, security should never be an afterthought. That’s where Azure Vulnerability Assessments, officially named Microsoft Defender, come in—they help you spot weak spots in...
2025-05-26 (first published: 2025-05-07)
427 reads
The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this year in Wilmington, NC. I'll be speaking on Thursday, June 5, from 11:30 AM -12:20...
2025-05-26
17 reads
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index. No questions asked. Here’s the truth: if you’re doing this daily on indexes smaller than...
2025-05-26 (first published: 2025-05-14)
668 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers