How Fast is FAST?
25 May 2017

When listening to an online presentation a few days ago, the speaker suggested using one of my favorite, underused query hints: FAST N.  This replaces an older table hint called FASTFIRSTROW, which is one of the few deprecated features to actually be removed from SQL Server. The speaker suggested using the FAST 1 hint, because ‘sometimes it improves the query’, but didn’t say any more about how or why it would improve the query, and why you might NOT want to use it. So, I’m going to tell you what this hint does. When I first heard about the FASTFIRSTROW hint, years ago, it was described as a way to force SQL Server to use a noncluste...

Rolling Back a Transaction on a Memory Optimized Table
18 May 2017

After three and a half weeks with DB Best, things are starting to settle in. After attending the SQL Server 2016 Workshop in Bellevue, and delivering one section on In-Memory OLTP and columnstore indexes, I flew to Houston and delivered the entire Workshop on Friday, May 12. I did have local support from Peter DeBetta, also from DB Best, and John Cook, from Microsoft. The Houston Workshop reached capacity by the Monday before the event, but with John Cook’s help, along with his colleague Sean Kelley, we found a larger room and ended up with 19 attendees from 15 Houston area companies in attendance. We will be scheduling more of these Hands-...

Upgrading unsupported databases using DB Best novel tools
Automated sniffing technology of upgrading the unsupported SQL Server versions
16 May 2017

Our customer needed a way to upgrade their unsupported SQL Server databases to newer versions of SQL Server. The major challenge was that they didn’t have visibility into their system. Moreover, Microsoft upgrade tools can’t handle such outdated database versions as SQL Server 2000. With our innovative database discovery and monitoring tools, we were able to perform an inventory of their system. We developed an upgrade factory to get them back within Microsoft compliance. Now our customer has deep insight into their system and can take advantage of modern SQL Server capabilities with upgraded databases. (more…)...

Moving Oracle Forms to Web-Based User Interface
Moving Oracle Forms to The Web as a Part of Database Migration Project
16 May 2017

A government healthcare organization wanted to move their Oracle Forms to a modern web-based UI. We offered to migrate their source Oracle database to SQL Server while converting the deprecated Oracle Forms to the modern-looking web-interface. We used a previously developed technology to automate the major part of Oracle Forms conversion. To demonstrate the feasibility of this technology, we converted one the most complex forms. Having successfully completed the proof of concept, we convinced the customer to continue our partnership. Learn how we approached this database migration project from the following video. (more…)...

Optimizing database expenses by migrating from Oracle to SQL Server
Quick and easy automatic approach to database conversion
12 May 2017

One of the largest US educational organizations has been running their data handling system in Oracle environment. They wished to reduce maintenance costs due to expensive Oracle licensing model, which includes an additional fee for the partitioning feature. We provided the solution of migrating the customer’s database to SQL Server. Reconstruction of the original partitioning system in SQL Server allowed us to save extra money in addition to significantly lower SQL Server maintenance cost compared to Oracle. Check how we performed the migration to SQL Server and thus saved our customer’s money in the following video: (more&hell...

Developing mobile applications to shape the brighter future
12 May 2017

Staying on the cutting edge of modern technologies, DB Best application development team constantly strive to offer the best solutions for our customers. Simply watch the following video to see the examples of some cool features we can add to your business app be it a cinema house, a shopping mall or any other place, crowded with people. Let’s take a look at the impressive list of technologies that made the creation of this mobile application possible. (more…)...

Improving the web app performance while migrating from DB2 to SQL Server intro
Improving the web app performance while migrating from DB2 to SQL Server
04 May 2017

One of the largest life insurance companies in the United States supported a reporting application. Their system included Java based web app and Informatica data management solution connected to DB2 database. To provide a web interface for reporting needs they employed a WebSphere server for hosting Java application. With this interface, a small circle of users could create reports using data imported from Informatica application. Our customer wanted to reduce the maintenance costs and increase the application functionality. We came up with a solution to migrate the customer database to SQL Server and reconnect the application to the new d...

Oracle to SQL Server using SSIS
Remote migration from Oracle to SQL Server using SSIS
04 May 2017

A global financial software provider contacted us to migrate their billing solution from Oracle to SQL Server using SSIS for one of their strategic clients located at the other end of the world. They also needed to transfer data from Oracle to SQL Server using SSIS. The actual migration had to be performed by the remote team. In order to do so, our customer was looking for an automated solution with detailed step by step instructions. To meet the customer’s needs, we developed a command prompt migration utility accompanied by extensive documentation for a remote team. With our solution, the customer was able to migrate all data within the ...

Database Compare Suite update 4.8 brings Netezza support
03 May 2017

We’re excited to bring you the latest release of Database Compare Suite. The new version 4.8 brings support for IBM Netezza versions 7.2.1 and higher along with some other improvements. Covering All Major Database Platforms With the support of IBM Netezza, the total count of available database platforms in the Database Compare Suite reached the amazing total of 11. You can see the full list of supported database dialects on the image below. They include Amazon Redshift, Azure SQL Database, Greenplum, IBM DB2, IBM Netezza, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase ASE and Teradata. This means that you can use 55 heterogeneous a...