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