Transport Layer Security (TLS) is a cryptographic protocol designed to safeguard data in transit. While TLS 1.2 has been a long-standing standard, TLS 1.3 introduces significant technical enhancements that make SQL Server connections both faster and more secure. Learn more about it in this post.
Author: Yvonne Vanslageren
How to Set Up a SQL Server Always On Environment Using Docker Containers
Deploy a high availability SQL Server Always On environment using Docker containers. This step-by-step guide covers Dockerfile configuration, Docker Compose orchestration, and T-SQL scripts for enterprise DBAs and BI developers to ensure seamless CDC and database performance.
Natively Compiled Stored Procedures with in-memory OLTP in SQL Server
Modern applications often demand lightning-fast performance from their databases, whether they’re handling large transactional workloads or complex analytical queries. SQL Server’s in-memory OLTP feature addresses these needs by using memory-optimized tables and natively compiled stored procedures to boost throughput and reduce latency. This post provides an overview of natively compiled stored procedures, how to create them, and best practices for performance monitoring and maintenance.
SQL Server 2019 and the Memory Grant
When SQL Server runs a query, it needs memory for operations like sorting and joining data. It also relies on memory during query compilation to hold intermediate plans while the Query Optimizer finds the best execution strategy. In parallel processing scenarios, the memory requirement grows even further. SQL Server manages this by pre-allocating memory for each query through the SQL Server Operating System (SQLOS). This process ensures that no single query can monopolize the server’s memory
SQL Server Always On Health Check and Lease Timeout Monitoring
SQL Server Always On Availability Groups are a robust solution for achieving high availability and disaster recovery for SQL Server databases. However, simply configuring them is not enough—you also need a solid monitoring strategy to ensure data integrity and system reliability. One key aspect of this monitoring process is keeping an eye on lease timeouts, which can signal larger issues and help prevent potentially catastrophic split-brain scenarios. In this post, we’ll walk through the various health checks available for Always On Availability Groups, discuss how lease timeouts work, and explore practical methods for monitoring and troubleshooting.
Understanding and Resolving TempDB Contention in SQL Server
TempDB contention is a common challenge in SQL Server when running highly concurrent workloads. In this post, we will explore why it occurs, how to identify it, and some practical solutions—especially leveraging In-Memory OLTP and memory-optimized table variables.
SQL Server 2025 Teaser – Exploring the Innovations in SQL Server 2025
SQL Server 2025 is a significant milestone in database technology. Its advanced features empower developers, streamline operations, and support modern application scenarios. Find out why SQL Server 2025 will be such an exciting release!
Leveraging SQL Server 2019’s Last Known Actual Query Plan for Troubleshooting
Troubleshooting production performance issues is often challenging because detailed query execution data can vanish before you realize there’s a problem. Many times, you end up piecing together incomplete clues from runtime statistics or the plan cache. Fortunately, SQL Server 2019 introduced a powerful feature to address this pain point: the Last Known Actual Query Plan.
Understanding Worker Threads vs. CPU Utilization in SQL Server
When managing SQL Server performance, it’s important to understand the relationship—and the distinction—between worker threads and CPU utilization. These are two separate metrics that can behave independently. For instance, you might experience high CPU utilization while still having available worker threads, or you could have all worker threads occupied even when CPU utilization is low. This post takes a look at SQL Server worker threads and CPU utilization.
SQL Server’s Query Store: Understanding Plan Forcing and Performance Optimization
The Query Store in SQL Server is a powerful feature that enables database administrators and developers to track and analyze query performance over time. By storing runtime statistics and execution plans, it provides invaluable insights into how queries behave and how they can be optimized. This blog looks into the mechanics of the Query Store, the necessity of plan forcing, and how to effectively use it to stabilize and enhance query performance.