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

What causes SQL Server bottlenecks?

People always ask me, “What does a Fractional CIO or CTO do?”   First and foremost, we are the individuals accountable for everything involving Information Technology at an organization.  We participate in all senior staff meetings for the company and assist with setting the direction for the organization as well as managing the day to day operations of the technology team.  Even as Senior IT leaders, fractional CIOs

  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.

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

A Year at Solvaria: 2019

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

What.A.Night! Thank you to sponsors, friends and supporters of 2019’s Betting Big on Tech Third Annual Charity Casino Night.  With your help, we were able to make a donation to CodeVA for over $32,000 while having some fun and spreading CodeVA’s mission of equitable computer science education for all Virginia’s students. Flip the gallery below to see the event photos!

Drastically Improve Efficiency with a Partitioning Process

SQL Server 2008/R2 support ended on July 9, 2019. Now is the time to build your modernization strategy, with Solvaria’s help to make migration painless and guide you through upgrades and revisions. If you’re unsure of your database upgrade needs, we invite you to speak with one of our expert DBA’s.