by Gil Raviv | Nov 15, 2016 | Data Chant
Follow Me In today’s blog post we will learn a neat Power Query trick that is extremely useful in improving refresh time on certain Web API calls (Like Yahoo Finance, Quandl and Twitter). This post first appeared...
by Gil Raviv | Nov 6, 2016 | Data Chant
With only three days until the US Presidential Election, here is a Power BI report that extracts Trump’s and Clinton’s key phrases from their Facebook status updates during the race. In the upper WordCloud visual the most used phrases are bigger. In the lower...
by Jeanne Combrinck | Nov 2, 2016 | SQL Girl
Following on from my previous post on SQL Transaction Isolation Levels, we get to the juicier part of Row Versioning-based Isolation Levels. Read Committed Snapshot and Snapshot isolation levels allow for the use of row versioning. By using the row versioning-based...
by Jeanne Combrinck | Nov 1, 2016 | SQL Girl
Isolation levels can be quite useful when retrieving data and inserting data to maintain data integrity. Isolation levels control the locking and row versioning behaviour between SQL statements issued by a connection to SQL server. It defines the degree to which one...