Matillion: strategic to modern at Connect for Health Colorado
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
Marc Beacom
When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
28 reads
I’m Speaking – Denver Dev Day Fall 2018
Denver Dev Day Fall 2018 is a free event organized by volunteers and hosted at the Microsoft campus in the DTC. It’s a full day to learn from industry...
2018-10-12
It’s a wrap – SQL Saturday Denver #774
SQL Saturday Denver #774 has come and gone. It’s hard to believe how quick things went – well there were a...
2018-10-12
363 reads
Cloud ETL for the Modern Enterprise Workshop
We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and...
2018-09-26
303 reads
Advance Your Business by Embracing Cloud Technologies
Advance Your Business by Embracing Cloud Technologies In a rapidly shifting economic landscape filled with supposed cost-cutting strategies, no solution...
2018-08-19
254 reads
Automating Database Deployment: Part 4 Making Changes Using RoundhousE to Migrate the Database
With the Automating Database Deployment: Part 3 Running RoundhousE post we walked through running a RoundhousE deployment for the first time to create the database and several database objects. Script naming...
2018-02-28
29 reads
Automating Database Deployment: Part 3 Running RoundhousE
Now that we have a basic understanding of RoundhousE database deployment from the first two parts of this series let’s get to the good stuff. If you haven't read...
2018-02-21
9 reads
Automating Database Deployment: Part 2 Setting Up the RoundhousE Environment
Remember from the introduction that RoundhousE is a command line driven database deployment engine. This article of the series will discuss the deployment flow and the RoundhousE environment, looking...
2018-02-19
22 reads
Automating Database Deployment: Part 1 Introduction to RoundhousE
Database Deployment in DevOps One of the many obstacles to database development and DevOps is how to deploy databases consistently and how to automate the process. Database deployments have...
2018-02-12
12 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
Comments posted to this topic are about the item The Definitive Guide to DAX:...
Split concatenated column data into separate rows
My table1 has a column that has the following in it: (2)Joystick,(3)Candies,(6)Wires I want...
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers