by Heath McKerrow | Jul 10, 2025 | Blog, SQL Server
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...
by Ken Haff | Jul 2, 2025 | Blog, SQL Server
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...
by Lina Weiss | Jun 26, 2025 | Blog, SQL Server
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,...
by XTIVIA | Jun 24, 2025 | Blog, Microsoft, SQL Server
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...
by XTIVIA | Jun 17, 2025 | Blog, Cloud, SQL Server
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...
by Rebecca Mitchell | May 6, 2025 | Blog, SQL Server
SUMMARY: Since its debut in 2016, SQL Server Query Store has gained critical features such as wait statistics and automatic plan correction, evolving from a simple logging tool into an adaptive performance tuning partner that minimizes rogue query performance issues...
