Jonathan Stokes


Blogs

Introducing system-versioned ledger tables

By

As long-time readers of this blog know, I’m a big fan of temporal tables,...

Daily Coping 15 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My upcoming Online Trainings and Speaking Engagements

By

Over the next few weeks I have again some online training and speaking engagements...

Read the latest Blogs

Forums

Subselect / Group by - Error multiple values

By bent

Hi there! I need to update n attribute in the table "rm_request" by summing...

Query with a column containing JSON text

By Roust_m

Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last...

Parsing XML data

By maijoe

Hi all, I need help to extract data from a xml field. My data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers