sqlserver

The Top 15 SQL Server Security Myths

2023-06-122023-06-12
SQL Server Database Development, SQL Server Database Engine

As a SQL Server DBA, you are responsible for securing your organization’s critical data stored in SQL Server. However, there are many myths surrounding SQL Server security 🔒 that can lead to a false sense of security or even leave you vulnerable to attacks. In this blog post, I’ll be debunking the 15 most common security-related myths in SQL Server that every DBA should be aware of. So, grab a cup of coffee, and let’s get started! ☕

Too Many Plans for the Same Query Hash

2022-08-252022-12-31
SQL Server Database Engine, T-SQL
3 Comments

In today’s post, I’ll be providing a useful script to detect and troubleshoot when the query plan cache contains too many different plans for the same query hash, which could happen as a result of possible parameterization issues.