Windows Server 2008
Windows Server 2008 — End of support
January 17, 2020

January 14th, 2020. What does this date mean for your organization? More so than with SQL Server, falling out of support for Windows Server will have immediate consequences to the security of your systems because of the frequency and volume of vulnerabilities and their subsequent patches. Click on the diagram to open an interactive Power BI report. January 14th, 2020 was the end of support for Windows Server 2008 and 2008 R2. And if this January is anything like every […]

DevOps blog post cover image
How we strengthened a healthcare startup with DevOps
January 17, 2020

In this blog post, we’ll cover the highlights of how we implemented DevOps technologies and managed to achieve zero downtime for the application deployments, eliminate a huge number of bugs by creating limitless development environments, shorten a full regression test cycle by a factor of 4, and enable a 15-minute infrastructure set up to replace their previous 4-hour set up! Long deployment cycles were limiting innovation A successful startup company providing unique software and hardware solutions for the healthcare industry needed to shorten […]

Collecting business-critical transaction throughput for analyzing using Power BI
January 14, 2020

In my blog post Using Power BI to analyze Windows Perfmon data for SQL Server, I introduced a concept that I call “business-critical transactions” (BCT) to understand the overall throughput of your SQL Server applications. When I worked on the SQL Server team, the SQL Performance Engineering team used a set of customer applications with server-side replay scripts that would get executed before development teams checked in their code. If a development team’s build showed significant regression in performance, they could […]

analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
January 13, 2020

In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it with Power BI. You can find the source code, Power BI reports, and other related files on my GitHub site at https://github.com/db-best-technologies/power-bi-for-sql-dbas. Here is a summary of what’s coming up in the series. It is subject to change based on feedback and reader demand: Capturing performance […]

anomaly detection
How we improved customer analytics with machine learning algorithms
January 08, 2020

Using multiple data sources often causes data to be out of sync. This results in data mess or conflicts and significantly affects your analytic reports. To make informed decisions, you need a proven automated solution that allows for discovering data anomalies. Especially when you operate with tons of data. The DB Best team utilized machine learning to build the anomaly detection tool for one of our customers. Our sophisticated solution improves the quality of data and helps take deliberate business decisions. In this blog post, we will show you how to make use of time series-based algorithms and the sequence of the steps for training a neural network.

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
January 04, 2020

Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]

DevOps process Oracle Forms
Automating Oracle Forms and Reports conversion with a DevOps process
January 03, 2020

The DB Best Oracle Forms and Reports Converter automates the conversion of your forms to a modern Web 2.0 architecture. We use the Oracle provided FormModules, ObjectLibraries, or MenuModules to XML command-line tool called Forms2XML along with the corresponding Oracle Reports convert to XML tools to start the process. Our converter then processes the source XML files to JavaScript files and SQL code fragments. In this blog post, we will show our best practices for incorporating our Oracle Forms and Reports […]

Careers portal icons
December 16, 2019

aws-icon oracle postgresql angular design-web html mysql node-js react-js sap technologies technology analytics asp-net augmented-reality azure azure-sql-dw bi bi-2 big-data classroom consulting dmo high_availability ios managed_services mobile mobile-2 partners result-oriented spacecraft sql_server ssrs training java Spring white-asp-net white-big-data white-evaluation white-high_availability white-in-memory white-modernization white-nosql white-proof white-ci-cd white-game-changer white-etl white-git white-unity3d white-waterfall white-3d white-agile white-arkit white-scrum white-swift 001 002 003 white-angular white-design white-html white-mysql white-node-js white-react-js white-sap white-technologies white-technology white-java white-tech-talks white-teams white-good-vibes white-Equipment white-Calendar white-Coffee white-Career white-Offices white-Sports-events Data-experts Good-vibes Infrastructure-2 […]

Challenges migrating SAS solutions to SQL Server – Missing Values versus NULL
December 10, 2019

Managers for a well-known accounting and tax-preparation company contacted DB Best looking for an alternative solution to a big problem. They were long term customers of SAS but were now facing two key challenges: high SAS license costs and the fact that SAS developers could not keep up with business demands and provide for effective support. The DB Best team analyzed our customers’ initial SAS solution and determined that the best possible option was to migrate their workloads to Microsoft […]

CI/CD best practices
Applying CI/CD for deploying data-driven applications after migrating from Oracle to Amazon Aurora PostgreSQL
December 02, 2019

When it comes to database migrations, application conversion/remediation along with functional testing of the entire system account for over 50% of the total effort. By using a proven CI/CD process, we’ve been able to reduce the overall migration time and create repeatable processes for on-going changes after the migration. In this blog post, we’ll talk about how we helped a large multinational software company with ambitious growth plans migrate their Oracle Database and Java solution to Amazon Aurora PostgreSQL. What used […]