Marc-Beacom

About Marc-Beacom

Marc Beacom is one of Datalere's two managing partners. Marc brings over 15 years of business and technical experience to the team and customers. Marc is also an active member of the local technical community and has served five years on the board of two Colorado SQL Server User Groups (Denver and Colorado Springs). He has also volunteered and served on several nonprofit boards including Colorado GiveCamp, Camp To Belong Colorado, PASS (Professional Association of SQL Server), and Mile High Analytics. He also created and organized Mile High Tech Con, a three-day conference for the Denver Metro area and Data Science in DTC, a new meetup group.

It’s a wrap – SQL Saturday Denver #774

2018-10-12T10:17:45-06:00

SQL Saturday Denver #774 has come and gone. It’s hard to believe how quick things went – well there were a lot of long nights in planning for this but done for this year. The University of Denver was the host again this year, which is a fantastic venue for our needs. Datalere was a [...]

It’s a wrap – SQL Saturday Denver #7742018-10-12T10:17:45-06:00

I’m Speaking – Denver Dev Day Fall 2018

2018-10-12T10:30:50-06:00

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 experts on best practices, the latest industry trends and much more. This will be my 3rd time speaking at the Denver Dev Day event and will [...]

I’m Speaking – Denver Dev Day Fall 20182018-10-12T10:30:50-06:00

Cloud ETL for the Modern Enterprise Workshop

2018-09-26T11:04:31-06:00

We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and we’ve been integrating data through ETL techniques for decades now. However, what is new is the growing cloud offerings organizations are using and have access to today.   For the Modern Enterprise, it’s common now [...]

Cloud ETL for the Modern Enterprise Workshop2018-09-26T11:04:31-06:00

Advance Your Business by Embracing Cloud Technologies

2019-01-11T13:50:58-06:00

Advance Your Business by Embracing Cloud Technologies In a rapidly shifting economic landscape filled with supposed cost-cutting strategies, no solution supports growth and competition among data companies better than cloud technology. Understanding how the cloud can keep your business competitive and in control Though data collection and [...]

Advance Your Business by Embracing Cloud Technologies2019-01-11T13:50:58-06:00

Automating Database Deployment: Part 4 Making Changes Using RoundhousE to Migrate the Database

2018-07-08T20:11:11-06:00

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 importance was talked about to help maintain the correct execution order. The tables were empty so a second deployment was run with new scripts added to [...]

Automating Database Deployment: Part 4 Making Changes Using RoundhousE to Migrate the Database2018-07-08T20:11:11-06:00

Automating Database Deployment: Part 3 Running RoundhousE

2018-07-08T20:14:27-06:00

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 the first articles you might take some time to go back through them.  Here are links to those first two. Automating Database Deployment: Part 1 Introduction [...]

Automating Database Deployment: Part 3 Running RoundhousE2018-07-08T20:14:27-06:00

Automating Database Deployment: Part 2 Setting Up the RoundhousE Environment

2018-06-12T16:04:59-06:00

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 at the default behavior and how to modify it using command line switches. When a RoundhousE deployment is run the first step is a check to [...]

Automating Database Deployment: Part 2 Setting Up the RoundhousE Environment2018-06-12T16:04:59-06:00

Automating Database Deployment: Part 1 Introduction to RoundhousE

2018-06-12T16:06:22-06:00

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 historically consisted of last minute treasure hunts to find or build scripts of the changes that have been made. Inevitably that leads to missed changes, no [...]

Automating Database Deployment: Part 1 Introduction to RoundhousE2018-06-12T16:06:22-06:00

AWS EC2 Linux AMI with pyodbc

2018-07-08T20:40:56-06:00

AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do some work, and then store the results into AWS RDS PostreSQL DB. Problem: Default AWS EC2 Linux AMI 2017.09.1 does not come with unixODBC 2.3.x which [...]

AWS EC2 Linux AMI with pyodbc2018-07-08T20:40:56-06:00

I’m Speaking at SQL Saturday Denver 673

2017-12-17T19:37:42-06:00

I’m incredibly excited to be a part of SQL Saturday Denver 673 both as a speaker and co-organizer. I will be co-presenting Two Guys and a Transformation: ETL Best Practices and Techniques with Gabe Villa where we’ll be sharing many of our lessons learned from decades of developing ETL solutions. We’ll cover core areas of [...]

I’m Speaking at SQL Saturday Denver 6732017-12-17T19:37:42-06:00