Stay up to date with insights, tips, and education from experts in healthcare IT.
Ignore SourceID at your peril! When creating joins in a SQL query, best performance is often attained by including as many primary key columns in the JOIN predicates as possible. In Meditech’s Data Repository, the SourceID column is often overlooked, especially by SQL newbies. SourceID is the…
At the beginning of the pandemic, hospitals had to jump into action to find safer ways to deliver patient care without putting patients at risk of contracting COVID-19 in doctors’ offices and hospitals. The solution was telehealth, and it was widely adopted very quickly. A 2020 consumer…
Did you know how a patient copes with pain after surgery can impact their recovery? Many hospitals are using patient-controlled analgesia (PCA) pumps because it can make a recovery easier for the patient, alleviate nursing staff of frequently administering medication, and deliver additional benefits. In this blog,…
Smart pumps have been widely adopted into the healthcare space, and for a good reason. The potential for improved patient safety, time savings for nurses, and increased revenue should put Smart Pump EHR Integration (SPEHRI) near the top of every hospital’s priority list. But what exactly is…
Here’s a sad scene: You’ve been creating and scheduling SQL Agent jobs for years. You’ve got database maintenance jobs set up, backups, SSIS Packages to import and export data, SQL-only jobs to build datamarts. A whole ecosystem of finely tuned, perfectly running activities … all keeping your…
