April 17, 2020
Why Should You Hire a Database Administrator?
Why would a company need to hire a dedicated database manager?
April 8, 2020
Firmware Bug in Certain SSD Drives will Brick Hardware at Exactly 40,000 Hours
“Neglecting to update the SSD Firmware will result in drive failure and data loss”
March 19, 2020
SQL Server Bottlenecks: Causes and Solutions
What causes SQL Server bottlenecks?
February 26, 2020
What Exactly Does a Fractional CIO ‘Do’?
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
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
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
October 23, 2019
How Partitioning Data Cut DTU Costs in Half
Drastically Improve Efficiency with a Partitioning Process
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.
July 9, 2019
Case Study: High Level Assessment For Supply Chain It Logistics Solutions
Problem A global organization providing supply chain IT solutions in the logistics industry relies heavily on its high performing databases to manage data from across the globe. Following a change in management, the new leadership wanted a clear picture of the organization’s database environment, how it was performing, and when certain upgrades would need to be made.
July 9, 2019
Case Study: High Level Assessment For Real Estate Development Company
Problem When a regional real estate development company underwent a change in leadership, the new leader set out to integrate operations and create a unified vision across each of the divisions of the company. Having traditionally operated each division as a separate entity, the new leader recognized the organization had an opportunity to create a more efficient organization. Prior to