Category: The Sero Group

Accelerated Database Recovery SQL Server

An Overview of Accelerated Database Recovery

SQL Server has had a number of really wonderful new features over the last several releases. One of those features is Accelerated Database Recovery. This enhancement has received some coverage in the community and I want to make my own contribution to promoting this feature. What is Accelerated Database Recovery? Accelerated Database Recovery (ADR) came…
Read more

sql server low disk space alerts

How to Use VSSADMIN Commands To Manage Low Disk Space

Low disk space alerts are a common occurrence in I.T. For SQL Server consultants, there could be a few causes: This last scenario related to volume shadow service is what I want to talk about today. This one can be a little confusing at first because your organization may get a low disk space alert…
Read more

IT decisions

Why Quiet Reflection Leads to Better IT Strategy Decisions

Last Saturday, I woke up before dawn to a quiet house. My family was still asleep, as I’m the only morning person in our household. The Christmas tree lights cast a warm glow across the room, and I was alone with my thoughts and a hot cup of coffee. No urgent emails, no fire drills,…
Read more

Happy holidays from the SERO Group

Cheers to a Joyful Holiday and a Bright New Year

As the year comes to an end, all of us at The SERO Group want to extend our warmest wishes to you. We hope that 2024 has been fulfilling and joyful and that you’ve had the opportunity to celebrate with your family and friends. The holiday season is a time for reflection and connection, and…
Read more

sql server conversations

Who Is Responsible for SQL Server?

Tell me what you think about this conversation. I must first clarify something about the conversation, though. It’s not an actual conversation I’ve had with a specific person or one prospective client. It’s not verbatim. Rather, it’s an amalgamation of many conversations I’ve had over the years. It starts when I ask who is responsible…
Read more

SQL Server DBA celebration

Preview Our New SQL Server Daily Health Check in an Upcoming Focus Group

Our team has been hard at work building the new SQL Server Daily Health Check Email and Dashboard. It’s designed to proactively deliver the information needed to keep your SQL Server environment healthy, secure, reliable, and running smoothly. And, we’d like your feedback on it. How the new SQL Server Daily Health Check works Here’s…
Read more

dba at a small to medium size business

4 Ways to Better Manage SQL Server Without a DBA

Microsoft SQL Server is popular. Statistics vary as to just how popular, but most agree that it is one of the most popular database platforms in the world. And for good reason. It’s feature rich, very reliable, highly scalable, and can be made extremely secure. All good things. According to a 2022 survey conducted by…
Read more

sql server constaints

The Goal: Removing SQL Server Constraints

“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

SQL Server looking up and out.

Looking “Up and Out” and “Down and In”

Halfway through my morning walk, I look up and see this amazing view. No filter needed. It was naturally stunning. I just stood there a moment soaking in the majesty of the view. The wisp of the clouds, the vibrancy of the colors, the reflection of the water. It was beautiful. And I almost missed…
Read more

sql server details matter

Don’t Sweat the Small Stuff, Except with SQL Server

Don’t sweat the small stuff, they say. That’s good advice. Much of the time. But with SQL Server, the small stuff is worth sweating. In fact, the small stuff can be big. Letting the small stuff go In life, the small stuff can weigh you down. Worrying about things that don’t really matter can strip…
Read more