Download Episode

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