JSON_CONTAINS checks whether a JSON document holds a value at a path, including inside an array. This post tests it on SQL Server 2025: the json data type it needs, numbers versus text, case, NULL results and the older OPENJSON way.
SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS
After a fresh SQL Server 2014 install, CTRL + R no longer hid the results pane in SSMS. These keyboard option steps got my shortcut working again.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2
Harsh improved the identity query from Part 1 so it also works when seed values or increment values are not 1. Here is his script.
SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043
John Sterrett shows how the suspect pages table helps with detecting corruption, a tip worth learning even if your database has never been corrupted.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype
Mark Hickin improved my old query, so it now shows seed, increment and current identity column value along with the max value of the datatype.
SQL SERVER – Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified
Error 7202 Could not find server in sys.servers shows up when you restore a database that uses a linked server. A quick linked server script fixes it.
SQL Authority News – Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog
My 12th book, Secret Tool Box of Successful Bloggers, shares 52 tips to build a high traffic, top ranking blog, based on what I learned here.