Piotr Palka questions

Piotr Palka answers

• TSQL -- Extract JSON values for unknown/dynamic key in sub-object (not an array)
• SSAS error when processing data, after picking the database table
• Compress string in Sql server and decompress in javascript
• SSIS Script Keeps Reverting To .Net Framework 4.5
• How to properly truncate a staging table in an ETL pipeline?
• Why does CROSS APPLY *not* get an invalid column error in this query?
• Data Truncation issue while importing excel from Azure Blob storage to Sql Server
• SSIS Script Component not working when deployed. Complains about ComponentVersionMismatchError