“Why is my SQL Server slow?” Have you ever asked that question? Have your users? Unfortunately, that’s a commonly asked question. Fortunately, though, something can usually be done about it. Here are fourteen reasons a SQL Server instance could be underperforming. I’ve divided them into four broad categories. Slowness due to resource constraints Often the…
Read more
SQL Server is good. You install it, give it some databases to manage, and let it do it’s thing. When queries come in, it figures out how to resolve them. If it needs some statistics, it creates them. If the database is running out of space, it’ll grow the data file for you. Automatically. And…
Read more
Coach John Wooden is a legend. He led his beloved UCLA Bruins to ten NCAA National Championships in twelve years. That is an unparalleled accomplishment in any sport, in any endeavor really. So, I began wondering: what if Coach Wooden led a team of DBAs? What would he do? How Coach Wooden’s approach applies to…
Read more
“If three people are responsible for feeding the dog, the dog is going to starve. You must have clear areas of responsibility.” In his book Risk, retired United States Army General Stanley McChrystal shared this quote. It’s from a mentor he had as a young officer. And It helped shape his career. As a family…
Read more
In today’s world, we are constantly bombarded with a never-ending stream of urgent tasks and deadlines. It’s easy to get caught up in the daily grind and lose sight of the big picture. This is where inertia comes into play. And inertia can put your SQL Servers at risk. How urgency creates inertia Inertia is…
Read more
“My SQL Server hasn’t had any problems. It just works. Do I still need a SQL Server Health Check?” The TL;DR answer is yes, it’s good to check on your SQL Server regularly. SQL Server just works, but… The SQL Server development team has done a great job. They’ve created a database platform that is…
Read more
There’s a lot of hype surrounding the next version of SQL Server. And for good reason. SQL Server 2022 is packed with some long awaited niceties, improvements, and enhancements. Here are a few of the SQL Server 2022’s new features we are excited about. Contained Availability Groups Enhancements to Availability Groups and Distributed Availability Groups…
Read more
If you haven’t already done so, the time has come to say goodbye. In just six short months, SQL Server 2012 Extended Support will come to an end. And although it’s been a good version, it’s 10 years old. And that’s old database in years. To put it into context, here are a few other…
Read more
Have you seen the job boards recently? Hiring an experienced full-time DBA is expensive. And many companies simply cannot justify that kind of spend for a full time DBA, especially if they have fewer than a couple of dozen instances of SQL Servers in production. The result? Many companies are working without a SQL Server…
Read more
Hardening and protecting your SQL Server environment is not a one-and-done task. It’s a continuous process. Things change. New Applications are added. Logins come and go. Servers are migrated. In such a dynamic environment, auditing data access in your SQL Server environment is critical. If you are responsible for SQL Servers, you likely ask: Who…
Read more
Recent Comments