by XTIVIA | Mar 31, 2025 | Blog, Database
SUMMARY: XTIVIA’s Virtual-DBA service addresses the escalating costs of traditional database monitoring by replacing rigid, per-instance licensing with a predictable subscription model that integrates automated alerts with expert, US-based human support to ensure...
by Shane Schlabach | Mar 4, 2025 | Azure, Blog, Microsoft
SUMMARY: Microsoft is deprecating Transport Layer Security (TLS) versions 1.0 and 1.1 across Azure SQL services, requiring organizations to upgrade client connectivity to TLS 1.2 by August 31, 2025, to ensure data security and compliance. Azure SQL Database and...
by Monica Silva | Oct 22, 2024 | Blog, Database, MySQL
The Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access error occurs when MySQL rejects the LOAD DATA LOCAL INFILE command due to security restrictions. This can happen for various reasons, including server-side and client-side...
by XTIVIA | Oct 3, 2024 | Blog, Database
Is your database management becoming a bottleneck for your business? If you or your staff members are overwhelmed by the complexities of database administration, it might be time to consider a Virtual DBA or Remote DBA service. These interchangeable terms refer to a...
by XTIVIA | Aug 20, 2024 | Blog, SQL Server
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...
by XTIVIA | Aug 13, 2024 | Blog, Database
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...
