Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
The Role of the Persistent Version Store (PVS) The PVS is the heart of ADR. It acts as a dedicated storage area for data versions used for faster recovery. Imagine a timeline for your data – ADR captures snapshots at specific points in this timeline, allowing you to...
Our previous post discussed the critical importance of conducting a comprehensive risk assessment for your database management system (DBMS). A vital component of this process is selecting the appropriate risk assessment methodology. This blog post will delve into...
Ad Hoc Distributed Queries (Ad Hoc Queries) are SQL queries that use the OPENROWSET or OPENDATASOURCE functions to connect to remote data sources, which use OLE DB. This allows you to query data from multiple data sources in a single query. For example, you could use...
What is the ADR Cleaner Retry Timeout (min)? In SQL Server 2019 and later versions, Accelerated Database Recovery (ADR) employs an asynchronous cleaner process. This process runs periodically to remove unnecessary page versions, streamlining database recovery....
Understanding their security posture is paramount when entrusting sensitive data to a cloud provider. This blog post will delve into the various cloud provider security controls and certifications offerings, helping you make informed decisions. Understanding Cloud...
Database managed services are essential for distinguishing your business and meeting clients' diverse needs. Partnering with XTIVIA's VDBA allows you to expand your service offerings and deliver comprehensive IT solutions without the need to build in-house expertise....
SQL Server Ledger is a powerful feature that provides tamper-evident capabilities for your database. It addresses the critical need for data integrity and trust, especially when financial, medical, or other sensitive information is at stake. Here are some key points...
Data is often considered an organization's most valuable asset in today's digital age. As such, the systems that house and manage this data – database management systems (DBMS) – require meticulous attention and protection. This blog post will delve into the critical...
SUMMARY: To successfully transition from an on-premise to a cloud environment, a Database Administrator (DBA) must enhance their core technical foundation with cloud-specific expertise, advanced skills in automation and new technologies, and crucial soft skills. • A...
Attention MySQL users that are running MySQL 8.0.38, MySQL 8.4.1, or MySQL 9.0.0: The folks at Percona are sounding the alarms in a blog published last week. They identified a potential bug, of which mysqld will crash at restart if the database has more than 10,000...