Blogs

What’s in a name? In teaching NPR, RD, and SQL from DR, a big chunk of my time is spent helping students figure out where data is kept (for example, which segment in NPR), and then what field names are called. MEDITECH segment structures and field names…

This blog post is designed for readers who use MEDITECH’s Data Repository. As part and parcel of developing ETL extracts for vendors, it is often quite useful to build a technical specification first. In the case of vendor extract files that involve the hospital getting money back…

End users are very fond of running reports in SSRS and exporting the results to a variety of formats. Excel is probably the most popular, but invariably there will be other formats needed. Unfortunately, in SSRS the list of other formats is limited. In particular, a pipe…

Oh, Microsoft – why do you make us cry? And no, I am not talking about Windows 10. Though that does make me cry a bit. Every day. But enough about me. You (sound developer that you are) have built a sweet new SQL Server Integration Services…