What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.
ISJSON Type Constraints: Validate the Top-Level Value
ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.
Storing and Querying Locations in SQL Server
Work with spatial data in SQL Server using geography, geometry, matching SRIDs, distance queries, and an index designed for location searches.
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
After reading Jonathan Kehayias on Extended Events, I added them to my performance tuning course. An introduction, with a way to find long running queries.
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
Error 4214: BACKUP LOG cannot be performed because there is no current database backup. Take one full backup first, and the log backup will work.
SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase
Error 8501 says MSDTC on server is unavailable, often while configuring replication. Start the Distributed Transaction Coordinator service to fix it.
datetime: Read Its Fractional-Second Rounding
datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.