Blogs

SQL Server Integration Services is a powerful tool for building a single DTSX package, which can generate a single output file—or dozens of them—and let that set of work be scheduled to run automatically. And it’s included in your MEDITECH Data Repository server license for SQL Server!…

A very useful tool to have in your Data Repository toolbox is a Date Dimension table—which is a physical database table with one row per date from, say, 1900 through the end of 2499, and key elements pre-calculated about that date. This is useful for many data…

It may not be obvious when working in SQL Server Data Tools or Business Intelligence Development Studio, but when you add datasets to a SQL Server Reporting Services (SSRS) Report, they get an implied order of execution. Say you have a MEDITECH EDM dashboard, and it has…

Most, if not all of us involved in US healthcare are familiar with the National Provider Identifier (NPI), which is a 10-digit number starting with a 1 or a 2. Each NPI uniquely identifies a specific provider. The provider can be a person or organization. NPIs are…