Query Hints and Estimated Plans
I’m working on an update to my Query Performance Tuning book for SQL Server 2025 and I found myself wondering, will a query hint be immediately apparent in an...
2025-06-11 (first published: 2025-05-26)
524 reads
SQL Inventory Dashboards: From Raw Data to Real Insight
Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost you. Good news: an SQL-powered product inventory dashboard puts you firmly in control of stock...
2025-05-25
253 reads
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
140 reads
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're in the right place. I’ve pulled together a list of the absolute best free SQL...
2025-05-24 (first published: 2025-05-23)
1,102 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
45 reads
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
33 reads
Using a stored procedure as a source for PowerBI Paginated reports
If the reports that you are building do not need to be interactive, you can use Microsoft Paginated Reports (or SSRS). One of the benefits of a paginated…
2025-05-22
1 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
67 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
65 reads
Vertically scaling SQL Server online in Kubernetes
One of the new features in Kubernetes v1.33 is the ability to resize CPU and memory resources for containers online, aka without having to recreate the pod the container...
2025-06-13 (first published: 2025-05-22)
295 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers