#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer

Power BI Desktop has been out for GA for over a week now and some of the pro’s out there...

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was...

Community Reactions to Power BI General Availability

Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about...

Consolidating Multiple Data Marts

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering.  The BI group at CHC used to assign specific...

Consolidating Multiple Data Marts

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. ...

Differences Between Actual & Estimated Plans

I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...

Downloading SFTP Files with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:
He had a table of a few dozen million rows. The table had...

Monday Morning SQL Break – August 3, 2015

It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...

Question of the Month (July)

Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-

Create table emp_plan (empid nvarchar(200),planid...