Advanced Search
Search Results
157 total results found
Wiki
This is for anything to do with knowledge base items to share.
Database Toolset
Toolset of tools and script for maintaining the databases. We also included scripts for different applications. Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies,...
Linux
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Apache
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Microsoft
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Visual Studio
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Powershell
Anything to do with Powershell scripting. Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless...
Docker
This page had now moved here https://thehomestack.io/
Raspberry PI
Anything to do with raspberry pi world!
All Others Stuff
Copyright NoticeSFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ma...
Security
This is for anything to do with security on Windows and Linux environments
NAS
Anything about all different types of NAS Synology, TrueNAS, QNAP
Home Assistant
Everything to do with Home Assistant
Raspberry Pi - SD card to a USB SSD
Install With the new version of the OS you can just use SD Card Copier from the accessories menu. We assume that you have already imaged and are booted up with the SD Card. 1. Terminal Open the terminal windows Change the boot option with this command ...
Linux - Setting up a Logging Server
Summary This is to setup a logging server to capture logs from any servers on your network. Prerequisites Install of a RedHat or Rocky Linux minimal install Configuration You will need to edit the file "/etc/rsyslog.conf" Editing the file vi /etc/rsyslo...
SQL - Kill Database Connections
/* This is to kill off any connection to a database Created by : Steve Ling 2022/03/20 */ --This script will kill when ran USE MASTER GO DECLARE @Spid INT DECLARE @ExecSQL VARCHAR(255) DECLARE KillCursor CURSOR LOCAL STATIC READ_ONLY F...
Linux - How to Increase the size of a Linux LVM by adding a new disk
Important Notes: Be very careful when working with the commands in this article as they have the potential to cause a lot of damage to your data. If you are working with virtual machines make sure you take a snapshot of your virtual machine beforehand, or othe...
Apache - Health Check
Server Health Commands Check TLS openssl s_client -connect <IP_ADDRESS>:8443 -tls1 nmap -sV --script ssl-enum-ciphers -p 8443 <IP_ADDRESS> Connections onto Server netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n ...
Apache - Enabling HTTPS w/Certificate
1. Getting the required software For an SSL encrypted web server you will need a few things. Depending on your install you may or may not have OpenSSL and mod_ssl, Apache's interface to OpenSSL. Use yum to get them if you need them. yum install mod_ssl op...
Visual Studio - Deploy to Linux
The only thing that you need to do do to deploy to Linux is too change the target runtime setting. This allows for the deployment to add the specific files to the folder.
Host ASP.NET Core on Rocky/RHEL (Apache reverse proxy)
Introduction This is to prep the Linux server to host Visual Studio code. This is for either RedHat or Rocky Linux installations. For this configuration were are installing on a Rocky Linux server. Platform prep: This page covers platform preparation (run...
Apache - Self Signed HTTPS Certificates
If you are starting to migrate your web servers over to Linux (or have already done so) and are looking to serve those pages up over secure http (aka https), you're going to need to know how to make this happen. Although https does will not guarantee security ...
Apache - Setting up an SSL secured Webserver w/Rocky Linux
This guide will explain how to set up a site over https. The tutorial uses a self signed key so will work well for a personal website or testing purposes. This is provided as is so proceed at your own risk and take backups! 1. Getting the required software F...
Visual Studio - Entity Framework Tips
dotnet tool install --global dotnet-efdotnet ef migrations add CreateInitialdotnet ef database update//https://www.youtube.com/watch?v=Fbf_ua2t6v4 Scaffold dotnet ef dbcontext scaffold "Data Source=mfb-us-sql-001;Initial Catalog=MyFFLBookAPI;TrustServerCerti...
Windows - Update additional resources
Try resetting the Windows Update Agent by running these commands from an elevated command prompt: net stop wuauserv rd /s /q %systemroot%\SoftwareDistribution net start wuauserv Reset Windows Update components manually Open a Windows command prompt. T...
Windows - How to delete the Recovery Partition
Unfortunately when there is no room on the disk to convert the drive from basic to dynamic. Microsoft documents the problem, and notes the solution is to delete the last partition on the disk: Not Enough Space Available to Upgrade to a Dynamic Disk RESOLU...
MsSQL - Backups
Introduction This is to create auto backups on a SQL server and place them on a drive. Credits go to: Ola Hallengrenhttps://ola.hallengren.com The 20240104_Backup_ola_original.sql file is the untouched default version. 20240104_Backup_ola_original.sql Ma...
MsSQL - Verify Properties
/* This will check the proprties on a given Database and also the server Created By : Steve Ling 2022/04/07 */ --Change the DB name here DECLARE @DATABASE NVARCHAR(50) = 'SHOP' /* No changes below this line */ ---- Simple Version Query ...
Linux - Bag of Tricks
Introduction This document has many useful command. Change Files and Folder Permissions To change the permissions of files to 655 and subfolders to 755 (which is the common practice for directories to allow execution for navigating into them) within a speci...
MySQL - Bag Of Tricks
Introduction This document has many useful command. MySql Kill users You can use the following syntax to lookup users within a database SHOW PROCESSLIST; SELECT group_concat(concat('KILL ',id,';') SEPARATOR ' \n') FROM information_schema.processlist WHERE...
Linux - How to Decrease an LVM Partition
Note: In this example we are working in CentOS 7, some commands may differ in different Linux distributions. As of CentOS 7 the default file system is XFS which is not currently possible to shrink, this example is working with the ext4 file system. In this ex...
Linux - Increase the size of a LVM Partition
This will cover how to increase the disk space for a VMware virtual machine running Linux that is using logical volume manager (LVM). Firstly we will be increasing the size of the actual disk on the VMware virtual machine, so at the hardware level – this is th...
Windows - Set Logon Server
How To change Logon server Name through Command Line: echo %logonserver%set logonserver=\\server1 set logonserver open Command Prompt*******************************************************Microsoft Windows [Version 10.0.14393](c) 2016 Microsoft Corporatio...