Tag Archives: DevOps

How Mature are you in Database DevOps?

I remember seeing the Carnegie Mellon Software Capability  Maturity Model (CMM) when I was in university. It was fascinating, and I was sure this was the way to write software. Across many jobs and many years, I realized that few … Continue reading

Posted in Blog | Tagged , , | Leave a comment

I Will Write Bad Code

I’ll write bad code. I know it will happen. I’ll produce a bad query, incorrect logic, or the wrong data transformation being returned. This won’t be a malicious act. It might be because of ignorance, or perhaps just a simple … Continue reading

Posted in Editorial | Tagged , | Leave a comment

DevOps Basics–Git Clients

This is also a part of a basic series on git and how to use it. There are lots of git clients. If you look at the top list for this year, you’ll see quite a few. I’ve used a … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Database Development Made Easy

I ran across this post on developing database with SSDT. It has a lot of steps, and reading through it, I find this to make some sense, but I’m not sure I think this is easy. I can see why developers … Continue reading

Posted in Editorial | Tagged , | 4 Comments

Use More Pull Requests

I noticed a short while back that Books Online is on github. You can fork the code and make corrections to pages and then submit a pull request. This is the model that many OSS projects use, including the amazing DBATools project. … Continue reading

Posted in Editorial | Tagged , | 1 Comment

MSBuild and Azure SQL Database

I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to use a local Shadow database in LocalDB and target an Azure SQL Database. I hadn’t build that config, so I … Continue reading

Posted in Blog | Tagged , , , , | Leave a comment

DevOps–Fixing Poorly Named Constraints

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement. ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC] The problem was that … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

DevOps Basics–Git log

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. In a few … Continue reading

Posted in Blog | Tagged , , | 2 Comments

DevOps Basics–Staging and Committing Changes

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. In the course … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this … Continue reading

Posted in Blog | Tagged , , | 2 Comments