Blogs

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

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…

Conference season is exciting–you meet new people, learn new things, and most companies reveal new products and solutions. As you know, in light of COVID-19, conferences and tradeshows are on pause for now. But, we wanted to remind you that even though we can’t shake hands or…