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

Tracking down discontinued SQL syntax with SQL Sniffer and Replayer
24 Aug 2016

Do you still have SQL Server 2000 database servers running in your organization? Do you have SQL Server 2008 R2 or older database servers running with databases using compatibility level of 80 for SQL Server 2000 compatibility? Running the SQL Server profiler over an extended period of time looking for deprecated and discontinued syntax may not be an option either. At DB Best, we have developed a solution called SQL Sniffer that works at the network switch level to solve this problem. By using the port mirroring feature at the network switch, SQL Sniffer looks for SQL statements coming from applications to specific SQL Server instances. SQL S...