Monthly Archives: February 2017

Deployment Variables Anti-Pattern and Site Configurations

This example has been in my list to post on for quite some time now and a recent conversation reminded me to bump it up the list. The number one benefit of database projects is definitely the compiler, or as...
Continue Reading →

Order Matters: Using select to set variables

A quick post today. SQL allows you to set many variables at the same time using a select statement. However, many people do not realize that when you do this the order the variables are set in the select statement...
Continue Reading →

Telling a Compelling Story for Telehealth

In this short marketing video American Well outlines a compelling story for their Telehealth product by spotlighting many of those things that people commonly experience and telling a story of how it can be better. I find the video is...
Continue Reading →

Warning: RESEED Changed from SQL 2008 R2 to 2012

Recently, someone on my team had an issue with automated database tests failing and we discovered a change Microsoft made to the SQL engine.  If you use the DBCC CHECKIDENT command to RESEED a table it could impact you as well. Our...
Continue Reading →