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 191 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-11-04)

Good morning folks! I wish you very good week at work, at home or wherever you are/will be. Last week brought super-exciting news to me. What it was? Check at

Last Week Reading 0 Comments

Last week reading (2018-02-11)

Good day SQL folks! Thanks for visiting our blog again!  I have just come back after almost 2 weeks of vacations and here you are – fresh, good content for

SQL Server 2017 Release Candidate 2 (RC2) is available!

Hello SQL Folks! I’m happy to announce we Microsoft released RC2 of SQL Server 2017. This release contains bug fixes and performance improvements I bet you know that SQL Server 2017

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply