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 78 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

Knowledge 0 Comments

Last week reading (2018-04-15)

Good day SQL folks! Spring is everywhere all around us! You might not necessarily see this Monday morning at work… I hope you will have an easy start of the

Last Week Reading 0 Comments

Last week reading (2017-12-24) aka. Merry Christmas!

Thanks for visiting the page. This is a special week – the Christmas Week! Hope you will find some time to read great articles I have found for you. Here you

Last Week Reading 0 Comments

Last week reading (2018-08-05)

Microsoft Azure Data welcomes Data Platform Summit attendees Rohan Kumar [B|T] invites to have a look at today’s mobile-first, cloud-first world and what has been changed in the area by Azure

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

6 + 1 =

Protected with IP Blacklist CloudIP Blacklist Cloud