This SQL Server 2025 cheat sheet puts the T-SQL I use every day on four printable pages. Every query ran on SQL Server 2025 first, and all the scripts are in the post. It covers joins, window functions, regular expressions, JSON, indexes, backups and SSMS shortcuts.
Cleaning Currency Strings Into decimal Values
Convert currency strings into decimal amounts using known symbols, explicit parsing cultures, conversion checks, and rejection evidence.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
SQL SERVER – T-SQL Fortune Cookies
Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China?
SQL SERVER – Fibonacci Series with T-SQL
What’s fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane.
SQL SERVER – How to Convert Month Number to Month Name
Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.
SQL SERVER – Comparing LIKE vs LEFT for Column Comparisons
Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.