by XTIVIA | Jul 18, 2024 | Blog, Database
The cornerstone of most businesses is a robust database. It houses the critical information that fuels operations, from customer data and product details to financial records and historical trends. But what happens when your Database Administrator (DBA), the guardian...
by Shane Schlabach | Oct 24, 2023 | Azure, Blog
Choosing a cloud provider can be difficult, with several options, each offering a wide variety of services. The two leading providers are Amazon AWS and Microsoft Azure, which combine for over 50% of the cloud provider market share. There are several others, but here...
by Lina Weiss | Jul 25, 2023 | Blog, SQL Server
A colleague of mine recently published a blog post explaining Virtual Log Files (VLFs) and why it is important not to have too few or too many VLFs. As a follow-up, this article discusses how to reduce VLFs when they have gotten too far out of control. The process is...
by Ken Haff | Jun 20, 2023 | Blog, SQL Server
What Are Columnstore Indexes? A columnstore index is a type of index that organizes data by columns instead of rows. This means that each table column is stored separately, and each value in a column is stored next to other values from the same column. This has...