A Fine Slice Of SQL Server
Andrew Pruski shakes his head:
Say we have a database that we want to migrate a copy of into Kubernetes for test/dev purposes, and we don’t want to backup/restore.
How can it be done?
Well, with cross platform availability groups! We can deploy a pod to our Kubernetes cluster, create the availability group, and then auto-seed our database!
The caveat is, this probably isn’t a good idea. But then again, when has that ever stopped anyone?
Comments closedAndrew Pruski doesn’t want to run a script:
This all seems a bit manual, doesn’t it?
What if we could automate the building of the image and the push to the container registry when we commit to the Github repository?
Thankfully, with Github Actions…we can do just that!
No more George Jetson-style button-pressing finger injuries for Andrew!
Comments closedKellyn Gorman runs into an issue:
When I tried to connect via SQLPlus as SYSDBA, I received an EXTPROC error. It pointed clearly to the listener.ora file, which I discovered a path listed still to ora23c for the extproc, corrected it, started the Listener, but to no avail- an ORA-12547 error, realizing I had a make file issue on the binaries for Oracle.
I contacted Geral Venzl, who was very gracious and after some quick research, he came back that his folks said everything was fine with the images, so I thanked him and dug into the issue deeper. I quickly discovered this problem could happen to others, so decided I better document here for anyone who does happen upon it.
Click through for the high-level explanation and a bit more detail on dangling images.
Comments closedAndrew Pruski shows off Docker Build Cloud:
In a previous blog post we went through how to build a Docker container image from a remote (Github) repository.
Here we’re going to expand on that by actually building the image itself remotely, using Docker Build Cloud.
What we can do with Docker Build Cloud is instead of building the image locally and then having to push to a remote container registry (for example the Docker Hub), we can build remotely and then immediately push that image to the registry so that it is available for immediate use by say, our team members or deployment/testing pipelines.
Read on to see how it works.
Comments closedAndrew Pruski shows off a new command:
In the latest version of Docker Desktop a new command has been included call docker debug.
Now this is only available with a Pro Docker licence but it’s an interesting command so I thought I’d run through what it can do here.
Read on to learn more about it and to see it in action.
Comments closedAndrew Pruski handles an introductory question about containerization:
To build a custom Docker image we create a docker file with instructions in it.
For example, a really simple custom SQL Server 2019 Docker image can be built with:
Click through for the example Dockerfile, followed by instructions on how to build both locally and directly from GitHub.
Comments closedIn this video, I take us through the process of creating a local deployment of an Azure ML managed endpoint. We will cover requirements, why you might want to do this, and common problems you may run into along the way.
This was a fun video to make, especially in anticipating the sorts of problems that come up along the way. I won’t pretend that it’s comprehensive but it does hit several of the most common problems I see (or cause).
Comments closedKiana Harris lays out some challenges:
As organizations embrace containerization and Kubernetes for their applications, the need for seamless portability across the Kubernetes ecosystem coupled with cloud object storage and local persistence has become a pressing concern. In this blog post, we will dive into the core problem and dissect the complex challenges that customers face in achieving containerized app portability.
Read on for the list of challenges, followed by what you can do to address them. This is at a really high level but can provide food for thought.
Comments closedBang Nguyen wants to see what’s going on:
Observability of a system includes Logging, Tracing and Metric. Today, we will go to detail how to implement observability’s elements on a K8S environment use Promtail, Open Telemetry Collector, Loki, Tempo and Grafana bellow is the demonstration of system we will implement
Click through for a detailed guide showing how to do this.
Comments closedJagdish Mohite talks security:
Docker incorporates several inherent security features that contribute to its overall security posture. When you use Docker to quickly create an environment and test some code, security is important enough (especially if you execute any , but when using Docker for production, multi-user environments, it is essential to treat the container as you would any other server environment.
The following is a list of some of the basic security principles that are baked into Docker.
This includes some of the things Docker does for your automatically, limitations around securing containers, and common attack modes. It’s a high-level overview but interesting to read.
Comments closed