Blogs

Stay up to date with insights, tips, and education from experts in healthcare IT.

As you work with calculations in SQL, eventually you’re going to get caught up (particularly when trying to output the data to a file, for a vendor) by the T-SQL rules around maintaining a proper number of significant digits in the results of a calculation. Generally speaking,…

One of the upsides / downsides of deploying SQL Server Reporting Services to your customers is that it allows them to Export data from a published report (or a subscription to a report) to a file. You can also send the data by email, though that functionality…

You’ve heard the recent–and sometimes overly-used–buzzword “the new normal” when referring to how organizations are conducting work during COVID-19. Yet still, as businesses re-open, many predict there won’t be a full-shift back from working remotely, and that what is going on today will continue to be the…

T-SQL contains within it a module which lets you generate XML data directly from SQL. No concatenating strings or building the XML layout by hand required! When you jump into using FOR XML, and exporting the data to a file, eventually you’re going to encounter a situation…

Last year, there were 798 confirmed incidences of internal and external healthcare breaches according to the Verizon 2020 Data Breach Investigation Report. We read about these incidents virtually daily, and yet, instead of breach numbers reducing, the numbers continue to rise. Of those incidents, 48 percent were…