Blogs

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

The issue of drug diversion in healthcare is a major problem, with considerable consequences. What many may not know, is how prevalent this problem is and what impact the pandemic may have on it. Drug diversion puts the patient, the diverting employee, and the facility, at risk…

Unauthorized access to patients’ protected health information (PHI) is illegal—so why do healthcare professionals keep doing it? How do you get them to stop?A recent JAMA Network study on PHI breaches provides insights into employee behavior regarding privacy data, and how that behavior can be corrected. Introduction:…

Drug diversion has continued to be a major problem in healthcare, one that has considerable consequences. Since the onset of the COVID-19 pandemic, the problem has continued to become more and more prevalent. Approximately 10 to 15% of all healthcare professionals will misuse drugs or alcohol at…

It is rare that this will come up, but in certain circumstances you may need to change (or guarantee) the database in which a query executes. This can really plague you when you’re working with multiple databases on multiple servers. You don’t want to forget which database…

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…