Health Dimensions Group (HDG) issued its “Top Trends in Aging Services 2019” report, detailing 11 developments that will shape the long-term care field’s future.
By Rick Magill
A continuation of the blog post Database 101-3: What is Index Maintenance?
In our last post, we said why it is extremely important to perform routine Index maintenance for your SQL databases. I thought we’d walk through a few cautionary tales of how not maintaining these indexes can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)
Database Best Practices
· Run daily / weekly Index Defragmentation
· Ensure proper backups / disaster recovery
· Install appropriate database integrity checks
What happens when the above isn’t executed? Here are some real-world issues that have been called in to SoftWriters, and how each situation resulted.
Issue: Over the last few months our system has slowed down.
Discovery: There was no blocking on the SQL server. Ran an index fragmentation script. Over 100 indexes were over 80% fragmented.
Solution: Ran index maintenance overnight.
Results: Improved performance speeds achieved.
Best Practice: Run index maintenance at least once per week.
Issue: No one can log in. It shows an error about something missing?!
Discovery: FrameworkLTC error that a stored procedure was missing. SQL was missing the entire FWDB; other databases were in a state of disarray. Ticketing system showed a recent upgrade from an older version that required a database migration. IT at the pharmacy had reverted from a backup of virtual machine that was mid-migration. SQL backups were being run daily, but were left on the virtual machine.
Solution: Restored the databases.
Results: The pharmacy lost three weeks of data.
Best Practice: Establish more efficient disaster recovery procedures like moving backups offsite for disaster recovery.
Issue: Complete pharmacy down!
Discovery: All users were receiving the same error. Upon checking SQL, “FWDB (Suspect)” = Data corruption
Solution: Ran index maintenance overnight
Results: Restored the database
Best Practice: Follow better database maintenance procedures such as running index maintenance at least once per week.
Rick Magill is a Solutions Consultant at SoftWriters, a Pittsburgh-based company that offers pharmacy management software solutions to pharmacies serving the long-term care community. Rick is an integral part of our customers’ success with his forward thinking and commitment to excellence.
Implementing a new software application often seems like a very daunting task, especially considering pharmacies typically don’t have the luxury of closing shop for a few days. The goals of improved workflow efficiencies, accuracies and business growth make the transition worth it, and with proper planning and expectation setting you can tackle implementing new technologies head on! Here are some helpful tips, best practices, and recommendations to help aid in the transition.
SoftWriters is excited to initiate a new monthly training webinar series. This series will cover a variety of important training topics that will be beneficial for FWLTC users to attend. All customers will be able to have input on the topics covered each month via a quick survey; registration and format will be similar to the monthly Release Notes Webinars.
Audits are costly and happening at an increased rate. They commonly occur 12x’s or more each year, requiring your team to spend countless hours sorting through and organizing paperwork. Costs skyrocket when one singular piece of documentation is missing. With FrameworkECM content management solution, one staff member could respond to an entire audit in a matter of hours.
Customizing your service to meet the unique needs of each facility you serve can strengthen your partnership and assist in delivering quality care to the residents. One of the most common areas for customization is on forms and labels. FrameworkLTC offers you the ability to completely customize your forms and labels.