json_object and json_array Functions SQL Server 2022 Tutorial
Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.
2023-02-20
Articles
2023-02-17 (first published: 2023-02-10)
11,410 reads
SQL Server 2014 Build List
A list of builds for SQL Server 2014, through CU4 for SP2 and CU11 for SP1.
2023-02-17 (first published: 2015-02-23)
19,458 reads
Join us in our castle at SQL Bits, March 15-18
SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.
2023-02-17
Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam
This resource includes several links to related to...
2023-02-17
2023-02-15
4,314 reads
Getting Started with Flyway Migrations on Oracle
A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial version of the database then filling it with development data.
2023-02-15
Manage Data Over Time with SQL Server MERGE Statement
Once data is in a table it needs to be maintained....
2023-02-15
What is ChatGPT – Is it the rise of the Skynet era?
An interesting conversation with the ChatGPT artif...
2023-02-13
13,287 reads
An Introduction to Assessing Normal Distribution with Python
This tip illustrates graphical and statistical tec...
2023-02-13
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers