Osquery is an open-source security compliance agent. It uses SQL to leverage a relational data model to describe a device. It’s great at providing all the contextual OS-related information you need in a simple, visually appealing form. Osequery is an all-time favorite compliance tool that is pleasant to use and great for security hardening.
Azure key-value store services comprise a subset of NoSQL (non-relational) data services for semi-structured data, which offer you a key-value data store. Common use cases would be when you need: simplest and fastest NoSQL data store; fast, high-volume data ingestion; quick read-write operations; or when data structure/number per entity is varied. Sounds complicated, but we’ve laid it all out in simple terms.
DBeaver is an open-source, free multi-platform database management software. It’s also an SQL client for developers and database administrators that has a user-friendly UI. It can be used as an alternative for MySQL-Workbench and PGAdmin to work with various databases, like MySQL, PostgreSQL, Greenplum, and others.
Azure Kubernetes Service (AKS) is incredibly multifaceted. For example, you can test the connectivity of an SQL server that’s using a private endpoint connection to your AKS cluster using a pod. You can even manage SQL databases without deploying a VM or installing SQL Server Management Studio or other software.
Having an Oracle Database on hand for testing purposes is a handy endeavor. For example, if you want to test software integration capabilities or work with PL/SQL scripts. We’re not talking about configuring a full-blown production-ready Oracle. Just something useful and easy to have for you to test the work stuff that you need.
In my previous article, I measured SQL Server Basic Availability Groups (BAG) performance. This, as it comes from the name, addresses SQL Cluster Failover Cluster Instance (FCI) performance. I expect SQL Server FCI to exhibit two times higher performance than BAG.
Before I start, I’d like to tell you one important thing about this measurement. SQL Server FCI database resides on a StarWind virtual device. Why did I choose StarWind? Because I got their NFR license some time ago and decided to give this software-defined storage solution a shot. Let’s just hope that it won’t limit SQL Server FCI performance.
Imagine you have a server with data source volumes that are backed up to local (or a share) target backup volumes with Veeam Agent for Windows (VAW). You might or might not backup the OS as well. That server is old, has issues or has crashed beyond repair and needs to be replaced. You don’t really care all that much about the server OS potentially but you do care about your data backup history! You don’t want to lose all those restore points. Basically, we try to answer how do you replace the backup server when it’s a local Veeam Agent for Windows 2.1 deployment.
I’ve recently been spending more and more time looking into various cloud technologies such as AWS and Azure. One of the projects I’ve been working on required the on-premises active directory to be extended to Azure to allow for a future introduction of various Office365 elements. The process for doing this is fairly easy as it’s just a matter of installing the Azure Active Directory Connect tool onto a server, creating the domain in the Azure portal and then waiting for Azure AD connect to Sync.
Applications that are deployed in Microsoft Azure often comprise different but related cloud resources, such as virtual machines, web applications, SQL databases, virtual networks among others. Before the introduction of Azure Resource Manager (Azure V2), it was necessary to define and provision these resources imperatively. However, Azure Resource Manager gives you the ability to define and provision these resources with their configuration and associated parameters declaratively in a JavaScript Object Notation (JSON) template file, known as an Azure Resource Manager template.