dataMinds News Round up – December 2020
Simon Whiteley elaborates upon the importance of the so-called “Modern Data Warehouse”, bringing the various maturities of a data warehouse into the data lake itself with Databricks.
Azure Synapse Analytics
Julia White, Microsoft Azure’s Corporate Vice President, talks about the pradox of analytics: the more we apply new technology to integrate and analyze data, the more silos we can create. To break this cycle, she announced both the move of Azure Synapse to the global generally availability and the public preview of Azure Purview.
Wolfgang Strasser shines his light on Azure Purview, a unified data governance service which only recently has been launched in public preview.
Marco Russo writes about properly setting memory configuration in SQL Server Analysis Services and Azure Analysis Services.
Chris Webb visualizes Azure Analysis Services processing tasks with the job graph events.
Craving for SQL Server performance? Brent Ozar got you covered in his latest blog. Brent points out how bad statistics cause bad sql server query performance.
Mohammed Moinudheen put together a thorough exposition on auto scaling Azure SQL databases using Azure Automation runbooks as opposed to Azure Logic Apps. Make sure to check it out.
Esat Erkec shares his insights into the query tuning features that were announced with SQL Server 2019.
Azure Data Factory
Mark Kromer deep dived into several features which could help you handling SQL DB row-level errors in Azure Data factory data flows
Reza Rad extended the Power BI Helper, an external tool allowing you to thoroughly document and analyze Power BI reports among many other things, with the ability to clean reports from any unused data.
Matthew Roche gets into detail on the why and how you should build a data culture. Succeeding with a tool like Power BI is easy. Succeeding at scale with a tool like Power BI isn’t.
Lou Segers elaborates on Power BI’s most recent license offer, dubbed Premium Per User, and how it could become a game changer.
There’s no denying Chris Webb is a big fan of dynamic M parameters. Since its release, several scenario’s have been described for which these parameters could be the right fit.