create a waterfall chart
Create a waterfall chart when the data differs by several orders of magnitude
16 May 2019

With a starting value of $288,222,000.21 USD and a final total of $285,769,892.75 USD, the middle values used to calculate the total in the initial dataset contained extremely large variances in values. The scale and degree of variance created a challenge for creating a waterfall chart in Power BI.

Power BI Relate tables
Power BI — Relate Tables Using Your Data Model — Episode 6
10 May 2019

Welcome to Episode 6 of my Power BI Best Practices Series. In today’s episode, I will show you how to relate tables and your data model to allow for cross filtering and relationships. Here we go! Power BI — Relate tables and your data model By default, Power BI relationships are not active. So, you need to set the relationships in your dashboard. You can also set the type of cardinality of the selected relationship from one of the following […]

Backup Restore Azure SQL DBMI
Migrate Azure SQL Database Manage Instances to Azure VMs using Backup and Restore
08 May 2019

I recently needed to migrate an Azure SQL Database Managed Instance to an Azure VM running SQL Server. There were several reasons for this which included: Machine Learning Services was not available for processing R language libraries close to the database. Bulk loading CSV files were slower than expected because Managed Instances only supports the Full Recovery Model. PolyBase was not available for data mining data files located in Azure Data Lake Gen2 storage. The challenge that I faced was […]

Power BI - Prepare Report
Power BI — Prepare Report Requirements — Episode 5
03 May 2019

Welcome to Episode 5 of my Power BI Best Practices Series. In today’s episode, I will show you how to prepare report requirements documentation. Here we go! Power BI — Prepare Report Requirements When building out your Power BI Dashboards, how do you make sure your visualizations address all the points your client wants? This is where a Reports Requirement Document comes into play. By creating a Reports Requirement Document, you will have a record of what’s expected, and can […]

Managed Instance file growth
Beware — Azure SQL Server Database Managed Instance default file growth of 16 MB
02 May 2019

During bulk data loads with an Azure SQL Database Managed Instance, we noticed a significant performance hit as we imported data into staging tables. It turns out a Managed Instance default file growth for data and files is 16 MB! Change your Managed Instance default file growth size now! With the database file growth set so low, SQL Server grinds to a snail’s pace when importing large amounts of data. In our case, I changed the file growth to something […]

Database Compare Suite supports Amazon DynamoDB
Database Compare Suite update 4.14 brings Amazon DynamoDB support
02 May 2019

DB Best announces the release of a new version of an ultimate DBA tool Database Compare Suite. The latest version supports Amazon DynamoDB. This is the second NoSQL database platform supported by DB Best Database Compare Suite to complement the recent addition of support of Apache Cassandra as a source and target. In addition to this, Database Compare Suite update 4.14 brings the ability to use SSL to connect to Microsoft SQL Server and Oracle databases. Continue reading to learn more […]

Power BI — Table for Key Measures — Episode 4
26 Apr 2019

Welcome to Episode 4 of my Power BI Best Practices Series. In today’s episode, I will show you how to set up a key measures Power BI table, and why it’s beneficial to do so. Last episode, we covered sub-dividing and segmenting visuals. As a reminder, here is the overall curriculum for this video blog series: Power BI – Table for Key Measures The larger the dataset, the more difficult it can be to be organized, especially when sharing dashboards […]

Developing a secure healthcare data platform
25 Apr 2019

One of our US healthcare clients approached us to create a reliable and secure data platform for their application. After examining their data infrastructure and goals, DB Best came up with a cloud-based solution to build questionnaires based application, to meet the customer’s needs. An application guiding your lifestyle Our customer envisioned an application to help people suffering from chronic diseases live full, unobstructed lives. For sufferers of these life-long illnesses, keeping track of their symptoms and bodily health, as well as following […]

modernization from oracle to sql server
Advanced Engineering Application Modernization from Oracle to SQL Server

As moats create obstacles in the way of an invader, so do proprietary database features for developers. One of Oracle’s proprietary features is the Oracle Call Interface (OCI) which provides efficient communication between application code and the database. There are other ways to connect to Oracle, but once you have committed to OCI, you are “protected” from switching to another database. In this blog post, we break down an application modernization from Oracle to SQL Server for an advanced engineering-oriented […]