How to move the SQL tempDB database files
Open SSMS (If you don’t know what is SSMS, you shouldn’t be doing this…) Paste and execute this query, modifying it to your needs USE master GO ALTER…
Author
JohnyLuky
Get a list of assigned IPs and Host name from System Center Virtual Machine Manager IP Pool
Run from Virtual Machine Manager PowerShell Console: $IPpool = Get-SCStaticIPAddressPool "my_ip_pool" Get-SCIPAddress -StaticIPAddressPool $IPpool | ft -property Address,Description,AssignedToType,State
Duplicate a table in MySQL
Very simple! Log on to your MySQL instance, and select the DB you table is in; mysql> use mydatabase; Create the new table with the same structure…
Set file permissions for WordPress on CentOS 6.5 and Apache
SSH to the web server cd into your wordpress forlder; cd /var/www/html/mywpfolder Make Apache the owner chown apache:apache -R * Change all sub-folder’s permissions to rwxr-xr-x (0755); find…
Subnetting Chart
128 192 224 240 248 252 254 255 128 64 32 16 8 4 2 1 0-127 0-63 0-31 0-15 0-7 0-3 0-1 0 128-255 64-127 32-63…
Exchange Mailbox Export / Import Requests
Before you create any Export or Import; review/modify the max values for Transport, Receive and Send PS C:\Set-TransportConfig -MaxSendSize 100MB -MaxReceiveSize 100MB PS C:\Get-ReceiveConnector | Set-ReceiveConnector -MaxMessageSize 100MB…
PowerShell – Remove all files from a folder
This script will delte everyting in the “Script” folder, sub-folder, and the “-recurse” option will prevent the prompting of confirmation. The “-exclude” option alllows you to exclude files…
How to fix orphaned SQL Server users
Make sure to run all listed commands from the database you are fixing, not from Master. List the orphaned users in the database EXEC sp_change_users_login 'Report' To assign/repair…
Remove Hidden Network Adapters
1- Click Start, click Run, type cmd.exe, and then press ENTER. 2- Enter this command and then press ENTER: set devmgr_show_nonpresent_devices=1 3- Open Device Manager; Start DEVMGMT.MSC Click…
Install VMware Tools on any Debian Base OS
In VMware, select your guest, and click “Install/Upgrade VMware Tools” Then go back in your VM, and issue all the following commands from terminal. mkdir -p /media/cdrom mount…