Stay up to date with insights, tips, and education from experts in healthcare IT.
Hospital IT staff have multiple projects competing for their time and expertise so it’s more important than ever to eliminate tedious, time-consuming tasks. One such task is updating information in multiple databases as the organization gains and loses employees. For many hospitals, this means updating profiles in…
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:…
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…
