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

Step by Step SSIS–Derived Column Transformation TIP # 120

Dear Friends,
In the series of Step by Step SSIS , Zero to Hero in SSIS this is another post in which...

Working with “special” names

What do you do when you need to use a special character in a name? Well, I guess I should...

ZOOMIT!

Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...