OC with my PC

Note to self for whenever I have to setup a new PC. Urgh. I hope every time they send us new machines at work they'd load it with whatever our previous settings/apps/files were. Anyway...



Photo from Pexels


What settings to uhm, set...
Turn regular account to admin:
- Login using regular account
- Connect to VPN
- Switch user to adm
- Log off regular account
- Connect to VPN
- compmgmt.msc
- Local users and groups >> Groups >> Administrators
- Add
- Locations: nearest group
- Add object

Copy todo.txt to Yan
-
 Open in npp

Create off.bat
- Copy YanNotes to H
- move bat to Yan

Install UiPath Web Automation Chrome extension
URL: https://chrome.google.com/webstore/detail/dkgencfabioofgdmhhjljpkbbchbikbh

What to install...
Notepad++
Chrome
Firefox
Opera
WinWord
WinRAR
WinMerge
ScreenHunter
Photoshop
SQL Server
SQL Server Management Studio
Viber
UiPath
VLC

What shortcuts to make...
YanNotes
YanH
Yan
io | inetcpl.cpl
bt | bthprops.cpl
ps | photoshop
uipath
uisb | uipath sandbox
jabber
sqlserver
vpn


What shortcuts to update...
word
paint
mail
ie


This is it for now, will add more to this later on hehe

Share:

How to extract nupgk files using WinRAR

Did you know that the package file of your UiPath workflow contains the entire workflow file? So if you wanted to backup your script you just need to get the nupkg file and extract the contents. And in order to do that, you can use WinRAR. How?

1. Open WinRAR
2. Go to Options >> Settings (or hit Ctrl+S)
3. Go to Integrations tab
4. Under "User defined archive extensions", type "nupgk", then click OK


That should do it! :)

Share:

How to add programs on Windows Startup

Because I always forget where to put my screensaver app so that it launches upon startup, here's a note to self:

On the run dialog, enter "shell:startup"

OR

Open %AppData% >> Roaming\Microsoft\Windows\Start Menu\Programs\Startup

Yup, that's it. :)

Share:

[PHP] Special characters being replaced with black diamonds with question mark �

If you ever come across this issue where special characters in your PHP wep add like aprostrophe's and ñ's are being replaced by this weird symbol, �, it could be a char-set thing.


I tried a couple of solutions but none of them worked, until I looked into my php.ini for anything related to setting the character encoding, and I found that the default_charset is set to UTF-8.

I simply changed it to ISO-8859-1, restarted the IIS server, and refreshed the page.


And it worked!

Php.ini can be found on your PHP installation folder, in my case: 
C:\Program Files (x86)\PHP\php-7.4.8\php.ini

Set default_charset to ISO-8859-1 and enable it by removing the ; in front
default_charset = "iso-8859-1"
Share:

[SQL Server] How to export table data as insert statements

In case you want to export all the rows in a table as insert statements, here's how to do it:
  1. Open MS SQL Server Management studio and login to your desired database server
  2. Right click database >> Tasks >> Generate Scripts
  3. Choose Objects: Select specific database objects >> Select the table you want to export
  4. Set scripting options: Select Save to file then click Advanced
  5. Under advanced >> General Options >> Types of data to script - choose Data only >> Click OK

  6. Proceed to next steps until table is successfully scripted, the click on Finish
And you're done, you've now exported table data as insert statements.
Share: