“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
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
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
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
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
Recent Comments