Andrea questions

Andrea answers

• Getting list of server instances installed reliably
• Create foreign key constraint on JSON column
• Multiple column pivot
• Parameterise values for OFFSET and FETCH NEXT
• Pivot using Dynamic SQL statement
• Reading JSON array as one of the SQL table column
• Config file for c# windows service
• OPENJSON expanded with other columns
• Convert images which have the same names but different extensions
• Notepad++ macro in menu bar with icon