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...
by Gil Raviv | Oct 31, 2016 | Data Chant
Follow Me At the end of each month, the Power BI team releases a new update to Power BI Desktop. You can go here to learn what’s new in the latest version. This post first appeared at http://datachant.com/2016/10/31/column-grouping-power-bi-desktop-october-update/....
by Jeanne Combrinck | Oct 31, 2016 | SQL Girl
A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. Basically it includes all database settings and the metadata within itself thereby resulting in no configuration dependencies on the...
by Melissa Coates | Oct 31, 2016 | SQL Chick
This is part 1 of 3 about Azure Analysis Services (Azure AS) which was announced a few days ago. Azure AS is a Platform-as-a-Service (PaaS) offering which is currently in public preview mode at the time of this writing (late October 2016). Part 1: Why a Semantic Layer...