The Third Sabbatical
I can’t believe I’ve been at Redgate long enough to get a third sabbatical. I’ve very lucky to have this job, still enjoy it, and get the benefit. I’ve...
2025-06-13
3 reads
Blog Posts
T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll...
2025-06-13 (first published: 2025-06-10)
19 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)
244 reads
India-US Tariff War: Is the Indian IT Sector at Risk?
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly imposed U.S. tariffs—such as the 26% duty on select Indian exports—don’t directly target India’s IT...
2025-06-12
8 reads
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
6 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
38 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
54 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)
448 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)
450 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
84 reads
Blogs
Better Trigger Design: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
SQL Server in the Cloud – Are DBAs Still Needed?
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Forums
Dropping a PK constraint.
I will have to test this next week, but will not have a chance...
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers