Over the years I have accumulated some seemingly weird ways to explain topics within SQL Server. Usually in a training I find that participants are able to relate […]
Rebuild all indexes and statistics on Azure SQL database
Since Azure SQL databases are limited in what they expose to the management studio client we miss out on a lot of features within SSMS that we could […]
What is a good design for a website?
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 […]