The ManageForce Blog

Busting Myths About the Remote DBA

on 3/18/19 9:47 AM By | ManageForce | 0 Comments | Database Management Database Administration Remote DBA
Using remote support for database administration may seem like a scary prospect. What happens if something goes down? Will you be able to reach them? Would an in-house database administrator (DBA) be able to help be faster? There are a lot of questions to be sure.
Read More

Lost Your DBA? Here’s Your New DBA Replacement Strategy

on 3/12/19 1:09 PM By | John Hughes | 0 Comments | Database Management Remote DBA
Employee turnover is to be expected with any business, but it can be particularly disruptive when it comes to your IT team. For instance, if your database administrator (DBA) leaves, it won’t be long until your IT team feels stretched assuming the role of accidental DBA — picking up their tasks until a strong replacement is found and brought up to speed.
Read More

4 Signs You’re Finally Ready for a Remote DBA

on 2/25/19 9:42 AM By | John Hughes | 0 Comments | Database Management Remote DBA
If you’ve ever been told, “because that’s the way it’s always been done,” you know that’s the kiss of death for innovation. Yet, that’s the very reason so many organizations are stuck with sub-par database management solutions that either stretch IT resources too thin or rely on under-qualified staff (e.g. an accidental DBA) to manage this critical technology. In this day and age of constant digital transformation, the excuses to not have a solid support solution for your SQL Server, Oracle, or MySQL databases are dwindling.
Read More

Solutions for Managing the Modern Database: The Challenges of an Accidental DBA

on 6/19/18 9:43 AM By | ManageForce | 0 Comments | Database Management Database Administration Remote DBA
Putting a number on the full value of having a great Database Administrator (DBA) would be a nearly impossible task, to say the least. This role is responsible for not only managing the data that keeps your business up and running, but finding ways to truly optimize those systems to help your business thrive.
Read More

Get Your Databases in the Cloud Already

Technology is moving at a rip-roaring rate with advances being made every minute, accelerating and simplifying processes, however, not everyone is keeping up. Whether you’re still managing your Oracle, SQL Server, or NoSQL databases on premise, or making do with skill gaps in your IT department, the time has come to take a long, hard look at how you’re managing your databases.
Read More

3 Database Management Mistakes to Stop Repeating

on 1/31/17 4:31 PM By | Dan Ryan | 0 Comments | Database Database Management Remote DBA
No one ever said managing a database was easy. Last week we covered several steps that are often overlooked in database administration, this week we’re turning our attention to common database management missteps.
Read More

Who’s Watching the Shop this Holiday Season?

on 11/21/16 11:34 AM By | Mike Williams | 0 Comments | Database Management Database Administration Remote DBA
‘Tis definitely the season for good cheer, good fun, and vacation days. But while you and your IT staff are enjoying family, friends, and turkey, who’s keeping an eye on key business processes and services?
Read More

How Can a Remote DBA Get To Know Our Business Like We Do?

on 5/4/16 7:00 AM By | John Hughes | 0 Comments | Remote DBA
How can a managed service provider and their remote resources get to know our business as well as we do? Lots of potential clients understandably ask this question. How can an outsourced team possibly understand our environment as good as we do? That’s a fair question. But, the best, the absolute best, managed service providers won’t flinch at this question.
Read More

5 Reasons Why You Need An Experienced Remote DBA

on 3/17/16 11:30 AM By | John Hughes | 0 Comments | Database Management Database Administration Remote DBA
Whether your database is in the cloud or not, it’s the backbone of your ERP suite. In that light, you need an excellent DBA to keep everything running right. The abbreviation DBA does double duty here, and for the purpose of this discussion it stands for "database administrator." Its other well-known legal connotation is "doing-business-as." So, at the risk of torturing a pun, let's say that your database does its business by helping you do your business. Your business relies on database management because it meshes in with everything you do. Technology is at the heart of your enterprise; your operations are dependent on the applications you use, and the performance and reliability of these business-critical apps completely depend on the databases that support them.
Read More

How to Shrink and Compress Data in SQL Server

on 3/3/16 1:30 PM By | John Hughes | 0 Comments | Database Administration Remote DBA SQL Server
If your SQL database is the back end or foundation of your ERP, then applications are your business’s engine powered by its fuel. Your database is like a warehouse crammed with irreplaceable business history, intelligence, and the ingredients for business continuity. Yes, you need to keep your operation in shape and agile, so like the rest of your business, you must "right-size" your database. Right-sizing is the planning process that goes into the preliminary database design. You may have transitioned from Excel spreadsheets to the MS Access database because your spreadsheets became so deep and wide that you couldn't see all the trees in the forest. Databases are deep, but they must be kept as narrow as possible through sensible design. There are lots of great tactics to apply to keep databases agile and efficient. For example, an Access database text field can hold as many as 255 characters. So, if you're designing a table with a 255-character field that will never hold more than 20 characters, your database will eventually become unnecessarily fat and slow.
Read More


Recent Posts