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

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 (2018-04-22)

Redgate Shift LEFT magazine The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the

Last week reading (2018-09-09)

Automatic intelligent insights to optimize performance with SQL Data Warehouse With no additional costs, Azure SQL DW delivers you best practice recommendations in terms of data skew and suboptimal table

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

13 − = 9

Protected with IP Blacklist CloudIP Blacklist Cloud