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,…
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…
For today’s blog post, we want to help solve this common problem: how to limit the number of columns in a matrix to prevent it from exceeding the page width, when there may be any number of columns. The following information is based on Limit no of…
