Stay up to date with insights, tips, and education from experts in healthcare IT.
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…
In certain situations, it may be desirable to make additional documentation available to the user at runtime. SSRS parameters can be leveraged for this purpose. In our example we use a report with two uncommon features: (1) use of wildcards in the name parameters, (2) use of…
