We currently support all of our FrameworkLTC applications on SQL Server versions from 2008 R2 up to 2016.
However, and this could be some bad news if you’re unaware,
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!)
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.
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.
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.
Discovery: All users were receiving the same error. Upon checking SQL, “FWDB (Suspect)” = Data corruption
Solution: Ran index maintenance overnight
Results: Restored the database
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.
Our very own Shan Bhide, VP of Technology, was interviewed by ComputerTalk last month. He talked about how software development requires innovation and creativity, and the disruptive technologies that could transform pharmacy practice.
Read the full ComputerTalk interview at https://www.computertalk.com/the-impact-of-disruptive-technology/
SoftWriters is excited for the opportunity to bring interns into our organization. The internship program allows students to use their knowledge in a real-world environment and we welcome the fresh and relevant perspective they bring to collaboration and project design.
Read Nick Hutchison’s experience interning with SoftWriters technology team!
The release notes and software are available on the Customer Engagement Zone (CEZ). Join us September 5, 2:00 p.m. EST for the FWLTC Release Notes Webinar. We will review these updates with a special focus on the Prospective Billing functionality. If you are not yet registered for the webinar series, the link is available on the CEZ under SUPPORT > WEBINARS.
In an ongoing effort to be proactive, transparent and forthcoming with errors, observations, issues and limitations related to FrameworkLTC software suite, SoftWriters has started publishing Known Issues and Limitations document (KIL) on the Customer Engagement Zone.
As FrameworkLTC is evolving into an enterprise-level clinical platform, it continues to offer end-to-end support for the majority of LTC pharmacy workflows. In order to deliver a stable and robust software upgrade and migration experience on enterprise scale to our customers, SoftWriters is moving towards a quarterly release cadence beginning Q1 2018. The first quarterly release is planned to be generally available by end of March 2018. This move fits very well with the overwhelming support that was shown by our customers during the 2017 Softwriters User Conference last year.