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

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'”

SQL Server – v 2019 – CTP ( CTP 3.2 ) 

Background Returned to playing around with SQL Server 2019 Community Technology Preview ( CTP ) this week. Issues Ran into issues such as :- Client SQL Server Management Studio ( SSMS ) Engine SQL Server Engine Error :- Msg 155, Level 15, State 1, Line 61 .... is not a recognized... option   Client SSMS … Continue reading SQL Server – v 2019 – CTP ( CTP 3.2 ) 

SQL Server – Querying for OS Version

Background As SQL Server now runs on Linux it is likely a good idea to be able to determine the underlying OS that a specific instance is sitting on.   Choices Here are some choices for determining a targeted SQL Instance OS Version :- @@version sys.dm_os_host_info SQL Server Versions v2017 and above   System Function … Continue reading SQL Server – Querying for OS Version