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......
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......
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......
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......
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.......
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......
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.......
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......
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......
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......