by XTIVIA | Aug 3, 2023 | Blog, SQL Server
Amazon Relational Database Service (RDS) is a cloud-based service that provides a scalable and managed database solution. Amazon RDS for SQL Server is a relational database engine based on Microsoft SQL Server that is hosted on Amazon Web Services (AWS). While Amazon...
by XTIVIA | Aug 2, 2023 | Blog, SQL Server
When it comes to choosing between hosting SQL Server databases on-premises, in Amazon Web Services (AWS) SQL Server RDS, or in Azure SQL, there are several factors that a Database Administrator (DBA) must consider. When evaluating cost savings, be sure to consider the...
by Mishkat Noor | Jul 27, 2023 | Blog, SQL Server
If you are looking to improve the speed of transactions, especially for high-concurrency workloads that involve a lot of inserts, update, and delete operations, you might benefit from implementing In-Memory OLTP and experience up to 30X performance gain, as some have...
by XTIVIA | Jul 26, 2023 | Blog, MySQL, SQL Server
When choosing between SQL Server and MySQL for your database product, it’s important to consider several factors, including your specific requirements, data storage and processing needs, and budget. Here is a comprehensive guide to help you make an informed...
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 XTIVIA | Jul 18, 2023 | Blog, SQL Server
Are you looking for a job as a SQL Server Database Administrator (DBA)? If so, you need to ace the technical interview and impress your potential employer. A SQL Server DBA is responsible for managing and maintaining the SQL Server database systems in an organization....