Advanced Search
Search Results
73 total results found
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 Th...
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. Linux Set Time Examples You can also simplify format using following syntax: date +%Y%m%d -s "20081128" To set time use the following syntax: date +%T -s "10:13:13" Use the following syntax to set new ...
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...
Synology - Bag of Tricks
sudo -i ip link set eth1 down My DS118 idles at 24% after disabling all the junk. //run once as root to disable services *you* don't need synopkg stop pkgctl-SynoFindersynopkg uninstall SynoFindersynopkg stop pkgctl-ActiveInsightsynopkg uninstall Active...
Powershell - Printers
Printers Delete Printers https://community.spiceworks.com/topic/1932797-use-powershell-to-delete-a-mapped-printer Delete Network Printers Look at printers Get-WmiObject -Class Win32_Printer | where{$_.Network -eq 'true'} Get-printer | where{$_.Network -...
MsSQL - SQL Reporting Services
Enable Errors Connect to the database engine in SSMS and navigate to the ReportServer database. Query the ConfigurationInfo table to get familiar with it. Issue the following query: USE ReportServer GO UPDATE ConfigurationInfo SET Value = 'True' W...
Windows - How To Fix DFS Replication Event 4012 on Domain Controller
1. Verifying Server Promotion Status The first crucial step in resolving DFS replication Event ID 4012 is to verify the server’s promotion status. Any discrepancies in the promotion process can lead to issues with DFSR. Administrators can use tools like Activ...
Windows - Delete user Graph
https://www.alitajran.com/remove-on-premises-directory-synchronization-service-account/ Install-Module Microsoft.Graph -Force -Confirm:$falseInstall-Module Microsoft.Graph.Beta -AllowClobber -Force -Confirm:$falseConnect-MgGraph -Scopes "User.ReadWrite.All" ...
Powershell - Search Active Directory using PowerShell ADSISearcher Filters
https://www.alkanesolutions.co.uk/2021/03/03/search-active-directory-using-adsisearcher-filters/ How to Search This post discusses how we can search Active Directory using PowerShell ADSISearcher filters. Using search filters can improve search performance s...
Linux - Setting up an SSL secured Webserver with CentOS
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...
VMWare - Delete inaccessible datastore
Rename the store Use the web client to rename each store and a DEL in front of the name Access the shell of the appliance server and then the database VMware vCenter Server 8.0.2.00300 Type: vCenter Server with an embedded Platform Services Controller ...
Visual Studio - Bag of Tricks
To Add underscore to fieldNames
Apache - How to create a multi-domain SSL certificate
Introduction By defult, an SSL certificate is valid for only a single domain name. Using wildcards, you can match all the subdomains with a single certificate. However, a wildcard certificate is valid only for the subdomains, and not for the main domain: so,...
Proper Active Directory Time Sync Methods
Network Time Protocol (NTP) is a long-standing standard for computers to synchronize time between systems. NTP can be used to ensure that all synchronized computer clocks maintain the same time within a very small margin, usually measured in milliseconds. Whil...
XWiki - Install
This is to create a installation of XWiki on a installation of Rocky Linux already installed Configuration Linux configuration Disable selinux Run the following or you can modify the file here, “/etc/sysconfig/selinux”. If you modify the file make sure you...
Apache - Certbot SSL Certificate
Introduction The Certbot Package is not included in Rocky Linux’s base repository by default. In order to obtain it, we must install the EPEL (Extra Packages for Enterprise Linux) repository. This repository provides additional software packages through open-...