TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of...

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.

The title is SQL Server BI Best Practices and its...

Columnstore Indexes – part 77 (“SSIS 2016 & Columnstore”)

Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...

An annoying Bug in the Restore Dialog

Today, thanks to a customer, I discovered  one of those annoying little things that can really drive you nuts.
Basically, they were...

SQL Saturday Headshots

This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I...

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...

Refreshing KPI Data in SSRS 2016

Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...

How is SQL Server using more than the Max Server Memory?

As usual, the pager went off...

"Server is near 100% memory utilization - what is running?"
http://www.starshipearththebigpicture.com/wp-content/uploads/2015/09/red-alert-picard-300x228.jpgI saw when I signed on that...