Posts filed under: development
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...
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...
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...
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...
To structure or not to structure – that is the question
I was recently having a conversation that got me thinking philosophically about data. It reminded me of an article I read by Kevin Shelly about Mark Logic’s No SQL Database. In the article Kevin states Today 80% of the world’s...
Code Writing Code Round 1 – CRUD Statements
Unfortunately, things are not that easy for us mere mortals. However, we can make many repeatable tasks much easier by automating them or supplying tools to simplify them. I was having a conversation with someone the other day who saw...
Trying to Resolve “Failed to deploy database project:..” when running Database Tests
On certain occasions when you try to run the database tests you will receive the dreaded “Failed to deploy database project:” message and then many of your tests will fail. We speculated that this was primarily due to the test...
To handle uncertainty and risk.. use Spikes
I had this tagged for a blog post for quite a while now and since we had a similar situation come up in sprint planning for the ED tool yesterday this is a great time to post on it. Basically,...
Wet Monkeys and a New Year
Soon many of us will be singing Robert Burns’ poem “Auld Land Syne”, and depending on the amount of alcohol consumed it may or may not sound similar to its Scottish origins. As this final post of 2016, a new...
Data flow in decoupled solutions
Many of the current products we have released into the wild are using an architecture such that the standard product is not tightly coupled with any particular sites custom ETL transforms. We gain many benefits from this approach, such as:...