On the dbatools community Slack, people often ask how Invoke-DbaQuery can process multi-part scripts or commands with more than one result set. Here are a few examples.  Two tools: Get-Member and GetType() But first I would like to introduce a few tools and give tips that every user of dbatools should know. In general: Store the return of the ...

With Pylint you can ensure the quality of your Python projects. You can do manual checks locally or automated in a pipeline. The following article gives a quick explanation of how to achieve excellent code quality with your Apache NiFi Python Processors with just a few steps. Installing and customizing pylint To get started, you will need to instal...

In the rapidly evolving landscape of data processing, Apache NiFi has emerged as a powerful tool for automating the flow of data between systems. With the introduction of NiFi 2, the ability to implement new processors directly in Python has become a meaningful change for developers and data engineers. This blog post explains how you can deploy new...

Since version 2016 of SQL Server, the “Perform Volume Maintenance Tasks” right can be assigned during the installation of SQL Server in order to activate the “Instant File Initialization” functionality. But which account receives the right? We took a closer look at the topic in a customer project and share the results here. So let's start from the ...

Keyless authentication in the Google Cloud. How Workload Identity Federation replaces the use of service account keys in API authentication. Starting Point In an increasingly digitalized working world, cloud-based infrastructures and the automation of workflows are indispensable. Concepts such as Infrastructure as Code (IaC) or version management s...

With the brand-new Innovation Release 8.1.0, Oracle has once again given the MySQL InnoDB Cluster a new “feature”: “Read Replicas”. This allows an InnoDB cluster to be supplemented with additional read-only instances. This article explains how this works and why it can make sense. A, B, C An InnoDB cluster usually consists of three nodes that provi...