Cleaning up a disorganized SQL Server for informed business decisions
26 Jul 2019

For quite a period of time, our customer was using a SQL Server database that at the long last became disorganized and fairly difficult to arrange. The difficulties with finding and retrieving the right data negatively influenced their performance. In addition, their server was storing duplicating views and tables that utilized space. The problem Our customer considered hiring several data analysts to reinforce their team. However, extra people in the team couldn’t address the challenge for they weren’t aware of how and where the server stores the data. Regarding these problems, our customer could receive analytics based on invalid data. ...

naming convention
Defining a naming convention in Oracle to SQL Server migrations
17 Jul 2019

When migrating Oracle databases to Microsoft SQL Server, you need to define a naming convention for the conversion of packaged procedures and functions. This step is as important as setting the schema mapping and data type mapping. This is an architecture-level decision that you should make at the very beginning of your migration project. Now, we will talk about the importance of this decision and the possible issues it may cause. The problem By default, SQL Server Migrating Assistant (SSMA) uses the following rule to form the names of converted procedures and functions. Basically, SSMA combines the name of the Oracle package and the procedur...

DBBest post about misleading ideas in SW development
Top 10 misleading ideas that don’t work in application development
16 Jul 2019

The DB Best team has been building applications for more than 10 years now. These solutions include education, healthcare, social, entertainment, fitness, leisure, and many other sectors. And, a lot of them grew into established businesses and enterprises that started with a bright idea. The software development path that we follow and lead our clients through is very exciting. With every new project and task, we become wiser meeting new obstacles and handling them successfully. What we have learned at DB Best is to appreciate our triumphs. And even more important, we have learned to value the lessons the industry teaches us. So, we’d like ...

Power BI Premium limit
Reaching the limit with Power BI Premium resources
10 Jul 2019

One of our enterprise-level customers reached the Power BI capacity limit on dedicated cloud computing and storage resources. They already owned the Power BI Premium licensing package and didn’t want to spend more money to buy additional resources. What to do when reaching your Power BI Premium limit Reaching the resource capacity limit in Power BI may lead to serious consequences. Data models using this service will fail when refreshing through the gateway. The business will not get new data, causing all teams to fall behind on analysis of information. Typical solutions and their limitations The first approach to the above-mentioned probl...

Upgrade application 2019
Upgrade your mobile applications to meet the marketplace requirements in 2019
09 Jul 2019

Apple and Google set new rules for mobile applications on the App Store and Google Play annually. Even if you are not a developer, as a business person whose business is strongly associated with an application or a mobile platform, you should review them. So, let’s see what restrictions and updates we will face within the app market in 2019. It’s all about security The issue of security has everyone abuzz. Globally, users are letting developers know that they want their private data to stay private. They want to complete security when carrying out any transaction or when signing agreements. They also want to be sure that the millions of ...

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. The problem 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. And it’s not as easy as going into setup and changing the SQL Server edition from the 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. To reassure them of the quality of our solutions, we started with a trial engagement an...