Let me paint a picture you’ve probably seen before. Your network administrator, Tom, has been managing your SQL Server databases for the past 15 years. It wasn’t his original job, but someone had to do it. Over time, Tom became the only person who really knows how everything works. He knows which maintenance jobs run…
Read more
Last Saturday, I woke up before dawn to a quiet house. My family was still asleep, as I’m the only morning person in our household. The Christmas tree lights cast a warm glow across the room, and I was alone with my thoughts and a hot cup of coffee. No urgent emails, no fire drills,…
Read more
Query Store has been around since SQL Server 2016, but its full potential often goes untapped. Some companies were initially wary of it after some edge case problems arose during its initial rollout. However, since its initial release, Query Store has undergone numerous enhancements and is rapidly establishing itself as one of the most significant…
Read more
Editor’s Note: This is part one of a two-part series. In next week’s follow-up, we’ll cover the project management and coordination strategies that helped make this migration a success. What if you could retire two aging SQL Server 2016 failover clustered instances, migrate 1,200+ databases to SQL Server 2022, and slash storage spend by 84%—all…
Read more
How to Build a Business Case for Modernization In today’s always-on business environment, database downtime isn’t just an inconvenience—it’s a direct hit to revenue, productivity, and customer trust. Despite this, many organizations delay modernization efforts due to perceived costs and complexity. However, the real question is: can your business afford not to modernize? Read on…
Read more
As 2025 kicks off, organizations are eagerly setting new goals. For DBAs, a top priority might be preparing thoroughly for the next IT audit. Whether planned or unplanned, an audit can significantly impact how others perceive your IT department’s reliability. A seamless audit highlights strong governance and dependable systems, while missteps can reveal vulnerabilities and…
Read more
“This SQL Server is critical. It’s used 24/7. So, we’re behind on patching, and we disabled our scheduled preventative maintenance jobs because they interfered with production. Our database is just too important to do that. We know that maintenance is important, but we just can’t.” Does that sound familiar? I hope not. It’s not a…
Read more
Storing sensitive information in a database, like passwords or social security numbers, is common practice. However, storing them securely is less common. Unfortunately, one of the most typical approaches is to store sensitive information in a table as clear text. That means that anyone with access to that table can see all of that sensitive…
Read more
Since security and permissions are a big part of a DBA’s job, it’s important to be able to find out things like who has elevated login permissions or when a login was last used. Here are a few queries to help you check your server and database access. Most of these scripts are based off…
Read more
A common mistake database developers make in SQL Server is naming their stored procedures with the “sp_” prefix. Organizations sometimes even adopt this as a standard convention (along with the “tbl_” prefix for tables!). So, why is this considered a bad practice? It’s inefficient. The “sp_” prefix is used by SQL Server to designate internal…
Read more
Recent Comments