Careers portal icons
30 Apr 2019

  aws-icon oracle postgresql angular design-web html mysql node-js react-js sap technologies technology analytics asp-net augmented-reality azure azure-sql-dw bi bi-2 big-data classroom consulting dmo high_availability ios managed_services mobile mobile-2 partners result-oriented spacecraft sql_server ssrs training java Spring white-asp-net white-big-data white-evaluation white-high_availability white-in-memory white-modernization white-nosql white-proof white-ci-cd white-game-changer white-etl white-git white-unity3d white-waterfall white-3d white-agile white-arkit white-scrum white-swift 001 002 003 white-angular white-design white-html white-mysql white-node-js white-react-js white-sap white-technologies white-technology white-java white-tech-talks white-teams white-good-vibes white-Equipment white-Calendar white-Coffee white-Career white-Offices white-Sports-events Data-experts Good-vibes […]

Managed Instance file growth
Beware — Azure SQL Server Database Managed Instance default file growth of 16 MB
27 Apr 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 […]

DB Best quality assurance strategy
The DB Best Quality Assurance Strategy
24 Apr 2019

Software development is a complex process that consists of multiple stages. Progressing through these stages transforms the software from concept and a basic visualization to the actual product with a state-of-the-art interface and competitive functionality. At DB Best we utilize 7 application development stages described on our dedicated landing page. The purpose of this post is to stress the importance of the testing stage as an essential element for product quality. So here we will share the fundamentals of our quality assurance […]

Healthcare applications landing page for
22 Apr 2019

How DB Best builds compliant healthcare solutions with Agile You must be wondering about building or upgrading your healthcare app. And, we have to say you need to make it HIPAA and GDPR compliant. In fact, that’s a bunch of work to do for meeting all the corresponding data security provisions. Luckily, we know how to do that for you! Overcome challenges on your way to HIPAA and GDPR (ВОЗМОЖНО МЫ МОЖЕМ ЭТИ 4 ПУНКТА ОТОБРАЗИТЬ ЕЩЕ И В ВИДЕ […]

Lost and found platform
Developing a worldwide lost and found platform
22 Apr 2019

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go.  Our customer wanted to develop a locator and tracking solution to create a global virtual Lost and Found community. Finding lost property Lost property offices are rapidly disappearing from hotels, stations, and other locations, yet people continue to lose or misplace things.  On average, people spend 150 days of their life looking for keys, laptops, luggage, and many […]

Advanced Engineering Application Modernization from Oracle to SQL Server
19 Apr 2019

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 […]

Power BI - Prepare Report
Power BI — Prepare Report Requirements — Episode 5
17 Apr 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 […]

convert Oracle synonyms to PostgreSQL
How to convert Oracle synonyms to Amazon RDS for PostgreSQL
08 Apr 2019

One of our ISV customers wanted to get off their expensive Oracle licenses and develop a cloud-based SaaS solution. They looked to us to help their development team migrate their database applications to Amazon RDS for PostgreSQL . The DB Best migration team utilized AWS Schema Conversion Tool (SCT) to automate the conversion of customer’s database and application code. However, the original system utilized a lot of specific Oracle features, for example, synonyms. SCT does not convert all types of Oracle synonyms […]

Power BI - Sub-divide & segment
Power BI — Sub-Divide and Segment Your Visuals — Episode 3
03 Apr 2019

Welcome to Episode 3 of my Power BI Best Practices Series. In today’s episode, I will show you how to sub-divide and segment your data visualizations in your Power BI Dashboards or Reports. To check out prior episodes and see where we are going, here is what BEST PRACTICES for Power BI is all about.
Be sure to check other episodes of the Power BI blog post series:

Power BI - Eliminate Unnecessary Columns
Power BI — Eliminate Unnecessary Columns — Episode 2
28 Mar 2019

Welcome to Episode 2 of my Power BI Best Practices Series. In this episode, I will show you the importance of eliminating unwanted columns from cluttering your Power BI Desktop Report. Be sure to check out prior episodes and see where I’m going with BEST PRACTICES below. Power BI — Eliminate Unnecessary Columns One of the major selling points of Power BI is the ability to transform massive quantities of data into easily-digestible visual information. However, showing data that isn’t essential for the story […]