DevOps blog post cover
How we strengthened a healthcare startup with DevOps
29 Jan 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 the downtime for the applications update and decrease the number of bugs that appeared in the ...

Challenges migrating SAS solutions to SQL Server – Missing Values versus NULL
28 Jan 2020

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 SQL Server. In this post, we will talk about one of the challenges when migrating SAS DATA step modules to the Microsoft SQL Server — SAS missing valu...

analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
27 Jan 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 counters to optimize Microsoft SQL Server performance on AWS EC2 instances Using Power BI to analyze Windows Perfmon data for SQL Server — this blog pos...

CI/CD process case study
Creating a CI/CD solution for the database unification project
24 Jan 2020

Being an independent software vendor with a pile of applications written decades ago and a huge database in Oracle, our customer wanted to upgrade their software and make it more accessible for clients money-wise. They have built and sold applications for Oracle Database exclusively for 35 years. By now these solutions had become not only harder to sell due to competitiveness but difficult to support and modernize. Our client required applications’ upgrades, alternative cheaper hosting for users, and the maximum automation of processes around the applications and the databases. Within this project, we carried out unification and added t...

Windows Server 2008
Windows Server 2008 — End of support
23 Jan 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 month in 2019 you can expect another set of patches – which you won’t have access to. Microsoft does offer extended support, but the cost is significant. Instead, consider m...

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
22 Jan 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 the basics and grow the Power BI reports during this series. You can find the source code, Power BI reports, and other related files on my GitHub site at https://github.com/db-best-te...