Is Your Index Clustered Enough?
30 Jun 2017

When you tell SQL Server to create a regular clustered index on a table, it will completely rebuild your table. SQL Server will take your data rows and rearrange them on new pages. Your table’s pages become the leaf level of the clustered index, so sometimes we call the table a clustered table. People usually think of clustered as meaning ‘sorted’, and for the most part I’ll go along with this. But sorting can be logical or physical, and there has been much confusion and misinformation, even from Microsoft’s own documentation. For example, SQL Server Index Architecture and Design Guide. This document says: [If you want to return you...

video streaming app
Leveraging Amazon Web Services to build a set of video streaming applications
30 Jun 2017

One of our regular customers wanted to add video streaming functions to their existing web and mobile applications. As the developers of their original applications, we proposed to re-architect the application and move it to the Amazon cloud. The customer agreed, and we delivered a cost-effective solution for in-house video streaming, based on Amazon Web Services. Watch the following video to learn more about our technical approach to the upgrade and development of this application. (more…)...

Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 Jun 2017

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse platforms to Amazon Redshift. Wait, what if you don’t need to move all those terabytes of data, and just want to settle for the data generated in the past couple of years? Starting from the version 1.0.603, SCT allows filtering the data before uploading it to Redshift. In addition, the latest SCT version brings support to rather outdated Teradata 13 and Oracle Data Warehouse 10 schemas. In the following video, we will demonstrate how you can use the data extrac...

Integrating SQL Server data warehouse to improve operational efficiency
Data warehouse integration to embrace data analytics
27 Jun 2017

Our customer has been supporting Oracle based online transaction processing (OLTP) system. They decided to take advantage of the modern data analysis capabilities of SQL Server’s data warehouse features including columnstore for greater value over an Oracle based data warehouse solution. We came up with a comprehensive solution on extracting and transforming their source data and loading it into the target database. As a result, our customer benefited from obtaining a highly standardized and easily manageable solution within a short period of time. (more…)...

Is In-Memory OLTP a Useless Feature?
22 Jun 2017

What makes a feature useless? I might agree that if absolutely NO ONE uses it, or has ever used it, then it is useless, by obvious definition.  But if some people use it, but not everyone, is that useless? What if only 1% of product users employ a feature in production? Is that useless? What if those 1% base their entire production system around the feature? Is that more or less useless than another feature used by 80% of the installed customer base in only one or two queries, and for which there is another way to accomplish the same desk with equal efficiency? I suggest that there isn’t a clear way to measure uselessness, once the usage r...

Building detailed modernization roadmap for outdated databases using DBMSys
How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 Jun 2017

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys Platform. Using our detailed instructions they can substantially cut the upgrade expenses and take advantage of their workloads migration to Azure along with benefits from virtualization and consolidation options. (more…)...

Delivering expert support in resolving database conversion errors
21 Jun 2017

One of the major United States universities has been migrating their complex data managing system from Sybase to SQL Server. They used SQL Server Migration Assistant for Sybase to automate the migration process. However, SSMA tool could not deal with 100% of their source code, and their development team required some assistance with a manual conversion. So they asked us to provide technical support in resolving these conversion errors. With our guidance and extensive support, our customer was able to complete the migration within the short period of time. (more…)...

An ultimate approach to converting hierarchical queries from Oracle to SQL Server
Helping our customer to convert Oracle schemas with hierarchical queries to SQL Server
20 Jun 2017

One of the world’s largest information technology companies decided to migrate their Oracle database to SQL Server. They leveraged SQL Server Migration Assistant (SSMA) for Oracle to automate the major part of their migration effort. However, their source database code included over 400 hierarchical queries that SSMA could not convert. Neither could the customer’s technical staff. So, they turned to DB Best asking for assistance in converting a number of Oracle database schemas. We helped our customer to solve this complicated task by converting the required database schemas within the short period of time. Watch the following video to l...

AWS Schema Conversion Tool
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 Jun 2017

In Oracle you may use the conditional insert clauses, for example, an INSERT ALL statement to add multiple rows with a single command. You can insert rows into one table or even multiple tables using just one SQL statement in Oracle. However, PostgreSQL doesn’t support such statements that attempt to inserting multiple rows. So, when you try to convert the source Oracle code that includes the INSERT ALL statement to PostgreSQL in the AWS Schema Conversion Tool, it will generate the following action item: «9996 — Severity critical — Transformer error occurred». Let’s discover how you can address this issue. (more…)...

Oracle to Azure SQL Database shift may save up to $1 million
16 Jun 2017

‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natural for them to consider migrating to another database platform. We suggested changing their Oracle Database to Azure SQL Database and moving their applications to Azure services. However, the customer may well anticipate this Oracle to Azure migration solution. Why? Because according to the calculations made by our experts, they can save upwards of 1 million dollars just on licenses in the coming 5 years! The video below depicts the migration process in detai...