External Article

Consuming hierarchical JSON documents in SQL Server using OpenJSON

  • Article

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.


3,562 reads

Technical Article

RE: Using Fetch--Help

  • Reply

Shelley,Frank is asking for a post of the table structures involved in the operation you're trying to perform... that way we might be able to find a non-cursor-based solution.SJT


Technical Article

RE: How about "None of the above" for the QOD on 10/20

  • Reply

If you are referring to the question:   Tab_A      Tab_B Id_A  Ds_A   Id_B Ds_B ----  -----  ---- ----       1   A1     2    B1   2   A2     3    B2   3   A3     4    B3 Select Id_A,Id_B,Ds_A,Ds_B from Tab_A    Join Tab_B      On Id_A = Id_B I would completely agree that none of the available answers is […]


Technical Article

RE: restoring a backupdevice on another machine

  • Reply

Solution:First check if the backupdevice exists on the machine (which it shouldn't, because the restore is taking place on a machine other than the one that the backup was done on.)oBackupDeviceCheck = CreateObject("sqldmo.BackupDevice")   For Each oBackupDeviceCheck In oServer.BackupDevices     If oBackupDeviceCheck.Name = BackupFileName Then         blnBackupDeviceExists = True         Exit For     End If Next […]


Technical Article


  • Topic

I', having a problem in my backup.This is the message:BackupDiskFile::CreateMedia: Backup device 'S:\Backup\Terca-Feira\BACKUP-TERCA-FEIRA.BAK' failed to create. Operating system error = 32(The process cannot access the file because it is being used by another process.). Dos someone knows what kind of error is this?? Regards,Felipe


4 reads


Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs



By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...



am getting the following when run report what can I do to fix this

This code works, but am requesting help with the code.

By Doug

Hello everyone.  I don't post here often even though I am constantly on the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers