Counting Events

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

Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension

This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...

First Day as DBA - Now What?

It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...

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

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