Blog

Use Active Directory to retrieve computer last logon date

If you need to see when a computer last logged onto your domain, here is a quick command to achieve that using PowerShell Active Directory shell: Get-ADComputer -identity [COMPUTER NAME] -Properties * | FT Name, LastLogonDate To look at all computers in your network. Change the -Identity switch for the -Filter switch: Get-ADComputer -Filter *…
Read more

Partition Assistant – Manage your Space

If you are in need of increasing space on any drive (mainly in regards to servers), I highly recommend this tool: AOMEI Partition Assistant (PA) A great tool that is easy to use and works! Just a few notes: MAKE A BACKUP OF ALL DRIVES BEFORE STARTING! - DO THIS, don't be lazy and regret…
Read more

Microsoft Office 2016, crashing, freezing issues

If you have Microsoft Office 2016 and are having crashing, freezing issues (mainly with Word or Outlook), 99% of the time it's due to not getting Office updates. Especially if you bought the office suite with your computer. UPDATE: If you have ANY other version of Office installed (Ex: Office 2010, 2013, etc.) this is…
Read more

Insert data into two tables of different databases on same instance

If both databases reside on the SAME MySQL server (and use the same user and password to connect). You simply establish the connection without picking a database, then put the name of the database in front of the table name like: INSERT INTO myDBname.myTableName (myKey) VALUES (myValue); If you have a connection to one database…
Read more

SSH zip only certain types of files recursively on Linux

If you are looking for a command to run via ssh that ZIPs all files (of a certain type) recursively here you go: 1 - Switch into the website folder, then run zip -R YOURZIPFILENAME '*.php' '*.html' '*.js' '*.css' 2 - You can also run this from outside the website folder: zip -r YOURZIPFILENAME website_folder…
Read more

Windows Installer and Dell Trusted Device Manager Error

If you recently (or whenever) gotten errors in regards to the Dell Trusted Device Manger due to Windows Updates, I have found a fix that might work for you. Here was my problem: I recently upgraded my Windows 10 machine to the latest release (1709 - Creators Update); upon computer restart the Windows Installer would…
Read more

AWS CLOSE_WAIT socket problems!

A buildup of sockets in CLOSE_WAIT state may indicate an application programming error. A CLOSE_WAIT socket is a socket in which the connection has received a FIN and has yet to be closed by the application. In this state, it is the responsibility of the application to close the socket, although the operating system will…
Read more

Excel – Lookup value in column and return value from another column

You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more

Go Daddy and PHP.ini file.

If you are using GoDaddy and hosting Linux with them, you may be needing to modify the PHP.ini configuration file. The PHP initialization files can manage form, server, and environmental variables as well as server-side cookies, temporary directories, error display, and error logging. First, you need to know how to modify it (or where to…
Read more

Linux Helpful Commands

Here is a list of some helpful Linux commands (all these commands assume you are a ROOT user): Need to search all your files, on your server for a word(s)? grep -r "SEARCH WORDS HERE" . Add on "-l" if you want to return ONLY the file that search word is in. Add on "-i"…
Read more

How to clone a hard drive to a new solid state disk (SSD)

Installing a solid-state drive (SSD) is one of the best upgrades you can make to your computer, but migrating your Windows installation can be tricky, because your data might not all fit on the drive. UPDATE: If you are doing lots of cloning, make it easy and simply buy a offline clone device from Amazon:…
Read more