This is a powerful function for advanced measures used correctly it give great flexibility in how you slice and dice the data. It will be much easier to […]
PowerBI DAX – CALCULATE
In this post we explore the use of CALCULATE. Calculate is one of the most frequently used DAX Formulas. This is because it is every flexible and can […]
PowerBI DAX – ALL
Another commonly used DAX function in PowerBI is the ALL function. It is used to clear filters that may be applied. When visualizing data in PowerBI the data […]
MS SQL Machine Learning -Add Modules -Part 2
In this second post we explore how to setup MSSQL Server Machine Learning. Now that we have Machine learning services installed on SQL Server the next thing will […]
MS SQL Machine Learning -Install ML -Part 1
In this series of post we are going to cover all the steps required to be able to perform Machine learning on Microsoft SQL Server. We will start […]
3 settings to improve SQL Server performance
There are a number of dials and knobs in SQL Server that allow the DBA to fine tune almost every aspect of the server. In this post I […]
How to Increase transfer rate when copying to External HDD
Recently I had to purchase an additional external hard disk to back up my data. While creating a system image of the laptop I noticed that it was […]
Tuning SQL Server using Fill Factor to control page splits
Is it better to take a hit on performance due to Fill Factor or Page Splits? That is the question being answered in this video. As with most […]
Why you should continue to defrag your indexes:-What are page splits 1/4
Recently I came across a video in which it was suggested the Page Splits/sec counter was not useful in identifying Page splits and that using fill factor to […]
Plotting Graph database in Power BI – Greek Mythology
During the lockdown I started rereading Stephen Fry’s Mythos. A modern interpretation of the Greek myths with the trademark Fry Humor. Greek mythology like most ancient literature is […]