All posts by: Joel Ewald
Better User Stories Mini Course Free for Two Weeks
Mike Cohn over at Succeeding with Agile has a mini course on writing better user stories that he is making available for 2 weeks. This 20 minute training looks at some of the common mistakes people make at the early stage of...
The State of Machine Learning
Shivon Zilis and James Cham posted a list outlining the Competitive Landscape for Machine Learning over on HBR. Here is the infographic. The State of Machine Intelligence Have you played with any of the open source data sets or...
Deployment FAQ: Oracle Driver and Linked Server Setup
For many of our tools we routinely need to pull data from an Oracle server. In order to connect; SQL Server needs to understand how to talk to Oracle. This is true whether you are using a linked server to...
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...