convert SQL Server Standard edition to Developer Edition
How to convert a development server running SQL Server Standard or Enterprise edition to Developer edition
03 Jul 2019

I recently had a client using SQL Server 2012 Standard Edition on three of their development servers. However, SQL Server 2012 has a developer edition that is specifically designed for development servers. More importantly, our client has free SQL Server 2012 Developer edition licenses as part of the paid SQL Server Standard Editon purchase.
Our customer decided to convert their Standard Edition to the Developer Edition so they could save big bucks. However, the conversion process can be a bit tricky. In this blog post, we will show how you can easily convert SQL Server Standard Edition to the Developer Edition.

Oracle Forms Converter
Introducing the all-new Oracle Forms Converter
02 Jul 2019

A public sector organization from the US faced a problem with an outdated Oracle Forms-based solution. They had thousands of users but couldn’t keep the existing system running at an optimized quality and usability level. Their first option was to create a completely new web-based application to make their Oracle Forms run on the web. However, we at DB Best came up with a second, more cost-effective option that also saved time. We offered to transfer their Oracle Forms to an up-to-date JavaScript code as single-page applications (SPA) running on the web.
Find the details of the DB Best solution in our blog post.

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.
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.
Read more on our blog and be sure to watch the related video.

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.
Removing the MDW from SQL Server running in production is straight forward and requires that you follow the steps described in this blog post.

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.
Please note that you can not edit interactions if the report was shared with you. Also, by default, drilling one visualization has no impact on the other visualizations on the report page.
Find more details from this blog post.

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.
Discover the DB Best approach to schema mapping for Oracle to SQL Server migrations.

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.
Read the blog post to learn how you can determine, which of the visuals you should remove.

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.
For better understanding, we have a great example for you to compare the outcomes of different strategies.

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.
This interface is specific to Oracle and you can’t use it to connect to any other database platform. Read the blog post to discover the right path to effectively remediate Oracle’s С or C++ applications to the Microsoft SQL Server.

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. 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.
In this post, we will focus on the twists and turns involved in bringing the idea through to the final product.