Senior Cloud Solution Architect @Microsoft, Microsoft Certified Trainer (MCT), SQL Skills Blackbelt, 5X Fantasy Baseball Champion, and Reader of Books.
SQL Server evolved from blocking locks to row-versioning. Find out how #SQLServer2025 using Optimized Locking allows for higher concurrency and better scalability. https://t.co/lbki1WAp1M
A search condition is considered SARGable (Search ARGument ABLE) when SQL Server can use an index to efficiently locate rows. So, ask not what an index can do for you, but what you can do for your index. #SQLServer#SQL#Sargable https://t.co/ll5UJsDL9I
SQL Server migrations have become significantly easier with the introduction of the new โMigrate SQL Serverโ experience in SSMS 22.5 or later. This unified, guided, end-to-end flow combines assessment, migration, and modernization into one streamlined process. https://t.co/oXpZ5aYf8W
Data rarely arrives in perfect condition. Typos, regional spelling differences, and inconsistent formats make exact matching unreliable in real-world scenarios. Thatโs where similarity matching comes in; and #SQLServer2025 introduces powerful built-in functions to handle it directly in T-SQL. https://t.co/iK0AMytvwP