Tag Archives: DevOps

More SQL Server Updates

Posted on March 22, 2018 by

This was a busy week for updates. I finished adding new builds to the build lists for 2017, 2016, and 2014, the first time I’ve done all three platforms on the same day. To be fair, two updates were on the 19th and … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Are You a Traffic Cop?

Posted on March 20, 2018 by

There’s a joke that a DBA’s favorite word is “no”. I think that was certainly true for the individual from whom I first learned about Oracle and SQL Server administration. He constantly pushed back on developers and management who requested … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Moving Lookup Data with ReadyRoll

Posted on February 8, 2018 by

I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where I want to keep data in sync across environments, so if my build and release pipeline can do this, great. … Continue reading →

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

No Magical DevOps

Posted on January 3, 2018 by

I saw this comment in a post a short while back. A reader said “I’m still trying to wrap my head around “devops” as it pertains to database deployment. … how do you deal with those potentially dangerous/destructive changes without … Continue reading →

Posted in Editorial | Tagged

Live on Channel 9 with ReadyRoll

Posted on December 7, 2017 by

I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some database migration work with ReadyRoll in this video: https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Database-DevOps-with-RedGate-ReadyRoll/player

Posted in Blog | Tagged , , ,

Automating SQL Clone Creation with PoSh

Posted on December 1, 2017 by

I think SQL Clone is one of the game changing products from Redgate. This product really fits into a DevOps mindset, allowing me to quickly and easily build (and rebuild) a dev database. While the agent web pages make this … Continue reading →

Posted in Blog | Tagged , , ,

We Need DevOps for Performance

Posted on November 28, 2017 by

I read this nice piece on CosmosDB and setting performance levels. It covers how you set some level of performance for Request Units (RU) and CosmosDB handles the rest. Great, right? Set the level of performance you need and that gets handled. The … Continue reading →

Posted in Editorial | Tagged ,

Off to DevOps East

Posted on November 7, 2017 by

The travel countdown is down to 2 trips this year. The second to the last is this week, as I’m off to DevOps East, a conference in Orlando, FL that tries to bring together lots of DevOps experts and advocates … Continue reading →

Posted in Blog | Tagged , ,

DevOps Basics – Ignoring Files in Git

Posted on October 30, 2017 by

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. One of the … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

All Day DevOps Slides

Posted on October 24, 2017 by

The conference will upload the slides to Slide Share at some point, but if you want to get them now, here are the slides from my talk: Including Database in DevOps – AllDayDevOps.pptx If you  have questions, drop a note … Continue reading →

Posted in Blog | Tagged ,