A Fine Slice Of SQL Server
Sven Loesekann deploys Apache Kafka 4.0:
With KRaft for Kafka ZooKeeper is no longer needed. KRaft is a protocol to select a leader among several server instances. That makes the Kafka setup much easier.
The new configuration is shown on the example of the MovieManager project.
Click through to see how you can install and configure Kafka without taking a dependency on ZooKeeper.
Leave a CommentJess Pomfret does a bit of cleanup work:
Azure Container Registries can easily become cluttered with many versions of images. Did you know that each ACR sku comes with a certain amount of storage included, and when you go over that, you’ll pay overage charges. Let’s look at how to check your current storage, keep your registry nice and tidy with an ACR clean-up task, and monitor the storage levels so you’ll never pay extra again!
It’s easy to run up the disk space usage with a container registry, especially if you have automated builds running.
Comments closedToday, my colleague wanted to quickly test out some dbatools commands to install the Ola Hallengren maintenance solution. They had a local instance of SQL installed, but it already had the maintenance jobs running, so it wasn’t a fresh, out of the box instance.
So let’s spin a SQL Server instance in seconds to test against! (Ok it’s seconds if you have the pre-requisites installed, but I’ll get you setup in a few minutes if not)!
Click through for a primer on using SQL Server in a container.
Comments closedAndrew Pruski builds a diagram:
The other day I came across an interesting repo on github, KubeDiagrams.
What this repo does is generate Kubernetes architecture diagrams from Kubernetes manifest files…nice!
Deploying applications to Kubernetes can get complicated fast…especially with stateful applications such as SQL Server.
So having the ability to easily generate diagrams is really helpful…because we all should be documenting everything, right?
Click through for instructions and a couple of gotchas Andrew ran into along the way.
Comments closedYvonne Vanslageren builds a high availability solution for containerized SQL Server instances:
For enterprise SQL Server DBAs, high availability is essential for maintaining seamless database operations—particularly in scenarios involving Change Data Capture (CDC) or other mission-critical functionalities. Docker containers can streamline the setup and management of development or testing environments for Always On Availability Groups (AOAG). By bundling configuration files, scripts, and dependencies into containers, teams gain a reproducible, portable, and efficient deployment mechanism.
This guide explains how to build an Always On environment inside Docker containers using Docker Desktop, Docker Compose, and a series of setup scripts. It walks through the creation of two containers (primary and secondary) configured in a clusterless Always On Availability Group scenario.
Click through for the process.
Comments closedGaurav Shukla makes a comparison:
Hello Readers!! Welcome to the new blog!! AKS vs ACA, which is best in cloud migration? When migrating an application to the cloud, choosing the right platform is crucial to ensure scalability, cost-effectiveness, and ease of management. Two of the prominent services offered by Azure for running containerized applications are Azure Kubernetes Service (AKS) and Azure Container Apps (ACA). Both are excellent choices, but their use cases, complexity, and operational overhead differ significantly. This blog will provide a detailed comparison of AKS and ACA, helping you decide which is the best approach for your cloud migration.
Read on for an overview of each service and a nice table outlining the differences.
Comments closedAndrew Pruski has a guide for us:
A while back I wrote about how to use a Cross Platform (or Clusterless) Availability Group to seed a database from a Windows SQL instance into a pod in Kubernetes.
I was talking with a colleague last week and they asked, “What if the existing Windows instance is already in an Availability Group?”
This is a fair question, as it’s fairly rare (in my experience) to run a standalone SQL instance in production…most instances are in some form of HA setup, be it a Failover Cluster Instance or an Availability Group.
Read on for the tutorial. There are quite a few steps involved.
Comments closedAndrew 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 closed