New Azure VMs that perform close to on-prem servers?!
Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...
2025-06-12
20 reads
Blog Posts
Save BIG on Microsoft Azure Certification – Up to 100% Off!
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule and Appear for Azure Certification Exams Microsoft Azure Certification Corporate Discounts: How to Save Up...
2025-06-12
70 reads
Free Webinar – Build a data warehouse on Azure Data Platform for $150
I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract,...
2025-06-11
81 reads
Modifying a Trigger to Capture More Info: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to...
2025-06-11
87 reads
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)
521 reads
SQL Server Login Types: Knowing the Difference Really Matters
If your SQL Server has both SQL and Windows logins and you’re not sure why, you’re not alone. Many IT teams without a dedicated DBA bump into this sooner...
2025-06-11 (first published: 2025-05-21)
544 reads
T-SQL Tuesday #187–Solving Problems
This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he...
2025-06-10
110 reads
KDA: Echoes of Deception - Case 3
The crime spree in Digitown is not ending. This time 20 cars have been stolen and we need to find where they’re stored.
The problem
This is the abridged case description....
2025-06-09 (first published: 2025-05-16)
315 reads
Monday Monitor Tips: Customizing Data Retention
One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross...
2025-06-09
46 reads
SQL Server 2025: Enterprise AI Without the Learning Curve
With the release of SQL Server 2025, Microsoft is firmly positioning its flagship database platform as an enterprise-ready AI solution. Having spent time with the preview builds and working...
2025-06-09 (first published: 2025-05-19)
541 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers