When the trailers for the Aliens movie came out the one thing that caught my attention was how little the look of the alien has changed over time. […]
String split using full text indexes
Recently I needed a way to extract keywords from email messages in order to create a list of noise words for a spam filter as well as implement […]
Charting controls: – Things to keep in mind – Part 2
In this second part of the series on charting controls we take a look at a few lesser known charting controls. You can view the first part of […]
Charting controls: – Things to keep in mind
I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
administration / Database / MSSQL / TSQL
Set based vs row by row (procedural code)
I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide […]
Calculating Pi in MS SQL Server
PI is a very commonly used mathematical constant, in fact it is probably more famous than the equation E=MC2. We might not find a lot of use for […]
administration / Database / MSSQL / TSQL
Actual vs Estimated plan and the use of Time to arrive at the best plan
I came across a comment on linkedin today about the difference between the actual and estimated execution plan in SQL Server and how it is used to determine […]
Loading multiple files into Power Query/ PowerBI
In this post we cover how to work with multiple files of type CSV when loading into Power Query. Very often we have a set of data provided […]
DAX and Date Time or Time Intelligence Analytics
One the best parts of using analytics engines are their ability to understand dates and other types of hierarchies. As human being we use time as a core […]
Brand new video on PowerBI
A brand new video on PowerBI, with a quick introduction on the tools. After which we create a report and use the basic features. https://youtu.be/tPrHkbgSj10