Table of contentsThe Challenge: Remediating LDAP Simple Bind in SQL ServerThe Initial Query: A Standard ADSI OPENQUERYThe LDAPS:// Pitfall and the Dreaded Msg 7321The Correct Approach: Explicitly Defining the Secure PortBeyond Syntax: A 3-Step Security Validation...
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...
Table of contentsThe Setup: A High-Stakes Data TransferThe First Clue: A tempdb Under SiegeThe Usual Suspects: A Process of EliminationThe Smoking Gun: When Parallelism Turns Against YouThe Final Showdown: Trusting Your GutLessons from the Trenches The Setup: A...
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,...
Table of contentsA Simple Query with a Devious ProblemWhen Partitioning Works Against YouThe Counterintuitive Fix: Adding a "Duplicate" KeyDon't Trust the Icon: Read the Real Execution PlanKey Takeaways for Data Professionals A Simple Query with a Devious Problem It's...
Table of contentsWhy SQL Server 2025 is AI-Ready: The Future of Data Management1. Seamless AI Integration in SQL Server 20252. Performance Enhancements for AI Workloads3. Predictive Analytics and Automated InsightsThe Role of Microsoft Fabric in SQL Server 20251....
Table of contents"The Oops, I Scaled Too Much" SyndromeXTIVIA: Your SQL Server Sherpas in the CloudCloud Platform Agnostic (But with a SQL Server Obsession)Stop the SQL Server Madness! Let's face it: Cloud SQL Server instances are fantastic. They offer scalability,...
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...
EagerZero vs. Quick Format: A Comparison When it comes to formatting drives, there are different methods available, each with its own set of advantages and disadvantages. Two common methods are EagerZero and Quick Format. Here's how they compare: EagerZero Format...
Are you tired of the headaches of managing your SQL Server database on-premises? It's time to consider the benefits of a cloud-managed solution. While both options have advantages, significant differences can impact a DBA's day-to-day responsibilities. Let's dive into...