Franklin,TN 37067
+1 (888) 412-7376
info@theserogroup.com

Blog

Are Information and Data Lifecycle Management Processes Different…and Who Cares?

Are Data Lifecycle Management (DLM) and Information Lifecycle Management (ILM) just fancy terms for the exact same thing – namely, data management? Will understanding these terms actually impact your data strategy in any meaningful way? Will knowing this distinction affect your business at all? Recently, we began a series of posts on data strategy by…
Read more

Why is SQL Server slow?

Why is My SQL Server Slow? 14 Common Reasons

“Why is my SQL Server slow?” Have you ever asked that question? Have your users? Unfortunately, that’s a commonly asked question. Fortunately, though, something can usually be done about it. Here are fourteen reasons a SQL Server instance could be underperforming. I’ve divided them into four broad categories. Slowness due to resource constraints Often the…
Read more

sql server data storage strategy

10 Data Storage Considerations for Growing Companies

As the business world becomes more and more data-centric, what questions does your growing company need to ask about its data storage? Recently, we began a series of posts on data strategy by asking whether your company data is an asset or a utility. In this post, we will look at 10 key data storage…
Read more

SQL Server heartbeat

Why is it important to monitor SQL Server?

SQL Server is good. You install it, give it some databases to manage, and let it do it’s thing. When queries come in, it figures out how to resolve them. If it needs some statistics, it creates them. If the database is running out of space, it’ll grow the data file for you. Automatically. And…
Read more

sql server data utility or asset

How to Justify IT Spend: Is Company Data an Asset or a Utility?

How do you justify investment in IT? That’s a commonly asked question for companies whose core business area is not technology. For many, it is a challenge to justify investment in technology. The primary purpose of IT, as some companies see it, is enabling the operation of the business. It’s not driving revenue. Every business,…
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 FAQ

What’s the Difference in Index Defrag and Rebuild?

If you’ve worked with SQL Server for very long, you’re probably familiar with the concept of indexes. Indexes can help speed up queries by allowing SQL Server to quickly locate specific data values within a table. Indexes are typically much smaller than their underlying tables so they can be searched much more efficiently. (They aren’t…
Read more

Coach Wooden the DBA

If Coach Wooden Led a Team of DBAs

Coach John Wooden is a legend. He led his beloved UCLA Bruins to ten NCAA National Championships in twelve years. That is an unparalleled accomplishment in any sport, in any endeavor really. So, I began wondering: what if Coach Wooden led a team of DBAs? What would he do? How Coach Wooden’s approach applies to…
Read more

Who's caring for your SQL Servers?

Who’s Caring for Your SQL Servers?

“If three people are responsible for feeding the dog, the dog is going to starve. You must have clear areas of responsibility.” In his book Risk, retired United States Army General Stanley McChrystal shared this quote. It’s from a mentor he had as a young officer. And It helped shape his career. As a family…
Read more

The need for High Availability and Disaster Recovery

HADR for Crying Out Loud

I was on my morning walk recently when I noticed this laying on the walking path. Some call it a binky. Others a pacifier or fooler. Whatever you call it, it’s an essential piece of equipment for some infants. Without it, their world falls apart. And the calamity is contagious. They, and everyone around them,…
Read more