SQL Server Recovery Point Objectives and DBA Tools Jan 20, 2024

Edition: Saturday, January 20th, 2024

Welcome to this week's edition (actually, this is the very first edition).  We'll break down the most popular posts ranked by two categories: Most Comments and Most Impressions.

Most Comments - 39

Day 2

Let's take a look at the first challenge.

...

Continue Reading...
Reduce Your Virtual Machine Build Time Using Hashicorp Packer: [Part 4 - Windows Server 2022 - HCL Template] Jan 06, 2024

Introduction:


You know how annoying it is to install an OS manually.  Having to click through the initial setup, remember which drivers to install, and then apply your basic configuration to every new machine is cumbersome.  

Fortunately, both Windows and Linux operating systems...

Continue Reading...
Reduce Your Virtual Machine Build Time Using Hashicorp Packer: [Part 3 - Environment Setup] Dec 28, 2023

Introduction:


In Part 2 of this series, we reviewed the different aspects of a Packer template file.  In this post, we'll begin creating the HCL template file for the Windows Server 2022 golden image.  Here's what you'll have by the end:

  • Install tools we'll use to create the HCL file...
Continue Reading...
Reduce Your Virtual Machine Build Time Using Hashicorp Packer: [Part 2 - HCL template components] Dec 20, 2023

Introduction:


Part 2 covers the concepts of the build process and HashiCorp Configuration Language (HCL) templates.  Builders create machines and generate images from those machines for various platforms.  Multiple builders create the golden image in the Automated Sandbox...

Continue Reading...
Reduce Your Virtual Machine Build Time Using Hashicorp Packer: [Part 1 - Packer Overview and Install] Dec 14, 2023

Introduction:


If you're someone tasked with server provisioning, OS installations/configurations, or setting up a home virtual sandbox, this blog series is for you.  In it, you'll learn about Hashicorp Packer and how it can make your job easier.  We'll end the series with a set of...

Continue Reading...
Building Your IT Career: Why Hands-On Experience Matters Dec 07, 2023

Introduction:


My wife, son, and I went fishing at our local lake a few weekends ago.  That Saturday morning, we got up, loaded the fishing gear, and put the boat in the water.  Easy, we've done this plenty of times before (trailering the boat, making sure the engine had oil and plenty...

Continue Reading...
How to use Kerberos Authentication with Ansible on Red Hat Enterprise Linux Nov 26, 2023

I use Ansible in my virtual sandbox to configure and maintain Linux and Windows servers. I aim to set up my sandbox to match most of the production environments I've previously worked with.  Most require using Kerberos over NTLM or strongly encourage its use.  The sandbox I'm...

Continue Reading...
How to Install Microsoft SQL Server 2022 Developer Edition: Using Powershell and Chocolatey Nov 20, 2023

Have you ever needed to install a relational database engine fast in your sandbox?  SQL Server is well known for its easy installation, albeit not all best practices are configured as part of the general installation.  In this video, I will show you how to install SQL...

Continue Reading...
Getting Started With Ansible: Creating Your First Playbook Sep 29, 2023

Introduction:

Imagine you're walking into a job interview or taking on a new role. During the interview, the hiring manager asks, "What sets you apart from the other twenty candidates I've interviewed?" How would you respond? If you've mastered Ansible and efficient automation, your answer might...

Continue Reading...
Try Azure SQL Database for Free With No Time Limit Sep 28, 2023

Introduction:

Have you ever left an interview feeling let down because you were told you lacked sufficient experience? Do you find yourself caught in the vicious cycle of needing experience to land a job but unable to gain that experience without the job itself? If you aspire to work with...

Continue Reading...
Getting Started With Ansible: Creating Your First Inventory File Sep 20, 2023

Introduction:

Inventory files lie at the core of Ansible.  They are a crucial component that organizes and categorizes the target hosts to which Ansible will apply configurations.  In this post, I'll walk you through the essentials of an Ansible inventory file, covering its basic...

Continue Reading...
Getting Started With Ansible: Setting Up a Windows Managed Node Sep 18, 2023

Introduction:

Setting up a Windows managed node is a crucial step in leveraging Ansible for managing your Windows infrastructure efficiently.  In this post, we'll walk through the process of setting up a Windows managed node using Ansible, enabling you to automate tasks on your...

Continue Reading...