Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Saturday 5 February 2022

Data Toboggan Conference links

During the course of the Data Toboggan 2022 winter conference day learning links were shared in the chat by various people. 

So for those wanting to learn more I have collated the links together. 

Best practices for serverless SQL pool - Azure Synapse Analytics

Recommendations and best practices for working with serverless SQL pool.

Pre recalculating datasets too 

Luke Moloney session is on GitHub


Terraform in Azure Learn module available 

Some good MS resources around creating a Centre of Excellence using Power BI https://docs.microsoft.com/en-us/power-bi/guidance/center-of-excellence-establish

Machine Learning in Azure Synapse Analytics - Azure Synapse Analytics

Creating statistics on Serverless SQL Pools 

The whitepaper that Kevin Chant mentioned about a quick introduction to Azure DevOps  and his blog: https://www.KevinRChant.com and GitHub repo: https://github.com/kevchant

Azure Pipelines YAML schema reference

David Alzamendi provided a number of  Resources

Scripts: https://github.com/techtalkcorner/AzSynapseAnalytics/tree/master/Scripts/T-SQL

Data Skew: https://www.techtalkcorner.com/azure-synapse-analytics-data-skew/

Tables Design: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview

Update statistics: https://www.techtalkcorner.com/update-statistics-azure-synapse-analytics-sql-pools/

Azure Synapse Analytics Service Levels :

Memory and concurrency limits for dedicated SQL pool in Azure Synapse Analytics

Columnstore Indexes: https://www.nikoport.com/

Maximize rowgroup quality for columnstore index performance

Query Store: Monitoring performance by using the Query Store

GitHub: https://github.com/techtalkcorner/AzSynapseAnalytics/tree/master/Scripts/T-SQL

Introduction to designing tables in Synapse SQL.

Design tables using Synapse SQL - Azure Synapse Analytics

Update Statistics in Azure Synapse Analytics SQL Pools -Tech Talk Corner

How to update statistics in Azure Synapse Analytics SQL Pools to improve the performance of your queries. Include two scripts.

Memory and concurrency limits - Azure Synapse Analytics

Distributed tables design guidance - Azure Synapse Analytics

Automatic aggregation in Power BI

Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI

Azure Synapse Analytics January Update 2022

The first blog of the year includes newly added database templates, a security whitepaper, and data integration updates. 

So plenty of post conference reading

No comments:

Post a Comment

Note: only a member of this blog may post a comment.