T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests

8 years ago

 Let's kick off the new year with a T-SQL Tuesday! This month's edition is hosted by Brent Ozar: Announcing T-SQL…

Clustered Columnstore Index really hates Updates

8 years ago

First a little background. I'm working on a large fact table that behaves itself as a slowly changing type 2…

Master Data Services Error – Missing Temp Directory

8 years ago

I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had…

SSIS Naming Conventions 2.0

8 years ago

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server…

Problem where you can only browse Google websites

8 years ago

Note: not a SQL/BI related post like usual, but since it's a common issue I want to share my solution…

Calculate a semi-additive average in DAX

8 years ago

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure…

SQL Server 2016 service pack 1 is here!

8 years ago

SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.…

Book Review – Power Pivot and Power BI

8 years ago

Since Power BI is all the rage right now, I was in need of some material to spice up my…

Master Data Services – Database Error has Occured when Publishing Business Rule

8 years ago

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016.…

First thoughts on Power BI on premises

8 years ago

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