Stay up to date with insights, tips, and education from experts in healthcare IT.
Recently while working a regulatory report I found myself faced with needing to identify the first (or earliest) of a set of dates. Each date came from a different possible order related to the patient visit, and I needed to chunk through 10 different JOIN-ed tables and…
In support of Cybersecurity Awareness Month, we’ve shared tips so far for “Owning It” with remote access security, “Securing It” with multi-factor authentication, and today I want to talk about “Protecting It” and the potential costs of a HIPAA violation if you aren’t able to protect it…
Your facility may be gearing up to integrate Appropriate Use Criteria (AUC) into your existing physician order workflow, which is the program established to increase the rate of appropriate advanced diagnostic imaging services provided to Medicare beneficiaries. The mandate from CMS is that the program needs to…
When we’re working on other people’s code–for troubleshooting or optimization purposes–we see a fair amount of usage of the ISNULL() function. Generally speaking we replace those ISNULL() references with COALESCE(). But why? There are a number of reasons: First, Microsoft has indicated they may deprecate ISNULL() in…
Think of it as insurance. You dislike having to pay for it, but it is a critical need in any organization. You can be ready for planned downtimes, but what happens when it is unplanned? As sited in HealthIT.gov about EHR downtimes, “Such unavailability can introduce substantial…
Get exclusive offers sent straight to your inbox.
