DevOps Terms – and Why They Matter to Database Specialists
Find out what is Scrum, Continuous Deployment, TDD and others from Kendra Little [T].
Seamless access to management insights for SQL Data Warehouse with Data Studio
Check potential physical data skew in your Azure SQL Data Warehouse (SQL DW) using Azure Data Studio (general availability)
SQL Server 2019 CTP 2.0 New Features – Introducing the Page Cracker (AKA sys.dm_db_page_info)!
That new function (fn_PageResCracker) helps you decoding a page identifier. No more DBCC PAGE usage needed.
Aggregations for petabyte-scale BI available in the Power BI service
Do you know all the good reasons to use Aggregations (which is in public preview at the moment)? Find out them and watch a demo (video) plus deep dive demo from @Guyinacube [T].
PowerBI – Constant Line
Quick one about how to add it to a chart.
T-SQL TO U-SQL DATA TYPE CONVERSION
That is useful (although not sure how long yet) cheat sheet table from Paul [T].
Data science in SQL Server: pivoting and transposing data
Dejan Sarka presents the same trick but in R.
Data models within Azure Analysis Services and Power BI
Best practices useful particularly when creating data semantic models in SQL Server Analysis Services, Azure Analysis Services, or Power BI.
Data preparation with Debug mode in Azure Data Factory v2 [T]