Stay up to date with insights, tips, and education from experts in healthcare IT.
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…
Over the (relatively) long history of T-SQL and SQL Server, when we (as programmers) needed to format a date or a number inside our SQL we primarily had access to two commands: CONVERT() CAST() Of these, CAST() is intended primarily for converting data field from one type…
In the course of working with the DR, you’re going to wind up setting up scheduled jobs through SQL Agent, and–inevitably–you’re going to want to calculate job durations to see what is running long, perhaps unexpectedly so. This leads you to the msdb.dbo.sysjobhistory table, which tracks the…
