What do rainy days, backpacking, and SQL Server Disaster Recovery have in common? Over the past several years I’ve been section hiking the Appalachian Trail. For my first trip, I started at the southern terminus, Springer Mountain, Georgia, and hiked northbound for 137 miles to Nantahala, North Carolina. It took just over a week. Each…
Read more
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
The moon over my morning walk today. It was bright and beautiful. And under its glow, I realized that my morning walks have become an important routine for me. They are important for my physical and emotional health. They help start the day off on the right foot, so to speak. Similarly, routines are instrumental…
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
So, there you are cleaning up files to make additional space and you find a file named “db.bak.” It’s a SQL Server backup file, that much is clear. But what’s in it? When was it created? Is it important? Or can it go? Why can’t people name backup files so that they describe what’s in…
Read more
SQL Servers? Check. Important databases? Check. SQL Server DBA? Umm, no. Now what? If you’re like some companies, you’ve tasked a sys admin with keeping the SQL Servers running, in their spare time. Not optimal, but a full-time DBA is not in the budget. In an upcoming webinar, Working Without a DBA? A 10-Step Recipe…
Read more
It was 19 F at 5:15 AM as I laced up my hiking shoes. That’s cold for my part of the world. Each morning, I walk two to four miles to get the day started. Why? I’m preparing for my next 150-mile trek along the Appalachian Trail. I put in the time now so I…
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
Here we are at the dawn of a new year. It’s a great time to pause and reflect on your personal and professional goals. How did you do in 2021? If you’re responsible for SQL Server environment, you probably included goals for the SQL Servers. Maybe you wanted to increase performance? Or, maybe you set…
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
Recent Comments