Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is automatically updated as new data is added to its source…
The slides for the DataMinutes #2 session Turbocharging Power BI using Synapse Analytics is available here to download. GitHub Code The Serverless SQL Pools code to generate the pre-computed datasets…
SQLBits is back this year and is running from Tuesday 8th to Sunday 12th March at the ExCel in London. Register for the event and see the schedule here. I'm…
The next DataMinutes conference (#2) is taking place on Friday 21st January. What's different about DataMinutes is that it is a fast-paced lightning session conference, all sessions are short at…
In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh, and DirectQuery (real-time) modes in a single table. We look…
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along with an External Table, allows us to cast structure over…
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the November 2021 Synapse Analytics update). When querying external data, Serverless…
Data Toboggan is a community-driven conference focused on Azure Synapse Analytics, Microsoft's flagship data warehousing, big data, and analytics service. The next event is running on Saturday 29th January, 2022…
PASS Data Community Summit 2021 Slides Please click here for a PDF copy of the slides. Polaris (Serverless SQL Pools Engine) Please click here to download the Polaris whitepaper to…
Synapse Analytics allows the creation of External Tables and Views within a Serverless SQL Pools database and also a Spark database. These objects can be shared between Spark and Serverless…
Andy