When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.
2026-05-20
Ever just need a quick visualization of some numbers to get a rough idea of the trend, like this
2026-04-15
SQL Server Management Studio keeps adding features, but unless you look you probably don’t notice. In this article, we look at the new Query Hint Recommendation Tool in SSMS 2022 and how this can be used.
2026-03-18
SSMS 22 has several new features. Is there a compilation list of the new features? How will these features help me as a SQL Server professional?
2026-03-13
Beginning with SQL Server Management Studio 21, Microsoft stopped providing the direct download package/binaries to install SSMS, instead it just downloads the SSMS installer. This installer then starts the installation of SSMS and downloads what is needed to install SSMS. Sometimes there may be a need to do an offline installation where you do not have access to the internet. In this article, we walk through the steps to do an offline install of SSMS.
2026-02-27
2025-12-22
10,757 reads
Overview In SQL Server, indexing is a technique used to improve the performance of queries by reducing the amount of data that SQL Server needs to scan. You can think of it like a table of contents in a book—it helps SQL Server find data more quickly. In this article, we will cover the following […]
2025-09-02 (first published: 2025-08-07)
4,999 reads
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
2025-05-19
5,663 reads
2025-02-14 (first published: 2025-02-12)
947 reads
Let me cut to the chase. If you are like me, you may have been searching for: How to turn on Dark Mode in SSMS V21. Searching for that very thing today inspired me to write this blog to help others do the same thing because I couldn’t seem to find an easy answer.
2025-02-10
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers