Power BI Set Filters
Power BI — Set Visual, Page, and Report Level Filters — Episode 13
28 Jun 2019

Welcome to the last episode of my Power BI Best Practices Series. In today’s episode, I will show you how to filter your report based on visual level, report level, or page level filters. Here we go! Set Filters First of all, let’s discover the main filter types and examine their differences. Visual level filters allow for filtering only the selected visual. Likewise, page level filters allow for filtering the entire page. And report level filters allow for filtering all tabs together in your entire report. You can simply drag and drop the filed names to the filter tab to add a filter to your report. You can even set a filter with a f...

remove the Management Data Warehouse from SQL Server
How to remove the Management Data Warehouse from SQL Server running on a production instance
26 Jun 2019

One of our customers had their Management Data Warehouse (MDW) running on their production SQL Server 2012 and didn’t know what to do with it. Microsoft had introduced the MDW with SQL Server in 2008. However, there was a bug in SQL Server 2012 that prevented the Query Statistics data collector from working. Rather than trying to fix it, we made the decision to remove it instead. We replaced the MDW with the Open Query Store project, a community supported tool that works with SQL Server 2008 and higher. The problem Removing the MDW from SQL Server running in production is straight forward and requires that you follow the steps below. The so...

Power BI — Edit Interactions — Episode 12
21 Jun 2019

Welcome to Episode 12 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should edit your interactions in your visuals. Editing interactions allows for you to apply the filter directly on a visual. Also, you can change the way the filter interacts with different visuals on your page. Here we go! Edit Interactions In the Edit interactions menu, you can specify, to which visuals this filter applies. You can turn off the interaction for some of your visuals on the dashboard. In this case, these visuals will not change when you update your filter. Please note that you can not edit interactions if the repor...

Schema mapping in Oracle to SQL Server migrations
18 Jun 2019

When migrating Oracle databases to Microsoft SQL Server, the first problem you will face is mapping Oracle schema to SQL Server. You can hardly underestimate the importance of this architecture-level question because the wrong approach will lead to significant efforts in rewriting the code. The problem In Oracle, the database server contains an Oracle database and an Oracle instance. At the same time, every Oracle database contains schemas. By the way, you can learn more about the Oracle architecture here. Basically, a database is a physical component. Oracle does not use the database name as a part of the object’s name. Microsoft SQL S...

Power BI Cut Unnecessary Visuals
Power BI — Cut Unnecessary Visuals — Episode 11
14 Jun 2019

Welcome to Episode 11 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should cut unnecessary visuals in your dashboard to allow for better user experience. Clean reports have a better look and feel. Moreover, they make it easier for the user to understand the information and navigate through the dashboard. Here we go! Cut Unnecessary Visuals An unnecessary visual is a visual that shows replicated data that you don’t need in your report twice. But still, the question is how can you determine, which of the visuals you should remove. I recommend removing the visuals, that don’t provide any ...

Minimum Viable Product (MVP)
Why MVP is a viable way to start your business?
13 Jun 2019

A minimum viable product (MVP) is a development strategy in which a new product is developed with sufficient features to satisfy early users. The final, complete set of features is only designed and developed after considering feedback from the product’s initial users. To find out more about the development process insides, check our Top 10 misleading ideas that don’t work in applications development article. Generally speaking, the minimum viable product is the first version of a mobile application or a website, which has only the crucial features that reflect the core idea of your startup. As your user base grows, so does your produ...

OCI interface to SQL Server
General approach to migrating Oracle applications with OCI interface to Microsoft SQL Server
12 Jun 2019

When migrating a customer’s Oracle databases to Microsoft SQL Server I often face the problem of updating relevant applications. A broad range of our customers use the Oracle Call Interface (OCI) to develop their database applications. Oracle Call Interface is the comprehensive, native C language interface to Oracle Database. Our customers regularly use the OCI interface to create custom and packaged applications. The problem This interface is specific to Oracle and you can’t use it to connect to any other database platform. So, a solution was needed to discover the right path to effectively remediate the customer’s С or C++ applicatio...

The DB Best Business Analysis
The flow and value of business analysis at DB Best
11 Jun 2019

The application development process is a multi-layered activity with the core idea as the starting point and a well-functioning final product as the top layer. In this post, we will focus on the twists and turns involved in bringing the idea through to the final product. IT business analysis is all about the elicitation of business and software requirements. The main goal at this stage is to put flesh on the bones for a client’s idea and to provide proof of concept for its realization. Hence, the business analyst who completes these tasks serves as a bridge between the client and the development team. They transmit the client’s vision a...

trace flag 1254 fixes SQL Server Error Message 3628
How Trace Flag 1254 Fixes SQL Server Error Message 3628 with Queries Using In-Memory Tables
09 Jun 2019

I recently ran into this issue with SQL Server 2019 CTP 2.5 where I was getting the error – Msg 3628, Level 16, State 1, Line 4 The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. It turned out that this would happen whenever I ran a query that joined In-Memory tables with disk based tables and the result ended up with no rows returned. Here is how trace flag 1254 fixes SQL Server Msg 3628 floating point exceptions. What causes Msg 3628, Level 16, State 1, Line 4 The Database Engine recei...

Report Support Tab
Power BI — Include a Report Support Tab — Episode 10
07 Jun 2019

Welcome to Episode 10 of my Power BI Best Practices Series. In today’s episode, I will show you how to include a report support tab in your Power BI report. This tab helps your users see where the data comes from. Also, here you can include your contact information, so the users of your report will know how to reach you if they have questions. Here we go! Include a Report Support Tab A report support tab stores auxiliary information. For example, you can place the data links here to easily discover the data source when needed. Also, you can place any other useful information on this tab. A report support tab is not mandatory. However, this ...