We have re-branded the NorthEast SQL Server User Group (SQLNE) as Newcastle Data Platform and Cloud (DPaC) User Group. SQLNE was established in 2013 to bring together the SQL Server Community.
At our regular bi-monthly meetings we host presentations from first timers to internationally renown speakers.
A group for anyone interested in learning more and/or sharing their knowledge of the Microsoft Data Platform. All skill levels are welcome. Topics and technologies will be varied but along the lines of SQL Server, SSIS, SSAS, Power BI, Azure DB, Azure automation, Azure SQL Data Warehouse, SQL Server on Linux and containers.
Network, learn, ask a question, meet other folks - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
Online event only - Link provided to those who sign up. Not being recorded.
17:45 – 18:00 - Intro and updates
**(L400, so prior Azure Synapse knowledge expected)**
18:00 - 19:00 - Mark Pryce-Maher : Dedicated SQL Pools : How some stuff 'really' works
In the session we look at a few features as Azure Synapse Dedicated SQL Pools; * Table Distributions * Partitioning * Result set caching * materialized views.
We will cover these great features; When to use them but also which situations when not to use them and why.
**This is a L400 session, so you will be expected to have used SQLDW or Synapse Dedicated SQL Pools, not just skimmed the documentation. :-) If you don't know your Round Robin from your Clustered Column Stored Index, then maybe this isn't the session for you.**
Mark Pryce-Maher is a Program Manager on the Azure Synapse Analytics Customer Success Engineering team at Microsoft, where he is working with customers implementing Enterprise Data Platforms.