digital.aaron questions

digital.aaron answers

• What is the difference between being db_owner vs. db_datareader / db_datawriter?
• SQL Query to JSON
• How do I execute an If statement inside a CTE
• SSIS - move only the files names returned in SQL command
• Dynamically change XSD filepath in Crystal Reports
• Conditional JOIN based on column value
• migrating ssdt project from visual studio 2012 to 2017 cdc source not opening
• Data profiling Task - custom Profile Request
• How to parse nested JSON array using SQL Server
• How do you OPENJSON on Arrays of Arrays