Show 40 - Just Another Show

Another two weeks have passed, and another show is live.

Today on the show:

• Error handling in SSIS
• Why Big Data systems use ELT and not ETL
• What Data Scientists do
• What Data Analysts do and why they need to know SQL well 
• Azure Data Factory and Azure Data Catalog
• Compressing and decompressing data in SQL Server 2016
• Configuration options for high-end SQL Server systems
• More SQL Server setup tips

Items mentioned in the show:

• Guy's SQLBits precon - Big Data Made Simple
• Jeff Smith - They Just Write SQL Statements
• Recommended updates and configuration options for SQL Server 2012 and later versions with high-performance workloads 
• Built-in functions for compression/decompression in SQL Server 2016