Weekly reading 10#
New week has started. 1/2 of the Coding Family Team has exams at school today. We were all busy last weeks…. But now it ends! And this must be a good week! Cross fingers!
Here you can find a short description of two new functions: sys.dm_db_page_info (the replacement to the good old DBCC PAGE) and sys.fn_pagerescracker.
Do you like to run? How to calculate elapsed time? These are the questions (and the solution) you can find in this article. Well, the question about running is not answered yet.
Automated Machine Learning for Data Flows is now available Power BI! I have used it during the #GlobalAINight and it was really impressed. In this article you will find information about how to do it! In PowerBI!
Is it something we could use with SQL Server in Azure? Yes! The article says about the demo that was presented at the Microsoft Ignite (HTBB demo of 12.5GB/s single blob throughput at Microsoft Ignite)
Extended Events have been present in the SQL Server for a while. Pedro Lopes shows how to grab an actual execution plan with XE and why you should do it that way (and not by SQL Server Profiler)