Show 40 - Just Another Show

28/01/2016 30 min
Show 40 - Just Another Show

Listen "Show 40 - Just Another Show"

Episode Synopsis

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