10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)

If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...

Better Test Data Domains with SQL Data Generator

I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with...

CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)

I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.

Go on...

Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT

I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my...

Shredding Extended Event Actions

Are you rolling the dice with your love/hate relationship with XML? Tune in to see how you can ease your XML frustration along with increasing your free time to...

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that...

Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in...

How to Create Pareto Chart in Power BI

About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...

SQL 2016 CTP 2.3 has been released

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.

You can find the download here (the...

CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...