All posts by: Joel Ewald
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...
Finding your focus in a big ocean of ideas
If you have not heard of EOS (Enterprise Operating System) , it is a set of operating tools and concepts aimed at helping businesses grow and operate efficiently. There are many consultants out there doing very similar things, but the...
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:...
The Seven Sins against TSQL Performance
SQL MVP Grant Fritchey posted his “The Seven Deadly Sins against TSQL Performance” article quite a while ago, but it is still relevant today. If you are new to TSQL, or just want to understand some common things that kill...
When acronyms are out of control and the new face of healthcare
Recently I was reading an article Jim put me onto: Measuring health care performance is their business, and business is good. It talks about the many businesses that have sprung up to take advantage of complexities health providers have in...
Thought of the Day (Cheap way out of a blog post)
I did not have time to clean up a blog entry to post this week due to the holidays so I will instead post this incredibly insightful thought. I wish I could fall asleep as fast as my computer does...
Announcements at SQL PASS 2016
SQL PASS happened out in Seattle a couple weeks ago and Microsoft announced some new features they are bringing to the SQL Server platform. I will briefly discuss some of the more interesting items below. SSAS in Azure Microsoft is...
Tool Development and ATOs: Tidbits 1
We are currently pursuing an ATO (Authority To Operate) for some of our Tools. We are working with a company named Lunarline in the process. We are still in process, but I wanted to lay out a few things we have...
Tally, Oh! A table of numbers, splitting strings, and more
I was recently asked, “What is the DW.Numbers table used for in our database?” The simple answer is that it is can be used to perform many tasks in a set based operation that would normally require a loop, or...