call us toll-free +1 855 855 3600
 
Home > Whitepapers
 

White Papers

 
 

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we […]

 

Read more

 
 
 
 

A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performance issues and needed an efficient solution to resolve them. Having analyzed the customer’s system, we delivered instructions with detailed descriptions of all discovered issues and approaches to fix them. With our instructions, our customer achieved more than three times better overall query performance.   Check […]

 

Read more

 
 
 
 

Upgrading SQL Server can be a complicated and nuanced operation, it can’t be simply performed with a few mouse clicks. In many ways, upgrading SQL Servers follows a similar process to more general database migration projects. Because of the similarities, we can apply our 12-step database migration methodology to great effect. From analyzing the existing database architecture to consolidating […]

 

Read more

 
 
 
 

A leader for a customer-to-customer platform for selling and buying old stuff managed a 6-terabyte database using an early version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity in their platform, they needed a way to scale performance and the size of the database near term to 15-terabytes. The main challenge was that […]

 

Read more

 
 
 
 

The DB Best SQL Sniffer is a network protocol analyzer for DBMSys application. It lets you capture, log and interactively browse database queries from SQL, Oracle and Sybase servers. SQL Sniffer also supports saving captured packets to a file for further analysis and allows to find out installed server versions. SQL Sniffer enables your organization […]

 

Read more

 
 
 
 

If your organization is heavily invested in a legacy Oracle database environment, you may be confronted with rising license renewal and support/maintenance costs for outdated technologies. To keep pace with rapidly changing business demands, consider working with DB Best to migrate to Amazon Aurora for increased business flexibility and cost-effectiveness. We offer expertise for customers […]

 

Read more

 
 
 
 

This whitepaper describes an automatic solution to deploying SQL Server Integration Services packages and projects with Visual Studio Team Foundation Server using PowerShell and T-SQL scripts.   The technique described in this paper provides a great framework for organizations practicing DevOps and development teams looking for a way to manage development and deployment of SSIS […]

 

Read more

 
 
 
 

Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues. Writers: Yuri Rusakov (DB […]

 

Read more

 
 
 
 

This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2014. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant (SSMA) v6.0 for Oracle is explained in depth, […]

 

Read more

 
 
 
 

Robert Davis (aka @SQLSoldier) provides clear guidance on the differences between Merge and Peer-to-Peer replication and how to decide which method is the right one to use for your particular scenario. Merge replication has been part of SQL Server since version SQL Server 7.0, released in 1998. Peer-to-Peer replication (P2P) is a newer topology first available […]

 

Read more