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 is annoying when you are on something else.
However, if...

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

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

Speaking at SQLSaturday #459, Madrid 2015

Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a...

SQL Server issue: switching partitions using the parameter with enabled replication

It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...