SUMMARY: Database Administrators (DBAs) must acknowledge that relying on common third-party backup solutions severely compromises data integrity, point-in-time recovery (PITR) capabilities, and recovery objectives (RPO/RTO) due to fundamental flaws like resource...
SUMMARY: XTIVIA's Virtual-DBA service enabled the Sweetwater Union High School District to overcome the challenges of an outdated database by successfully migrating its legacy Oracle system to SQL Server. The district decommissioned its expensive legacy Oracle system,...
SUMMARY: Database administrators must explicitly define port 636 within the LDAP:// prefix to correctly enforce Secure LDAP (LDAPS) communication for SQL Server ADSI-linked servers, thereby eliminating insecure cleartext credential transmission and resolving the...
SQL Server Transactional Replication is a powerful tool that can address many challenges in your environment. Setting up Replication is not difficult, but it can be time-consuming, depending on the amount of data you need to replicate. This is why some people dread...
SUMMARY: A database administrator faced a critical performance collapse during a multi-day data transfer of over 8.6 billion rows in SQL Server because the Query Optimizer, despite the presence of a clustered index, repeatedly forced an inefficient parallel Sort...
I was recently asked by a client to set up an easy way to monitor Replication Latency in SQL Server. The client wanted to be notified whenever data took more than 10 minutes to reach its destination. SQL Server does provide some built-in methods to help with this,...
SUMMARY: Database professionals facing surprisingly slow SELECT MAX() queries on massive SQL Server tables can eliminate costly billion-row Clustered Index Scans by intentionally introducing a non-partitioned Non-Clustered Index to provide the query optimizer a...
SUMMARY: SQL Server 2025 is designed as Microsoft’s AI-ready database platform, integrating machine learning directly into the database engine and leveraging Microsoft Fabric for unified data management. This enables businesses to achieve predictive analytics and...
SUMMARY: XTIVIA’s expert database administrators (DBAs) prevent massive cloud SQL Server budget overruns by deploying optimization techniques like query rewriting and configuration tuning, moving beyond the costly and temporary fix of blindly provisioning more...
Table of contentsFrom Debutante to Power Player: Key Enhancements Since SQL Server 2016SQL Server 2017: Hello, Wait Stats!SQL Server 2019: Auto-Correct, but for QueriesSQL Server 2022: Query Store World TourBonus Perks in Azure SQLSo… Should You Be Using Query Store...