New indexes, hypothetically

I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...

SQL Server DMA v2.0 – Migration Time

In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...

This Week In Data – Episode 11 (Debunking Popular Cloud Myths)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Trick or Treat...Have I got an IT Training treat for you...

It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...

Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the...

Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...

Autumn Update - Trick or Treat

Its been a busy few weeks for me, most of that outside of gethynellis.com I’m in the process of moving...

First thoughts on Power BI on premises

The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...

PASS Summit 2016 Wrapup

Last week I had one of the best experiences of my career – attending this year’s PASS Summit in Seattle. I...

PASS Summit Announcements: Azure Analysis Services

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...