Hear from our thought leaders, stay up to date with company news, and learn more about how we’re impacting our community.

Image
September 22, 2020

MySQL 5.6 End of Life Is Less Than Six Months Away

  MySQL 5.6 will hit support End of Life status in February 2021.
Tags:
Best Practices
Database Management
Microsoft
SQL Server
Read More
Image
March 19, 2020

SQL Server Bottlenecks: Causes and Solutions

What causes SQL Server bottlenecks?
Tags:
Database Management
SQL Server
Read More
Image
February 12, 2020

SQL Server 2019: Intelligence over Data

  SQL Server 2019 Updates and Improvements SQL Server 2019 released last November at Microsoft Ignite with a big message – SQL Server is redefining itself to extend beyond just the data relational space. The database landscape has changed alongside database engine requirements, and SQL Server is evolving along with their client’s data needs.
Tags:
SQL Server
Read More
Image
January 20, 2020

Case Study: Azure Migration for E-commerce Optimization Company

Problem An international e-commerce optimization company needed additional storage to accommodate its growing amount of data. When they attempted to purchase more storage capacity, they were faced with licensure issues due to hosting key functionalities on two separate infrastructures – Oracle and SQL Server. Solvaria worked with the business and IT to perform an analysis of the current space requirements
Tags:
Azure
Insider
Microsoft
SQL Server
Read More
Image
January 16, 2020

Best Practices for SQL Server Deadlocks

What Are SQL Server Deadlocks, And How Can You Avoid Them? Slow queries can negatively impact your users and systems when retrieving data from the database. SQL Server deadlocks happen when two queries are trying to retrieve the same pieces of information, and each query already has locked a piece of information the other needs. Query optimization can help the with speed
Tags:
Database Management
SQL Server
Read More
Image
December 5, 2019

Using SQL Server Technologies for Enhanced Data Security

Data is an extremely valuable business asset, and data security is rapidly becoming an extremely critical business concern in this increasingly connected and fast-paced world. When Solvaria’s client launched a client portal, we were called in to help keep the sensitive data they were receiving secure. Microsoft has developed several database technologies that Solvaria includes in our 24×7 Remote or
Tags:
Best Practices
Data Security
Database Management
SQL Server
Read More
Image
October 23, 2019

How Partitioning Data Cut DTU Costs in Half

Drastically Improve Efficiency with a Partitioning Process
Tags:
Azure
Database Management
SQL Server
Read More
Image
August 7, 2019

What you need to know about Microsoft ending SQL Server 2008 Support

  What Does End of Support Mean? As per the policy, after the end of the Extended Support period there will be no patches or security updates, which may cause security and compliance issues and expose customers’ applications and business to serious security risks. End of support for SQL Server 2008 and 2008 R2 is July 9, 2019.
Tags:
Database Management
Microsoft
SQL Server
Read More
Image
July 9, 2019

Case Study: Database Assessment For Global Nonprofit Organization

 
Tags:
Assessment
Oracle
SQL Server
Read More
Image
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
Tags:
Assessment
Best Practices
SQL Server
Read More