When we examine SQL Servers as part of our SEROShield SQL Server Health Check, we find five commonly overlooked SQL Server settings that can put performance, reliability, and even data at risk. Why are SQL Servers often misconfigured? SQL Server is robust. Microsoft has put a lot of effort into creating a database platform that…
Read more
I sliced into an avocado while making lunch recently. The size of the seed compared to the fruit was shocking! It was huge. There was only a thin layer of fruit surrounding a large, bulbous seed. Interestingly, some avocados are just the opposite – the seed is tiny compared to the amount of fruit inside.…
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
“Oh, we use VM snapshots to backup our SQL Servers.” We sometimes hear this when talking with companies, especially when we’re delivering a SQL Server Health Check Assessment. And why not? It makes sense. Companies take snapshots of their file servers. They snapshot of their web servers before upgrades. FTP servers, Citrix servers, and even…
Read more
In Getting Started with SQL Server in a Docker Container, I shared my SQL Server Docker container configuration. I described how to copy database backup files from your host to the container and then restore them in the container. That’s my usual approach. But what if you wanted the database to reside on the host…
Read more
You’ve probably heard of running SQL Server in a Docker container. The technology has been around for some years now. However it’s still unexplored territory for many. A SQL Server Docker container image is a lightweight and standalone package that includes everything needed to run SQL Server. It’s often used in DevOps as part of…
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
One of the first things we look at when doing a SQL Server Assessment (Health Check) is the SQL Server version and patch level. We don’t stop there, of course. We check a ton of other things that can affect the SQL Server’s performance, its security, and its reliability. But we start with the version…
Read more
“What’s the difference in SQL Server FCIs and AGs?” That question comes up frequently when talking High Availability and Disaster Recovery (HADR). It’s especially important when “Everything stops and people can’t do their jobs if SQL Server is unavailable.” There are a lot of how-to articles on the internet for setting up Always On Failover…
Read more
The call comes in. “Something’s happened. We need to restore the production database. Can you do it? And how long will it take?” No DBA wants to receive that call but, frankly, answering those calls and the ensuing questions are part of a DBA’s job. And there’s no better way to know that you can,…
Read more
Recent Comments