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

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

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

Speaking at SQL Saturday #452 - Charlotte, NC - October 17

In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you...