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 175 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-03-04)

Good day SQL folks! Thanks for visiting our blog again!  It’s March already and we are looking for the Spring to come.   Columnstore Indexes – part 120 (“Merge Replication 2016-2017”)

Last week reading (2018-01-28)

SQL Server 2017 CU3 adds CXCONSUMER waits, doesn’t mention it New wait is not visible everywhere, but check where you can find it. Sabbatical and the search for a dream

General 0 Comments

Last week reading (2018-02-25)

It’s was very busy and pleasant week for me. Tenth SQLBits which has taken in London this year finished yesterday. I have been working as a volunteer (one of the

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply