Comments
Sort by recent activity
I've been lurking here for a while since I have some strong opinions and didn't want to sway the traffic. https://robrich.org/slides/database-devops-with-containers/#/ (video at [image] https://www.youtube.com/watch?v=GlmssURxgFE) is the presentation I put together some time ago. SQL Clone is great at quickly provisioning things and controlling distribution (and reclamation) of those things, but a container with an embedded copy of the database (anonymized, sanitized, and shrunk to meet the need) is more native to the developer mindset. My approach: a job kicks off each night building and publishing containers for developers, dev/test environment, and pre-prod (because each needs different levels of anonymized, sanitized, and shrunk). Developers have a "real" database by running `docker-compose up`, they can install and destroy it and unstuck themselves without holding a DBA's hand, and they can update it when they're ready, running the SQL Change Automation migrations as soon as they pop it open. "The build" can start with a fresh copy, practice the next prod deploy using SCA scripts, and fail the build if the prod deploy wouldn't work on the real data. And best of all, as @grumpydba says, "Your production backup is only as good as the last time you restored it." I restore mine every night. I'd love to do a webinar on this at an opportune time. / comments
I've been lurking here for a while since I have some strong opinions and didn't want to sway the traffic. https://robrich.org/slides/database-devops-with-containers/#/ (video at https://www.youtub...
+1. And now there's XML, JSON, Graph Database features, SQLCLR, in-memory tables and views, etc, etc. Add to the hosting options: Docker, Linux, GKE, Rackspace (et al). And this is one product in the stack that's either cloud-native or on-prem. Then there's ORMs, event workflows, the plethora of hosting and client-side options and form factors, technologies, and ecosystems. It's truly a wonderful and horrifying time to be a developer. / comments
+1. And now there's XML, JSON, Graph Database features, SQLCLR, in-memory tables and views, etc, etc. Add to the hosting options: Docker, Linux, GKE, Rackspace (et al). And this is one product i...
Agreed, if the test framework is updated after I download it and before you download it, it's possible you and I could have different testing experiences. Alas, the last time it was rev'd was 2016. I suspect we're slightly safe. If I get really paranoid, I could commit the zip file, though arguably that's not better than committing the actual scripts. [image] I'm not sure what the default should be in SQL Compare and SQL Change Automation, but I'd like options to be able to version neither, both, or tests but not framework. (This post began with the option to show/hide them as well.) I've done it so far with carefully crafted filter rules. Ideally I'd also be able to specify these in SQL Compare / SQL Change Automation as I manually (or better my DevOps pipeline) deploys these so the tests could automatically end up on the dev server but not end up in staging or production. / comments
Agreed, if the test framework is updated after I download it and before you download it, it's possible you and I could have different testing experiences. Alas, the last time it was rev'd was 2016...
@David Atkinson for the same reason I don't commit NuGet packages and NPM packages to source control. [image] / comments
@David Atkinson for the same reason I don't commit NuGet packages and NPM packages to source control.
Tangentially related: in SQL Source Control, I can exclude both tsqlt classes and tests or I can exclude neither, but I can't commit my tests to source control without also committing the framework. / comments
Tangentially related: in SQL Source Control, I can exclude both tsqlt classes and tests or I can exclude neither, but I can't commit my tests to source control without also committing the framework.
Kendra. Glad to have you representing us. / comments
Kendra. Glad to have you representing us.
Welcome Roseanna. Great to have you here. / comments
Welcome Roseanna. Great to have you here.
This sounds like great fun. Count me in. / comments
This sounds like great fun. Count me in.
+1 For those that learn by watching instead of reading, this is a great addition. Thank you. / comments
+1 For those that learn by watching instead of reading, this is a great addition. Thank you.
Or similarly, is there a way I can show I've been a friend since 20{insert#}? Ideally I'd like a logo that didn't need annual maintenance. / comments
Or similarly, is there a way I can show I've been a friend since 20{insert#}? Ideally I'd like a logo that didn't need annual maintenance.