Last week reading (2018-02-25)

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 ORANGE team) monitoring each day. Friday evening super party as always. Stay tuned as many great pictures will show soon.

Stairway to DAX and Power BI – Level 13: Simple Context Manipulation: Introducing the DAX All() Function
Quite detailed explanation how All function works. With a good example.

Creating Excel “Data Dump” Reports From Power BI
If you or your Client needs to analyze the data in old-way style rather than Power BI – check this Chris Webb’s post.

SQL Server Replication for Temporal Tables
How to replicate temporal history table? There is a workaround.

Analysis of Spatial Data Using Cosmos DB
Use CosmosDB in many ways. In this extremely easy example, you will see how to build such a solution using an alternative database with scale capabilities.

Azure #CosmosDB Graph API now generally available
Not only an announcement but also newly added support for Python and PHP application.

Azure Cosmos DB Consistency Levels
Everyone asks about it trying to understand how it works.

Data Virtualization vs. Data Movement
Do you always need ETL? What the drawbacks are if you create visualization directly from a source?

Data Lake, Big Data, NoSQL – The Good, The Bad and The Ugly
An essay about how bad the terms like Big Data and NoSQL are nowadays.

Unlock Query Performance with SQL Data Warehouse using Graphical Execution Plans
Yes, you see it well! Graphical plan for Azure Data Warehouse.

Reference Date Table in DAX and Power BI
Almost every single model in DWH or Power BI needs reference Data table. That one contains weeks, fiscal years and holidays for a specific country.

Have a good week! Cheers,
Kamil

 

Previous Last week reading (2018-02-18)
Next Last week reading (2018-03-04)

About author

Kamil Nowinski
Kamil Nowinski 107 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 (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

Last Week Reading 0 Comments

Last week reading (2018-08-19)

Hi folks. I’m on holiday for 7 days (14 days left). The holiday is a perfect time for reading, right? Although I’m heading to Italy and writing this post in

Last Week Reading 3 Comments

Last week reading (2018-05-14)

Good day SQL folks! SQLDay has just started! We have a workshop about DevOps and Kamil promises to publish a great series of posts about SSDT and topics around that.

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

− 2 = 3

Protected with IP Blacklist CloudIP Blacklist Cloud