Cerner and American Well to Embed Telehealth Capabilities into Cerner EHR

This week I thought I would post this news release that I came across on Telehealth related to Cerner for those that may not have seen it. November 14, 2016 From <http://www.cerner.com/Cerner_and_American_Well_to_Embed_Telehealth_Capabilities_into_Cerner_EHR/> Cerner, a global leader in health care technology,...
Continue Reading →

When is Select * ok

Generally speaking SELECT * should be avoided. There are multiple reasons for this, including: Requesting columns you do not need may force the optimizer to use more objects than needed or pull more data to memory than needed. Save some...
Continue Reading →

Optimization Smarts! Join Simplification

Someone recently read a post by Erik Darling over at BrentOzar.com titled Is it ever worth adding indexes to table variables.  They were a little confused by the post and asked me about it. I thought I would break it...
Continue Reading →

Idempotent statements

Idempotent statements are those where applying the statement multiple times yields the same result. Commonly in database development this is significant during deployment activities. If we create a new table the deployment script will merely have the CREATE TABLE syntax....
Continue Reading →

SSIS Package Parts First Impressions

Reading the way package parts were described in the SQL 2016 release notes I was pretty excited. I remember having hundreds of SSIS packages where the overall structure was fairly redundant, this was before BIML was a thing, and package...
Continue Reading →

Planning Upgrades, Migrations, Consolidations.. SQL and more

Steve Jones posted a good editorial a month or so ago about why he typically prefers side-by-side migrations over in-place upgrades. If you are running virtualized and want to upgrade in-place then it is not horrendous if you need to revert back...
Continue Reading →

Gaps and Islands – Determining Continuous Hours

T-SQL Master Itzik Ben-Gan covered different solutions in SQL Magazine quite a few years ago, and there are many other articles out there about it. I thought I would give a current example we were solving where this came into...
Continue Reading →

Linked Server Inconsistent Meta Data Error and Synonyms

* Featured image from In most of our more recent tools we have a single layer in the ETL Staging solution that understands all of the connections to other systems / databases that need to be made. This layer is...
Continue Reading →

Microsoft Visual Studio 2017 Launched

Microsoft Launched Visual Studio 2017 a couple weeks ago.  The launch included quite a few videos on new features and solutions people are using to solve problems. Take a look at the descriptions to see if anything speaks to you....
Continue Reading →

Splitting User Stories and Hamburgers

On paper writing a good user story sounds easy. “As a … I want.. So that I can”. While that may convey the basics it does not always actually tell the story. Roman Pichler lays out 10 Tips For Writing...
Continue Reading →