Database 101-9: Why should you care about database maintenance best practices?

Database 101-9: Why should you care about database maintenance best practices?

I thought we’d get into those best practices once more, and walk through a few cautionary tales of how not maintaining these best practices can impact your pharmacy. (Spoiler alert: all are less than ideal situations for your staff and customers!)

Database 101-6: What does Page Life Expectancy (PLE) do to your database?

Database 101-6: What does Page Life Expectancy (PLE) do to your database?

So how can you tell if you’re giving SQL a big enough “desk”? There are different metrics around memory usage that can help you figure that out, but the most common one is called Page Life Expectancy. 

Database 101-4: Why should you care about Index Maintenance?

Database 101-4: Why should you care about 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 101-1: Tables and Indexes

Database 101-1: Tables and Indexes

Ryan Huber and Rick Magill presented “Database Optimization and Performance Improvements” as a breakout session at our conference last month, and due to it’s popularity we’re sharing it as a series of blog posts. This post covers tables and indexes.

Thank you for a great conference!

We would like to thank everyone who attended the 10th Annual FrameworkLTC User Conference last week! We truly enjoyed spending time with all of you. Just a few quick reminders for attendees:

  • CE accreditation is available until October 13th

  • The conference app will remain open for a few more weeks if you’d like to access presentations, etc.


We look forward to seeing you next year: mark your calendars for September 17-19, 2019 at Caesars Palace in Las Vegas for the 11th Annual User Conference!

MHA and SoftWriters Announce New Initiative to Deliver Best-in-Class Solutions and Help Long-Term Care Pharmacies Succeed

MHA and SoftWriters Announce New Initiative to Deliver Best-in-Class Solutions and Help Long-Term Care Pharmacies Succeed

Going forward, SoftWriters, which develops innovative pharmacy management software solutions for long-term care pharmacies, will be responsible for the support, delivery and further development of RxPertise, the acclaimed Medication Regimen Review (MRR) software application for consultant pharmacists specializing in long-term care. This combination of best-in-class solutions and industry-leading expertise is designed to align and strengthen our software offering with the emphasis on how MHA and SoftWriters can help long-term care pharmacies compete, be more efficient, and reduce costs.

The Impact of Disruptive Technology

Shan Bhide, Vp of Technology, SoftWriters

Shan Bhide, Vp of Technology, SoftWriters

 

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/

Making software, in my mind, is more of an art than a science. It takes so many different things, like teamwork, collaboration, thinking outside the box, and creativity, to build an amazing software solution.
— Shan Bhide, VP of Technology at SoftWriters, in an interview with ComputerTalk's Maggie Lockwood

A Summer Intern's Experience At SoftWriters

A Summer Intern's Experience At SoftWriters

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!