Drill Down with Power BI Visualizations

A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...

Dynamically Read event_file Data

There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...

Dynamically Read event_file Data

In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...

Getting Started With DocumentDB

I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is...

Handling decimal and non numeric types using Case statement

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...

Index selectivity and index scans

There was a question raised some time back ‘If an index is not selective, will the query operators that use...

New SSDT Projects default to the latest version of SQL Server

When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...

New SSDT Projects default to the latest version of SQL Server

When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...

New SSDT Projects default to the latest version of SQL Server

When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...

New SSDT Projects default to the latest version of SQL Server

When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which is annoying when you are on something else.
However, if...