Month: June 2019

How To Use Putty with an AWS Private Key

Step 1: convert .PEM file into a .PPK format Run puttygen.exe Click on Load Navigate…

Microsoft Failover Clustering Service Overview

In Windows 2012 R2, the failover clustering service requires some downtime to migrate clusters from…

Microsoft SQL Server Storage Capacity Planning

This would be a recommended mounted volumes for most environment: 80GB RAID10 C:\ Operating System…

Hyper-V Administration Console

Install the Hyper-V Management Console # Windows 2016 or higher: install the Hyper-V management tool…

PowerShell: Administering Network Time Protocol Settings on Windows

Quick Script of Domain Joined Laptops and Desktops for Remote Users: # Set Domain Joined…

Creating a RAM Disk on a Linux Instance of AWS

This information has already been conveyed in another post regarding a method to overcome MySQL…

CentOS System Rescue on AWS

Once upon a 'right-now' time, an EC2 instance on AWS would not come back online…

Manually Create a SSL Certificate with LetsEncrypt

Step 1: Install certbot-auto mkdir /etc/letsencryptcd /etc/letsencrypt/wget chmod a+x certbot-auto Step 2: Create the Cert…

PowerShell: Handling Windows Product Key

There are two ways to obtain product keys: Way 1: https://learn.microsoft.com/en-us/windows-server/get-started/automatic-vm-activation Way 2: Issue a…

Microsoft Hyper-V: Creating Windows Template (Golden Image)

Steps to Create a Windows Template Assuming that the Windows Template guest VM has already…

PowerShell Commands to Discover the Server Network, Netmask, DHCP status, and Gateway

$servername = "SERVER01"get-wmiobject win32_networkadapterconfiguration -computername $servername -ea stop | ? {$_.IPEnabled}# Result:DHCPEnabled      :…

VMWare vSphere Site Recovery Manager (SRM)

1. Creating folders to group VM clients for application From Home > vCenter > Select…

Linux Filesystem Hierarchy Standard (FHS)

/bin : binaries to run fundamental Linux functions/boot : boot partition/cdrom : legacy mounting point/dev…

Overview of Microsoft Azure Networking

Private connections into Azure are either via ExpressRoute (comparable to AWS DirectConnect) or VPN. The…

Microsoft SQL Server Error 18456

In a properly managed environment, the security team usually tracks the server logs for any…

File Access Control

System Engineers must follow the security principle of authentication, authorization, and accounting (AAA) as the…

MS SQL: Admin_Report_Notification

/* Admin_Report_Notification */DECLARE @tab char(1) SET @tab = CHAR(9)EXEC msdb.dbo.sp_send_dbmail@profile_name = 'Report DBMail Profile',@recipients =…

MS SQL: Archive and Shrink Database

--Archive Database: with maximum allowed runtime and a set number of recordsdeclare @EndDate datetime, @Recs…

Cisco Fabric Switch – MDS Zoning Template

<# What this script does: 1. Checks to see if an Internet connection via PowerShell…

PowerShell: Microsoft SQL Administration

Script to Install Microsoft Clustering Service $proxy="http://proxy:8080"$exclusionList="localhost;*.kimconnect.com"function checkProxy{try{$connectionTest=iwr download.microsoft.com#$connectionSucceeds=Test-NetConnection -Computername download.microsoft.com -Port 443 -InformationLevel Quietif…