Stay up to date with insights, tips, and education from experts in healthcare IT.
Whenever a hospital takes on a Smart Pump EHR integration (SPEHRI) project, there are usually measurable goals or outcomes around compliance and patient safety initiatives that are initially established to determine if the project is a success. It’s important to establish the primary goal along with the…
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…
