Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...

Looking Back: #sqldinner at #sqlsummit 2016

Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...

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 other day. A puzzled DBA was staring at a...

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

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