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
-
LIVE
Graham Allen
1 hour agoDid Logan Paul ENDORSE Trump?! + Merrick Garland Held In Contempt!
4,942 watching -
LIVE
Matt Kohrs
9 hours agoMeme Stocks Tumble, Market Pumps Higher & Live Trading $1M || The MK Show
1,667 watching -
LIVE
jeffahern
1 hour agoThursday Thrash With Jeff Ahern (6am Pacific)
410 watching -
57:10
Kimberly Guilfoyle
2 days agoBiden’s America Last Disaster and What We can do About it. Sen Tom Cotton, Candice Jackson & John Rourke | Ep. 133
75.3K103 -
LIVE
AP4Liberty
2 hours agoRFK Is Creeping Team Biden Out
956 watching -
DVR
The Podcast of the Lotus Eaters
4 hours agoThe Podcast of the Lotus Eaters #936
13.5K4 -
11:00
JoBlo Horror Originals
1 day agoHow Mortal Kombat Redefined Video Game Movies
7.81K1 -
17:02
DepressedGinger
1 day ago $0.05 earnedThe TRUTH about January 6th
7.75K5 -
9:14
ErmzPlays
18 hours agoThe Acolyte Episode 3 Completely BROKE Star Wars
8788 -
1:23
Maicy Renee
1 day agoWorst Part About Racing!
8.67K1