人民日报谈精准扶贫：不能"排排坐分果果"

A tailor-made solution for the dental industry

Since 2010 RevenueWell has delivered SaaS solutions specifically for dental practices. Their comprehensive platform encompasses a suite of services including marketing automation based on patient data, patient portals and billing, customer websites, search engine optimization, and social media. By bringing their most critical business functions together into one easy to use portal, RevenueWell helps their customers save time and money, while moving their businesses forward.?

A key component of the RevenueWell solution is the deep integration with multiple Practice Management Solutions spanning on-premises and cloud. This hybrid integration is unique in the market and has enabled RevenueWell to support the rapid growth to over 12,000 dental practices across the United States making RevenueWell a market leader in dental industry.

Rapid growth and innovation

The rapid adoption of RevenueWell exposed the constraints of their on-premises based solution including issues with latency, scalability, management, and maintenance. RevenueWell needed a dynamic solution that could scale with them, keep their mission critical workloads online at all times, and enable them to easily adopt the latest technologies. They turned to Azure SQL Database.

Selecting Azure SQL Database was an easy decision for RevenueWell. “We were already a Microsoft Certified Partner. Azure SQL Database was a natural fit and the integration with SQL Server on-premises was really good” shared Matt Nisnevich, RevenueWell Sr. Developer & DevOps Engineer.?

After moving to Azure SQL Database, RevenueWell saw a dramatic decrease in maintenance coupled with an ability to scale their workloads as needed. This new flexibility drove huge business growth and RevenueWell doubled their customer base in only 18 months.?

Flexibility for Hyperscale growth

In late 2021 RevenueWell won the exclusive endorsement of the ADA for dental marketing software. As business continued to soar the team needed additional scalability and flexibility. With Azure SQL Database they didn’t need to look into a new solution but were able to simply move to the?Hyperscale service tier?with?premium series hardware for optimal performance. The transition was seamless. “One of the most important things from a DevOps perspective was that nothing from the application side had to change. We didn’t have to reconfigure or redeploy our existing applications” recalled Director of Engineering, DevOps, Ilya Mazya.?

A significant factor to RevenueWell choosing the Hyperscale service tier was the ability to independently scale compute and storage. This allowed them to rapidly scale up or down compute resources as well as automatically scale out storage for their expanding customer base, supporting compliance with rigorous HIPAA data storage regulations.?

The separation of compute and storage also enabled backups to be pushed to the storage layer via?snapshots, eliminating performance implications on the database and resulting in restores that occur in minutes – irrespective of the size of the database.

RevenueWell used serverless and provisioned compute tiers to optimize further.?Serverless?automatically scales compute of a single database based on workload demands - billing for only what is used. ?Hyperscale elastic pools enables provisioned resources to be shared across a set of databases within a defined budget – enabling quick scale up of individual databases when needed. “We have some databases which are not used most of the time, and then there may be a spike. Keeping database with intermittent usage patterns as serverless is a huge cost advantage. Having the database scale up only during the times we need it, without paying for provisioned resources” shared Nisnevich. “When elastic pools came out, we were able to create databases without worrying that we were taking up dedicated resources for every single database when each one would have small periods of spike once in a while”.

In addition to Azure SQL Database Hyperscale, RevenueWell uses many Azure Services for a comprehensive solution to power their SaaS solutions. Azure Synapse provides near real-time insights for RevenueWell's customers to improve their business. Azure Cosmos DB offers a schemaless development approach, supporting multiple data models for flexible data storage and querying. Service Bus enables the decoupling of applications through an enterprise-grade message broker. Azure Event Hubs handles high volumes of event streaming for real-time data ingestion and analysis. Finally, RevenueWell uses the Premium Tier of Azure App Service to facilitate rapid development, hosting, deployment, and scalability of web applications and APIs.

As an innovator on the leading edge of healthcare technology, RevenueWell looks to Microsoft’s latest releases to support their ongoing improvements.?

An agile path forward

The migration to Azure SQL Database immediately freed up dev resources previously used for database management and maintenance. This allowed the RevenueWell team to focus on product development and customer value. Moving to the Hyperscale service tier with premium series hardware delivered 20-30% faster query performance and accelerated their ability to develop, test and deploy solutions.?