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
2 reads
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
36 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
5 reads
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
366 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
306 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
262 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
46 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
26 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
36 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
32 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers