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,


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

About author

Kamil Nowinski
Kamil Nowinski 35 posts

Data Architect, MCSE Data Platform, MS BI Developer, Member of PLSSUG, co-organizer of SQLDay, speaker. Happy husband & father. #SQLFamily member.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last week reading (2017-12-03)

Induction This is a new series. Posts in that series as summary of last week reading. So long I was thinking about it whether is it good idea to post

Last week reading (2018-01-14)

The top 7 business benefits of establishing DevOps in your organization No comments, find and understand the benefits. Columnstore Indexes – part 116 (“Partitioning Specifics”) What do you need to

General 0 Comments

Last week reading (2018-02-18)

Good day SQL folks! Thanks for visiting our blog again!  Have a great week!   Bob Ward’s demos github repo This is not for reading per se but I would definitely


No Comments Yet!

You can be first to comment this post!

Leave a Reply

+ 77 = 87

Protected with IP Blacklist CloudIP Blacklist Cloud