Skip to content
Home » sql server

sql server

SQL Server Index Mastery: Choosing the Right Column Order

It’s been a while since my last post about SQL Server performance optimization. This one focuses on index design and how the order of columns in your indexes can make or break your database queries. Using my insights from real-world consulting experience, this guide should help you understand the critical decisions that would impact your database performance.

How does SQL Server decide where to look first when executing a query? The answer lies in the structure of your indexes. Learn how the sequence of key columns can optimize your data retrieval, making your database faster and more responsive.

Read More »SQL Server Index Mastery: Choosing the Right Column Order

We need to talk about the elephant in the room – the future of DBAs

Hey there, pull up a chair, and let’s have a real heart-to-heart about what we all know has been happening this past decade in the world of DBAs. Yeah, I know, not exactly what you were looking for in my mostly technical blog, but stick with me here because this talk we’re going to have… Is very, very important.

You see, in this past decade or so, we’ve all noticed a trend where more and more businesses are looking for DBAs who know a bit about everything: RDBMS, NoSQL, Key-Value databases, Cache Databases, Full-Text Search Databases, Vector Databases, and more. In response, more and more data professionals prefer to become multi-disciplinary, doing a bit of everything… Even if it means becoming a part-time Data Engineer / Data Analyst / Data Scientist / DevOps / whatever. Otherwise, they fear that they won’t be able to find enough job opportunities.

But, there’s a cost to that approach. Sometimes a very high cost.

Read More »We need to talk about the elephant in the room – the future of DBAs

The Top 15 SQL Server Security Myths

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! ☕

Read More »The Top 15 SQL Server Security Myths

From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy

Introduction

As a DBA, your job involves much more than just managing databases. You must also work with customers to understand their needs and provide solutions that meet their requirements. In this blog post, we will discuss how you can implement the SPIN sales strategy concepts as part of your job.

Read More »From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy

Access Violation error when querying from a system table function with parallelism

Following an incident at a customer’s production environment, Nathan Lifshes and I realized that we stumbled upon a yet-unknown bug in SQL Server, causing an access violation error, memory dumps, dropped connections, and even cluster fail-overs.

Read More »Access Violation error when querying from a system table function with parallelism