Stay up to date with insights, tips, and education from experts in healthcare IT.
Concatenation in TSQL is often handled using the + operator. However, using + for concatenation requires the coder to account for data types and NULLs. There’s also the CONCAT function (released with SQL Server 2012), and the CONCAT_WS function (released in 2017). Both offer advantages over the…
Patient safety plays a critical role in healthcare, but it is more than just the physical, psychological, and social well-being of patients as they experience treatments and services. It is also the commitment to provide medical care that works tirelessly to avoid harm and errors, protecting patients…
It’s the most wonderful time of the year, but for healthcare professionals, it can also be one of the busiest. As you celebrate with your family and friends, don’t forget about HIPAA policies and other privacy regulations that must be followed even during the holiday season. Here…
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…
