All Posts

AUTOMATION FOR DBAs: Scripting & Infrastructure. This is a work in progres with more to follow

AZUER FOR DBAs: Cloud Architect & Services This is a work in progres with more to follow

LINUX FOR DBAs: Essential Commands & Workflows. This is a work in progress with more to follow

SQL MASTERY: Foundational Commands & Tuning is a work in progress More deatails to follow

DBA can mean many things to many people, and the role can be wide-ranging or narrow, depending on the size of the team and organisation. I have developed a general overview that can serve as a starting point for the aspiring DBA SME. The skills for SME are transferable to SRE and DEVOPS. Pictures say a 1000 words, so the 4 pictures below give a high-level view of the skills to master. SQL, Linux, Azure, and automation. SQL LINUX AZUER AUTOMATION That's the easy part; the hard

Excellent tool for network administration and troubleshooting. Advanced IP Scanner is a fast, free, and robust network scanner that goes beyond simple ping checks to provide detailed network inventory and remote control capabilities. Here is a detailed, technical guide on its usage and utilisation. 🛠️ I. Core Functionality: Network Scanning The primary function is to quickly discover all active devices on a Local Area Network (LAN). 1. Setting the Scan Range Advanced IP Scan

Windows laptop only boots from USB-C and not from a standard USB The problem that your Windows laptop boots only from USB-C and not from a standard USB (USB-A) port is n't typically a matter of updating Windows drivers, because the drivers for the USB ports aren't fully loaded until the operating system (Windows) starts. This is a common issue, and the solution is almost certainly in your laptop's BIOS/UEFI settings , not in your Windows drivers. The boot process happens be

Testing, resetting, and verifying your VPN connection in Windows 11 using the command line (Command Prompt or PowerShell) typically involves network diagnostic and configuration tools like ipconfig , netsh , and PowerShell cmdlets like Get-VpnConnection . You must run all these commands from an elevated Command Prompt or PowerShell (Run as administrator). 1. Test the VPN Connection You can check the existence and status of your VPN connection using PowerShell, and verify the

Seamless Intune Onboarding: The Power of the Hardware Hash Script 🚀 Migrating existing Windows PCs to Microsoft Intune using Windows Autopilot can be a critical step in modern device management. While the ideal scenario is purchasing devices from an OEM or reseller who automatically uploads the device hashes, you often need a solution for your current inventory. This is where the hardware hash script —specifically the powerful Get-WindowsAutopilotInfo.ps1 PowerShell scrip

🛠️ Supporting Lenovo Windows 11 Laptops: Firmware & Update Guidance Author: Fabian John-Baptiste, Field Support Engineer Audience: IT...

Oh, joy! Another revolutionary tool to make your Monday mornings just a tad more exciting. As if your inbox wasn't already a thrill...

The IT service desk is the backbone of any organisation, ensuring smooth operations and swift issue resolution. Whether you're handling...

Decoding Your Digital Highways: Essential Windows 11 Network Tools Ever felt like your internet is a mysterious black box? From...

OneDrive, as part of Microsoft 365, has become an indispensable file storage and collaboration tool for enterprise users.1 While...

In the rapidly evolving landscape of cybersecurity and cloud computing, identity has emerged as the linchpin of an organization's...

In today's cloud-first world, identity is the new perimeter. Microsoft Entra, formerly known as Azure Active Directory, stands as the...

Here's a comprehensive list of significant versions for Windows Desktop, Windows Server, and SQL Server, including key milestones and...

Booting into the Modern Era: Windows 11 Startup and Keyboard Input We've explored the startup and command execution processes for older...

Booting Up and Typing Away: A Linux Perspective We just explored the fascinating journey from powering on a Windows PC to executing a...

From Power Button to PowerShell: A Journey of Command Execution on Windows Ever wondered what happens when you press the power button on...