Step 1: Changing MySQL ConfigurationWhy: MySQL, by default, doesn't allow remote connections for security reasons. In this step, we'll walk through configuring MySQL to safely accept remote connections from trusted…
Deleting a Dataframe Row based on a Column Value (StackOverFlow) df = df[df.column_name != 0] Creating a Column Using a DataFrame.Apply That Uses Multiple Conditions From Other Columns (StackOverFlow) def…
I use code to transfer hundreds of large files to a remote server and sometimes after all transfers are done, the remote file size does not match the actual size…
Separating Large Lists into Chunks for Data Processing import random res = [random.randrange(1, 50, 1) for i in range(100)] chunk_size = 25 for i in range(0, len(res), chunk_size): chunk =…
Preface This solution will download all tables in a single database to flat files so you can keep a backup copy or if you want to work with the data…
I've been having this recurring issue on a Windows 2016 Server where there is a pop-up that overlays the entire screen and prevents all the scripts I run on Windows…
Windows Task Scheduler is a component in Windows that gives the ability to schedule and automate repetitive tasks in Windows by running scripts or programs at a specified interval. For…
When trying to resize the size of my VDI to 80GB with this command: VBoxManage modifyhd "C:\Users\<USERNAME>\VirtualBox VMs\<VDU Folder>\<VDI Name>.vdi" --resize 81920 I ran into this error: Progress state: VBOX_E_NOT_SUPPORTEDVBoxManage.exe:…
Frustrated like I was when trying to figure out how to use the key/pair generated via EC2 to connect to your Instance? This solution was a lifesaver for me and…
Tony