DevOps, CI, CD, ALM… for databases

DevOps, continuous delivery, ALM. Pick your paradigm, the fundamentals are the same, and the database is often ignored. It is ignored despite the fact that it is often the component with the most scope for improvement. It's time we fixed that. The database should not be a bottleneck on delivering customer value.

tsql2sday-300x300

#tsql2sday #119 write-up

First, I’d like to say thanks. First to Adam Machanic (b|t) for starting #tsql2sday, second to Steve Jones (b|t) for co-ordinating it, but most importantly to all the people who contributed, listed below. I asked people to write about something in their IT careers that they had changed your mind about. What was your original opinion? Why did you believe…

tsql2sday-300x300

Continuous Database Deployment… to Production. #tsql2sday #119

This post is part of the 119th #tsql2sday blog party, which was started by Adam Machanic and is co-ordinated by Steve Jones. For more info, check out the website.  Our host this week is (ahem…) me. Here’s the topic: Changing your mind. For my contribution, I want to talk about continuous database deployment to production. Defining Continuous Deployment A point…

tsql2sday-300x300

T-SQL Tuesday #119 – Changing your mind

This month I have the honour of hosting T-SQL Tuesday, the monthly blog party started by Adam Machanic and co-ordinated by Steve Jones. Bringing people together I’m excited about DevOps. I first heard the term as a sales person at an IT company. I recognised the gulf between the sales and tech silos at my company and I could observe…

AlwaysAPeopleProblem

It’s always a people problem.

I attended DataOpticon yesterday in London. It was excellent. Massive credit to Steph Locke (b|t) for organising and gracious thanks to Microsoft and all the sponsors for hosting. Between sessions, Steph introduced me to a pair of folks who had a technical question. Steph thought I might be able to help. This is amazing.#DataOpticon pic.twitter.com/MqHAQrUtLU — Alex Yates (@_AlexYates_) September…

Mission

A new chapter

I wasn’t kidding when I tweeted this a few days ago: Yesterday marked three years since my life changing decision to start DLM Consultants. It’s been a good three years. And I suspect the next three years will be even better. https://t.co/TYyz8lXvox — Alex Yates (@_AlexYates_) May 10, 2019 Every syllable of that tweet had been considered very carefully. The…

Code

How to call the Azure DevOps Services API with PowerShell on hosted build agents

The problem My customer has a data warehouse solution. It consists of nine databases with a well defined architecture. They need to be deployed in a specific order – the source database first, followed by various dependant databases in sequence. Due to the tight coupling of the databases, they all exist in the same git repo in Azure DevOps Services, with…

DLMWorkshopsReviews-ZoomedIn

Feedback on the new DLM Workshops

Just a quick note to share my excitement about how well the first iteration of our new and improved DLM Workshops went! The first workshop ran on UK hours earlier this month. It was the first time we hosted the VMs ourselves and the first time we ran a public course using TFS/VSTS and it went really well. We now…

ColumnClassificationsSquare

Simple query to return columns that have been classified as sensitive in SQL Server

A few months back, in response to new regulations like the GDPR and a growing concern about data breaches and other data privacy issues, Microsoft released a new data privacy feature in SQL Server Management Studio (SSMS). Since SSMS 17.5, users have been able to use new classification functionality that sniffs out any of the columns on your database with…