Stay up to date with insights, tips, and education from experts in healthcare IT.
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…
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…
About Us
Solutions
Learn
Get exclusive offers sent straight to your inbox.
© 1996-2025 Iatric Systems, Inc. All Rights reserved.
