Uninstall PolyBase from SQL Server
If you have SQL Server 2019 or SQL Server 2022 installed with PolyBase and you try to install SQL Server 2025, it will fail during...
2025-05-24
9 reads
Blog Posts
Advice I Like: Take Two Trips
If you have any doubt about being able to carry a load in one trip, do yourself a huge favor and make two trips – from Excellent Advice for...
2025-05-23
24 reads
DevOps Devour Hour Slides
Here are the slides from my talk today at the Redgate NYC Devour Hour: Architecting Zero Downtime Deployments.pptx The Repo is here: https://github.com/way0utwest/ZeroDowntime An interesting question on feature toggles:...
2025-05-23
36 reads
Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home Lab
Back in 2018, I wrote a blog post about my Home Lab environment, which I had built around VMware vSphere to showcase various SQL Server workloads and demonstrate how...
2025-05-23 (first published: 2025-05-12)
322 reads
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0) was announced, I was a few months in at the SQL Docs team, and had...
2025-05-23 (first published: 2025-05-19)
569 reads
Do Yourself a Favor, Check Out Woodler
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love visiting Poland… Anyway… Great event. Worth your time to attend, and if you’re a speaker,...
2025-05-22
45 reads
Microsoft Build announcements
Once again there were a number of Microsoft Build announcements related to data and AI, and some were very impressive. Below are my favorites. Everything announced at Build can...
2025-05-22
46 reads
AI in the DBeaver Query Editor
You know I had to do it as soon as I found it was possible. Yes, I installed and enabled AI in the DBeaver Query Editor so I can...
2025-05-21 (first published: 2025-05-05)
261 reads
Checking Myself with GenAI
I had a suggestion from somone on a place where AI helps them and I decided to try it. The person had an AI summarize their work and if...
2025-05-21
29 reads
Redgate SQL Prompt in SSMS 21
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it, the new version of SSMS is now generally available. It’s a big new version and...
2025-05-21
8,126 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers