dataMinds News Round up – january 2022
How (Azure) SQL evolved during 2021..
Eager to learn how to build solutions and use Microsoft products from the experts that built them?
Microsoft Shows enables you to browse on-demand content to stay updated on the latest announcements, features, and products from Microsoft.
To get you started, the Data Exposed show currently embraces around 192 episodes all about data; relational and non-relational, on-premises and in the cloud, big and small. Each episode, experts demonstrate features, discuss the latest news and share their love for data technology including SQL Server, Azure Data Services like SQL DB, Cosmos DB, SQL and so on.
Anna Hoffman summarizes all the big updates this year across Azure SQL, SQL Server & Azure Arch. Make sure to check out the blog, linking to all articles or sit back and relax watching the one hour recap webinar. Not convinced yet? The latter also contains a sneak peek at what’s coming.
Power BI
With some very interesting updates on the Power BI release plan, ready to be shipped the upcoming months, Melissa Coates likes to call out a few of the top things that she’s most excited about.
In this post, she’s focusing on a few release plan items that she think Power BI administrators in particular should be aware of as we head into 2022.
As a Power BI administrator you want to see what’s happening in your tenant right now: who’s running queries, which datasets are refreshing and so on. That way if a user calls you to complain that their report is slow or their dataset hasn’t refreshed yet you can start troubleshooting immediately. Power BI’s integration with Log Analytics (currently in preview with some limitations) is a great source of information for this kind of troubleshooting: it gives you the ability to send various useful Analysis Services engine events, events that give you detailed information about queries and refreshes among other things, to Log Analytics with a latency of only a few minutes. Chris Webb elaborates on what steps to take in a series of blogposts.
The second year of the pandemic is coming to a close and despite the many uncertainties, we are all striving to push forward and look ahead. For sure, it is a good moment to see what happened in the DAX world. Marco Russo recaps what happened in the DAX world in 2021 and take a look at what is coming in 2022.