The ManageForce Blog

How to Plan an Efficient Microsoft Access to SQL Server Upgrade

on 5/16/19 2:01 PM By | John Hughes | 1 Comment | Database Database Management SQL Server
If you are using the Microsoft Access database management system, your demands will likely outpace both its capacity and computational limits. Handling these hurdles (hopefully with the right database support solution) before they become problems will be critical to keeping your databases running smoothly. You and your team may have identified inefficiencies or performance issues and determined your database is, or will soon be, ready for an upgrade. Just as your business quickly outgrew those handy Excel spreadsheets, your database is now slowing down and taking up more and more of your precious IT resources. If you fit this description, it’s probably time to transition to Microsoft SQL Server, either locally or in the cloud.
Read More

How to Avoid an Accidental DBA Pitfall

The “Accidental DBA” is a database management pitfall we’ve covered before, but it’s one we see all too often and bears repeating. The name itself speaks to less-than-ideal database management circumstances. Picture this: An under-qualified IT team member (through no fault of their own) is left with the charge of managing the company’s most critical data, simply because they have the most bandwidth (probably not enough) and a “good enough” database management knowledge base (but far from being an expert). While this solution may keep things running for the most part, your databases deserve (and need) more than “good enough.”
Read More

Is it Time to Rethink Your Database Management?

Modern organizations are leveraging cloud-based database solutions more and more for increased accessibility and flexibility. However, even with the improved efficiencies of the cloud, databases still need consistent monitoring and support to optimize performance and handle any situation that may arise. As database solutions evolve and improve, so too do the demands and requirements of managing them.
Read More

What's New In SQL Server 2019?

on 10/23/18 11:34 AM By | ManageForce | 0 Comments | Database SQL Server
Microsoft recently announced their first public preview of SQL Server 2019 at the Ignite 2018 conference. SQL Server 2019 stands out from other relational database software not only from its new and enhanced features but from the significant increase in data efficiency it provides its users.
Read More

SQL Server 2017: What You Need to Know About the Latest Updates

on 9/13/17 10:26 AM By | John Hughes | 0 Comments | Database Management SQL Server
The SQL Server 2017 update has brought some significantly upgraded capabilities to its database engine, integration services, master data services, reporting services, and more. It’s also brought the power of SQL Server to Linux, Linux-based Docker containers, and Windows. All of these updates mean more insights, simpler processes, better database performance, and plenty of changes for on-premise and cloud database services.
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