Last week reading (2018-10-21)

Last week reading (2018-10-21)

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.

Microsoft Azure Data Factory Data Flow: Debug Session Pt 2, Data Prep
Data preparation with Debug mode in Azure Data Factory v2 [T]

 

Previous BI Connected by SII - conference in Wrocław
Next ASF 015: Kalen Delaney interview

About author

Kamil Nowinski
Kamil Nowinski 100 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last week reading (2018-08-26)

Processing Petabytes of Data in Seconds with Databricks Delta Delta is a unified data management system that brings data reliability and performance optimizations to cloud data lakes. Monitor Azure Data

Last Week Reading 0 Comments

Last week reading (2018-09-30)

Entire last week was dimmed by MsIgnite, hence take a look at videos from that conference: Microsoft Ignite 2018 Some sessions recorded and available over there. CosmosDB at Ignite 2018

Last Week Reading 0 Comments

Last Week Reading (2019-01-13)

Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The last episode. Personally, I’m sad, but waiting for new ideas

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

45 + = 52

Protected with IP Blacklist CloudIP Blacklist Cloud