Category: The Sero Group

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

sql server backup files are needed

How Often Should I Test My SQL Server Backups?

“People don’t want to buy a quarter-inch drill. They want a quarter-inch hole!” In the world of databases, stakeholders don’t care about SQL backups. They care about the ability to restore a SQL database.

CIO dreading SQL licensing costs.

Do I Really Need SQL Server Enterprise Edition?

“Do I really need the SQL Server Enterprise Edition license? Or will SQL Server Standard Edition work for us?” That’s a question most every CFO, CIO, VP, and Director with a SQL Server environment and budgetary responsibilities has asked. The reason is obvious. SQL Server Enterprise Edition is expensive. How expensive? According to Microsoft’s web…
Read more

Stop doubting your sql server environment

Five Goals for Your SQL Servers in the New Year

We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next 12 months at work, and more specifically, what you would like to do with your SQL Server environment this year. To help with that, here are five activities or goals…
Read more

Who Owners Your SQL Server Database and how to change it

Who’s the SQL Server Database Owner and How Can You Change It?

In SQL Server, when someone creates a database, they own it. That means they have elevated permissions on the database. The SQL Server database owner can change configuration parameters, perform maintenance, and grant permissions on the database to other users. The database owner can even drop the database altogether. In highly secure environments (and what…
Read more