Blog

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 ...

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. ...

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...

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...

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...

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…)...

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...

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...

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...

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...