An automated solution for Crystal Reports conversion from Oracle to SQL Server
13 Aug 2018 Andrey Ivanov

One of our customers decided to modernize their Oracle database to Microsoft SQL Server. However, the thousands of SAP Crystal Reports connected to their existing Oracle database presented a huge challenge to their migration effort. They reached out to DB Best to develop an automated way to convert all of the connection information from Oracle to SQL Server and, more importantly, develop an automated solution that can extract the Oracle PL/SQL statements in the reports, convert them to SQL Server Transact-SQL, and insert the tested T-SQL commands back into the original report. In this blog post, we cover how we were able to pull this off for ...

Is making a mobile messenger app for a One Direction star ‘Too Much To Ask?’
02 Aug 2018 Andrey Ivanov

Quick question, what do you get when you mix a strong jawline, baby blue eyes, a sweet sultry singing voice, and our experience and expertise in mobile application development? Answer, Niallmojis. Niall Horan, the Irish pop star originally from the famous band ‘One Direction’ leveraged our mobile development experience to create an exclusive set of personalized stickers and animated avatars of Niall’s face all packed into a mobile custom keyboard application. Drawing from our experience in developing the world's first sound-based messenger, our developers were primed and ready to create a unique and free-flowing messenger experience. ...

Best practices for moving SQL Server to AWS: Amazon EC2 and RDS
26 Jul 2018 admin

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormous database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. Their overall goal was to move all of their applications out of their datacenter and over to Amazon Web Services through a lift-and-shift process. This blog post documents the best practices for moving SQL Server to AWS, specifically the Amazon EC2 and RDS environments which we developed as part of this project. How we mi...

Power BI dashboard
Out of the Ring: Building a One-Day Power BI Dashboard that crushed Sumo Logic
25 Jul 2018 Andrey Ivanov

One of our customers, a major software provider in construction, agriculture, and geospatial industries, has one of the leading solutions for building design and building information modeling (BIM). Just think about the complexity of designing a building and the complexities of designing, fabricating, and installing air ducts, plumbing, electrical wiring, etc. In order to improve the software for their customers, their software product that we'll call "BIM-APP" tracks all the user interactions and any system errors to log files. The development team for BIM-APP can then use the data from the log files to prioritize bug fixes and feature reque...

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 Jul 2018 Bill Ramos

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. - Judy Sheindlin We get it. You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business while keeping your data safe and you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end of its support life, and that means you’re about to have a range of new problems and issues with it. When Microsoft decides to finally pull the plug on SQL Server 2008 Support in July 2019, then eve...

Upgrade required: meet the new rules for mobile applications
19 Jun 2018 Andrey Ivanov

Apple and Google are setting new ground rules for mobile applications on the App Store and Google Play. This year will see the releases of iOS 12 and Android 9 Pie. That’s why both mobile behemoths are streamlining their platforms to prepare for future devices. With these changes, companies and developers are going to have to update their mobile apps or face a ban from the two platforms. However, there’s no need to panic. This inevitable app upgrade brings an incredible opportunity to capture a wider audience and cement your position as leaders in your field. (more…)...

Amazon Web Services in China
Mobile commerce, AWS, and the Great Chinese Firewall
13 Jun 2018 Andrey Ivanov

As a technology company there is a stark truth that exists every day: not all tech is created equal. For us, there was no greater example of this than when we crafted a global mobile app that had to work in China. While China has continued its upwards trajectory over the past two decades, they have maintained an increasingly strong approach regarding internet access and technologies available to their citizenry. When our client approached us to build their global app, we knew that we would face a myriad of technological hurdles related to the Chinese government’s rules and regulations. Our goal was to deliver the same high standards that ou...

Leveraging neural networks to create facial recognition mobile apps
06 Jun 2018 Andrey Ivanov

The eyes may be the window to the soul, but your face is the key for your phone. While facial recognition may have once been relegated to the world of science fiction, it is now our reality and plays such a common role in our everyday lives that few bother to think about the enormous technology and infrastructure behind it. For instance, Apple’s FaceID technology on their iPhone X utilizes their ‘TrueDepth’ camera system that projects over 30,000 dots onto a user in order to map the geography of the user’s face. But Apple isn’t the only company that employs facial recognition, Samsung and Facebook use it to unlock devices and tag pe...

migrating PostgreSQL to Amazon RDS Aurora
Improve PostgreSQL Performance 12X by Migrating to Amazon Aurora with Minimal Downtime
17 May 2018 Bill Ramos

An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity of their platform, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues including a daily batch script that was taking almost 2 hours to complete that was starting to exceed the maintenance window, and simple tasks like adding a new column to their largest table would time out. The main challenge for the migration project was that downtime could not exceed 6 hours and test efforts by their DBA team could never meet...

Removing unwanted objects
Remove unwanted objects from photos using an automated macOS solution
11 May 2018 Andrey Ivanov

Have you ever missed a photo op because you were in a crowded place and random people wouldn't get out of your way? Sometimes it can be almost impossible to take a clear photo in the real world. If you decide to try and wait for the people to clear out of busy areas, you might be standing there waiting forever! But, no more waiting, we have a much more time-effective solution! Watch the following video to learn more about the approach that we've used to remove unwanted objects from your cool photos. How does it work? Through our thorough research, we've discovered that we can attain crystal-clear still framed pictures from multiple, busy or c...