PASS Summit 2015 Plans

I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...

SQL in the City Comes to Seattle in 3 Days

Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...

SQL in the City Comes to Seattle in 3 Days

Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...

SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column

Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...

Talk to Me at PASS Summit

If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s...

Webinar – What’s New for Business Intelligence in SQL Server 2016

I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.

The title is What’s New for Business Intelligence in SQL Server...

Git Push in SQL Source Control

I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...

Histograms and Events

In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...

Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...

Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...