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

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

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

Counting Events

This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...

Counting Events

After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...

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

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

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

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