Blogs

Stay up to date with insights, tips, and education from experts in healthcare IT.

One day you write some code on a new system, or using tables in the database you’ve never used before, and BOOM! A perfectly ordinary query blows up… what is this collation business??! SQL Server collation determines how character (char, varchar, nchar, nvarchar, etc.) columns are handled…

During our second iatricSystems Fall Exchange, we brought together industry leaders and healthcare organizations to discuss today’s challenges, including the current threat landscape and how to protect your organization from internal and external threats. One highly attended session was The True Cost of a Data Breach and…

Drug diversion among healthcare workers is ultimately underestimated, undetected and under-reported. According to Porter Research, roughly nine out of ten healthcare professionals have met or know someone who has diverted drugs, and 40 percent of hospitals lack programs to prevent this commonality from happening. So, what is…

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…