SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Background Let us upgrade our Microsoft SQL Server v2017 running on Linux. We will be upgrading it to v2019/RC1. Outline Repositories Current Repository List Current Repository files Map Repository Files to Repositories Update Repository Add Repository File for MS SQL Server v2019 Upgrade SQL Server Upgrade SQL Server - Engine Restart SQL Server Service Validate … Continue reading SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Background Wanted to give a quick update on the Azure Data Studio Extension, sqlops-spexecutesql-to-sql. Lineage Azure Data Studio – Extension – "sqlops-spexecutesql-to-sql" Original Post Date Posted :- 2019-August-24th Link Bug Report Outline Filed a bug. The code is on GitHub and path way to filling a bug it to : Sojourn to GitHub Access Pejman … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

Background Working on a script, but noticed an error when I tried to sort the data using the String_Agg within group clause. Code Let us reproduce using a sample data set. SQL Sample -01 SQL Output Sample -02 Outline If one reviews our output, one will notice that the cities are listed based on the … Continue reading Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

Transact SQL – JSON Functions – OPENJSON

Background The OpenJSON function allows us to shred a JSON Object into relational rows. Legend Here are earlier posts on Transact SQL & JSON :- Transact SQL – JSON Functions – JSON_VALUE & JSON_QUERY Link JSON Data Code Declare Table Variable & Add data SQL Output Queries Query -01 Outline In our first example, we … Continue reading Transact SQL – JSON Functions – OPENJSON

Transact SQL – JSON Functions – JSON_VALUE & JSON_QUERY

Background Whenever I see JSON mentioned I tighten up a bit, knowing it is one more thing to learn, and I just move on. Transact SQL Let us address how to use a couple of JSON Functions in Transact SQL. VALUE & QUERY Both functions are the same outside of the fact that one returns … Continue reading Transact SQL – JSON Functions – JSON_VALUE & JSON_QUERY