2020 @SQLSatLA presents: Synapse Analytics: Beyond the Basics by Dennes Torres | @PureStorage Room
Synapse Analytics: Beyond the Basics by Dennes Torres (@Dennes)
Synapse Analytics, which is way beyond the former Azure SQL Data Warehouse, is focused on MPP, Multi Parallel Processing, being a very powerful environment for Data Warehouse processing.
It's former name, Azure SQL Data Warehouse, usually pushed many DW and BI developers to use this powerful tool in order to build a Data Warehouse. However, just implementing the logical design of a Data Warehouse inside an MPP environment can be very deceiving, because many default settings for the MPP environment will not be at their best.
On this session you will see how to configure the MPP environment to achieve it's best performance for your Data Warehouse. You will understand the importance to understand and control the distributions by compute nodes, how critical are the correct choice of resource classes and users, the benefits to correct manage workload classification and much more.
Prerequisites: Basic SQL and Data Warehouse knowledge is useful but not required
-
59:29
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Secure SQL Server Database Design by Dan Mallott | @PureStorage Room
216 -
56:20
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA Presents: The Future of Containers Is Here! by Marsha Pierce | @PureStorage Room
20 -
52:38
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Build Your 1M Dollar SQL Practice by Adrian Sullivan | @PureStorage Room
19 -
59:40
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Data Lake Design Patterns by Jason Horner | @Blackline Room
15 -
1:23:35
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: DevOps for Azure SQL by Arvind Shyamsundar | @Microsoft Room
26 -
53:40
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Data Lakes with Azure Databricks by Dustin Vannoy | @Blackline Room
37 -
1:04:24
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Monitor SQL using Free solutions by Javier Villegas | @SentryOne Room
63 -
38:26
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Presentation Skills for the Techies by Buck Woody | @Microsoft Room
12 -
1:02:01
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Azure SQL Hyperscale Deep Dive by Denzil Ribeiro | @Microsoft Room
16 -
1:03:27
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Implementing AI solutions using Azure ML by Vitor Fava | @SentryOne Room
24