SQL Server

I’m Speaking – PASS Summit 2018

2018-10-12T10:28:43-06:00

PASS Summit 2018 is the 20th event and is the largest SQL Server Data Conference in the world and I’m privileged to have been selected as a speaker. This year will mark my 9th year speaking at the PASS Summit where I’ll deliver the following two presentations.   Data Science Tips and Tricks using Python [...]

I’m Speaking – PASS Summit 20182018-10-12T10:28:43-06:00

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

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