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
I’m not really a car guy. My daily driver is 10 years old but it serves me well. It’s reliable. It gets me where I want to go and back again. And I want to keep it that way so I maintain it. I change the oil regularly, I rotate the tires almost as often,…
Read more
We’re often asked to provide support during a crisis. Maybe a critical database is corrupt and no longer accessible. Or worse, an entire SQL Server instance is lost. Fortunately, many companies have a documented backup process. What’s far less common, however, is a well-documented process for restoring and recovering the critical databases. That part is…
Read more
“It takes forever to login to the clinical application. I have patients waiting. And I have to sit there waiting for the application to let me in. It’s not good.” Or, “I click the report and wait, and wait, and wait. Finally, I give up and hit Refresh. Nothing happens. Can’t you fix it?” Sound…
Read more
Some companies take virtual machine snapshots of their web servers, their file servers, and their Citrix servers. They regularly snapshot before software patching, before server upgrades, and before other configuration changes. Snapshotting a good way to ensure they can recover the VM if something goes wrong. So, that begs the question: should you use VM…
Read more
Cumulative Updates, CUs, are the way bug fixes and other improvements are released for SQL Server. These updates can make your SQL Servers more secure, they can fix performance issues, and they can make your system more reliable. But, as with any new code, they can sometimes introduce new issues. It’s not often that this…
Read more
“I bought some instant water one time but I didn’t know what to add to it.” – Steven Wright, comedian. I’ve always like Steven Wright‘s dry sense of humor and comedic timing. He’s got a lot of other great quotes similar to this one. Ok. But how does this relate to SQL Server? What’s really…
Read more
Users are complaining. One of your SQL Servers is not just slow, but slooooooooooooooooowwwwwww. A 6-syllable slow. We’ve all been there. We’ve all had SQL Servers that are underperforming. But where do you start with performance tuning? Let’s look to a proven approach for decision-making and troubleshooting as our guide – the OODA Loop. The…
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
Let’s have a look at implicit type conversions and how they can affect SQL Server’s performance. What are type conversions? Let’s start with the basics. What are data type conversions? (If you’re well-versed in this, feel free to skip ahead a bit.) SQL Server works with different types of data. It works with numbers, character…
Read more
Recent Comments