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