July 9, 2019
Case Study: Upgrade Optimization For Pediatric Care Center
Organization Description This nationally recognized organization honors a mission that goes back more than a century: to bring health and well-being to all children. Their mission is the core reason they are now recognized as the premier pediatric care center in the Washington, DC area, and have seen more than 219,000 children from DC, Virginia and Maryland as well as
July 9, 2019
Case Study: Oracle to SQL for Tobacco Production Company
Problem When the leadership team of a tobacco production company wanted to initiate a re-platforming exercise from Oracle to SQL Server to better fit its evolving development focus with Microsoft technologies (.NET) and databases (SQL Server) and reduce costs from Oracle based technologies, they turned to Solvaria for help.
July 3, 2019
Case Study: Childfund – A Comprehensive Database Assessment
A global nonprofit dedicated to helping underprivileged children thrive.
April 3, 2018
SQL Saturday Richmond 2018 Recap
As active members of the SQL Server community, each year Solvaria serves as a Gold Sponsor at SQL Saturday Richmond. This year had a great turnout, with dozens of high-quality presentations given to more than 150 attendees.
July 31, 2017
Data Compression in SQL Server
In this blog we’ll share the benefits of Data Compression, what Data Compression is/isn’t, as well as some common compression scenarios. There are a few things to consider before starting Data Compression; and today we will share some of our implementation considerations. Saving space and saving money are the two main benefits of SQL Server’s data compression while also being
July 27, 2017
Business Continuity and High Availability: How SQL Server and Azure can help you achieve “The Nines”
Today we are going to share how to keep “The Nines” along with the principles needed to achieve High Availability. We will discuss how to know if your company needs High Availability and possible solutions for this change. A few definitions before we get started: Business Continuity (BC): The capability of the organization to continue delivery of products or services at
January 20, 2017
Deployment Planning Services – The (not so) Hidden Benefit of Microsoft Software Assurance
When a customer purchases a Microsoft product with Software Assurance under any program except the “Open License,” Microsoft provides Deployment Planning Service days (also known as DPS days) to ensure that your product is installed, configured and properly designed and architected for your environment. This service provides you with a custom deployment plan at the end of the engagement, and
November 7, 2016
SQL Server 2016: A Look Inside the Stretch Database
Many industries require keeping records that go back for several years. However, in reality, only records going back one or two years are often accessed. These non-accessed records are referred to as “cold data.” Cold data, while rarely accessed, still takes storage space and processing speed.