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,538 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,878 reads
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
2025-05-19
5,602 reads
2025-02-14 (first published: 2025-02-12)
929 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 Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Comments posted to this topic are about the item Vector Search in SQL Server...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers