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

Why Is The Server Slow?

This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...

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

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

SQL Saturday Headshots

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

Take caution when altering a column using TSQL

When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...

Creating KPIs in SQL Reporting Services

In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016.  Let’s...

Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting

When is the last time you audited who has SQL Server access? No really? When did you last do this?...

SSRS 2016 – Part 2 New Features for Paginated Reports

This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...

T-SQL Tuesday #75: Round Up

This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...