Hekaton Part 9: Things Hash Indexes can't do

Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...

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

Improved #MinionBackup and #MinionReindex – new versions!

We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....

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