Posts

LATEST POSTS

Moving teams and users between multiple SQL Clone Servers

“Portability should be the default.”– Larry Wall Greetings one-and-all! It’s been a long time hasn’t it? Well – I’ll be honest. I’ve not been great… I’ve been struggling. With the pressures of everything going on; from National Lockdown 3: The Lockdown Strikes Back, to working hard, and trying to lose weight it’s all been a…

Refreshing SQL Server Development workflows with Redgate SQL Provision

“If you quit on the process, you are quitting on the result.“– Idowu Koyenikan SQL Provision is really cool. But you knew that didn’t you? It’s obvious – we get teeny-tiny clones, based on an image with completely sanitized data we can use for just about anything in dev and test, and if we break…

5 (Noticeable) Business Benefits of Secure Database Provisioning

“Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.”– William A. Foster I know what you’re thinking. “Chris. Your title looks like it was written to be a corporate whitepaper that I see ads for when…

3 methods for seeding test data during CI builds with Flyway

“It is a capital mistake to theorize before one has data. Insensibly one begins to twist facts to suit theories, instead of theories to suit facts.”– Sir Arthur Conan Doyle, Sherlock Holmes EDIT: Modified 23/12/2020 to include updates to Flyway in v7, method 4 below Can you tell I’m loving Flyway at the moment? Well…

Flyway and tSQLt – migrating to warmer test climates

“If you truly have faith in your convictions, then your convictions should be able to stand criticism and testing.”– DaShanne Stokes Welcome fellow Test–Driven-Development enthusiasts… is what I would say if i actually ever did TDD and didn’t just, you know… write regular unit tests after the fact instead. I’m going to be honest, I…

I will be running for the Ridge, will you?

“Until one has loved an animal, a part of one’s soul remains unawakened.”– Anatole France TL;DR: If you love to walk, jog or run – sign up to a fantastic cause here to support a shelter in need! The Full Story: This is going to be a reasonably short post, because I’m hoping if you’ve…

Classification by design: Including data cataloging in a DevOps process

“The most powerful tool we have as developers is automation.”– Scott Hanselman It is no secret that I love to talk about data protection, specifically from the perspective of structured data. When we talk about database development practices, we often find ourselves talking about 3 things most often: Source Control Continuous Integration and Continuous Delivery/Deployment…

My wife and I started a food blog!

“Veganism is not a “sacrifice.” It is a joy.”– Gary L Francione This is just a short one in the grand schema of things, you probably all know that I enjoy blogging but a lot of my posts end up quite long and rambling. This one however will be quite concise. My wife and I…

(SQL) Change ALL the Azure SQL Database Automation!

“But I can hardly sit still. I keep fidgeting, crossing one leg and then the other. I feel like I could throw off sparks, or break a window–maybe rearrange all the furniture.”– Raymond Carver I understand that starting off a blog about Azure SQL Database with the above quote is a little weird, but honestly…

Which database source control model works best for me?

“Destiny is not a matter of chance; it is a matter of choice. It is not a thing to be waited for, it is a thing to be achieved.”– William Jennings Bryan For many people, figuring out how to get their development database into source control is the first step to a robust, repeatable, automated…

Azure DevOps Masking a.k.a “point, no click”

“[My] kids haven’t responded to my GDPR requests so I don’t think I’m legally allowed to tell them when dinner’s on the table.”– @mrdaveturner Ah masking. You would have thought I’d be sick of it by now, no? No, fortunately now, more so than ever, I find myself answering question after question and tackling use-case…

Reusable Schema Deployments with SQL Source Control

“That’s who you really like. The people you can think out loud in front of.”– John Green Can we all take a moment to appreciate how awesome Kendra Little is? No really, go on over to her Twitter or something and remind her. Because not only is she a genius but she brings out the…

Cloning From Home… a consideration.

“I know there’s a proverb which that says ‘To err is human,’ but a human error is nothing to what a computer can do if it tries.”– Agatha Christie Working from home is fine because we still have the right connections in place. Televisions to watch only the most stimulating and educational shows, telephones to…

5 Awesome family-friendly vegan lock-down recipes

“One cannot think well, love well, sleep well, if one has not dined well.”– Virginia Woolf Working from home these past couple weeks has been, well… different. At this point we’ve gotten used to working next to one another on the dining room table (HUGE shout out to my wife for putting up with me),…

Status: Working from home

“What you stay focused on will grow.”– Roy T. Bennett As of Monday 16th March 2020 I have been a remote worker. Ever since I left University I have worked in busy, bustling offices where the air runs thick with collaboration, questions and social commentary. But now… I’m at home. I guess you could say…

Shall we begin? (With data classification)

“If I had an hour to solve a problem I’d spend 55 minutes thinking about the problem and 5 minutes thinking about solutions.”– Albert Einstein So I just spent about 20 minutes trying to come up with a suitable title for this blog post, and then it struck me – one of my favorite movies…

Saying “no” doesn’t mean you don’t care

“One of the most painfully inauthentic ways we show up in our lives sometimes is saying “yes” when we mean “no,” and saying “no” when we mean “hell yes.””– Brené Brown As someone who loves to please others, I often find that I end up with a calendar that looks like someone is very good…

Stop calling yourself an idiot.

“Be you, love you. All ways, always.”– Alexandra Elle You’ve probably heard it a lot; in the workplace, at home, from yourself. The dreaded phrase “oh sorry, I’m just being an idiot.” It doesn’t always have to be “idiot”, it can be “moron”, “I’m being stupid”… the list goes on and on. I’m going to…

Accountability, not blame

“When you blame and criticize others, you are avoiding some truth about yourself.”– Deepak Chopra Last week, I didn’t blog. Why? Well there is no real excuse, I had opportunities to and I prioritized other things around and over it which led to a simple and inescapable fact: for the first time this year, I…

Provisioning local Dev copies from AWS RDS (SQL Server)

“It’s still magic even if you know how it’s done.”– Terry Pratchett For a long time now I have worked heavily with Redgate’s SQL Provision software. I was involved from the very beginning when SQL Clone was but a few months old and just finding it’s little sheepish (teehee) legs in the world and before…

DBAle hits 5000 listens

“We see our customers as invited guests to a party, and we are the hosts. It’s our job every day to make every important aspect of the customer experience a little bit better.”– Jeff Bezos The date is June 6th 2018. Our producer Louise has just setup a slack channel called #dbale with the topic:…

Using things weirdly – Part 1: The SQL Clone Config Database

“If the challenge exists, so must the solution.”– Rona Mlnarik I like to use things in the way they weren’t intended. It leads to behaviors you weren’t expecting… and that’s pretty fun. Often though, when you work for a software company, people want your solutions to do things they just were not designed to do,…

Not letting stress take over, give yourself a moment

“The time to relax is when you don’t have time for it.”– Sydney J. Harris I work in a bustling, high-pressure environment. As a Sales engineer I could be called on to do, well, pretty much anything at the last minute – and particularly at the end of quarters when there are big pushes to…

Loading…

Something went wrong. Please refresh the page and/or try again.