jerry

Playing with ChatGPT

Links and Info:

to get a chatGPT account – go to https://chat.openai.com

https://platform.openai.com/docs/introduction

https://platform.openai.com/examples/default-sql-request

https://platform.openai.com/examples/default-qa

https://platform.openai.com/docs/quickstart/start-with-an-instruction

https://platform.openai.com/account/api-keys

https://platform.openai.com/docs/guides/images/usage

https://beta.openai.com/playground

https://help.openai.com/en/

Windows 10 God Mode

If you are a long-time Windows fan and user, you might remember something called “God Mode” hidden in within Windows’ files. In essence, God Mode in Windows gives you access to the operating system’s control panel settings from within one folder. The real name for God Mode in Windows is Windows Master Control Panel shortcut. Enabling God Mode in Windows 10 is much easier than it sounds.

God Mode is most helpful for advanced Windows users that work in IT; as well as more advanced Windows enthusiasts. Most customers, like myself, will not see a use for having God Mode enabled in Windows 10, it’s like having your developer settings enabled on your smartphone. If you want to try it out, though, here’s how to enter God Mode in Windows 10.

How to enter God Mode in Windows 10

  1. Make sure your Microsoft system account has administrator privileges.
  2. Right-click on the Windows 10 desktop and “Create a new folder.”
  3. Right-click the the new folder and rename the folder: “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” press enter and you’re all set!

If you want, you can change the folder name, “GodMode,” at the beginning of the renamed file folder. Now, when you open the folder, you will see various settings that you can change at will. You can see around 30 different settings available, including Devices and Printers, Administrator Tools, etc.

M.2 SSD Cards

What is the difference between M.2 modules – see here https://www.electronicdesign.com/technologies/memory/article/21801513/whats-the-difference-between-m2-modules

How to distinguish the differences between M.2 cards – https://www.dell.com/support/article/en-us/sln301626/how-to-distinguish-the-differences-between-m-2-cards?lang=en

Once you determine the proper SSD card, check out the benchmarks at https://ssd.userbenchmark.com/

HP Elitebook 840

I recently had the opportunity to work with 30 HP Elitebook 840 G1 & G2 laptops. The drives were wiped and the laptops donated to a non-profit group. Originally we were going to use these laptops to help groups register for the 2020 census. Then came the lock down with the Corona-virus.

We thought we did not have the Windows keys for these machines, so the open source operating system Ubuntu was installed using a boot USB drive (described here). After installing Ubuntu in about 15 computers, I had a problem and opened up the back case and removed the battery and found the windows 7 key.

These Laptops came with a i5 Intel Processor, 8GB Ram, 500 GB Hard Deive and Windows 7. Once windows 10 was installed, it was a rather robust computer. But when I took off the back case, I found a slot for a SSD Card and decided to try installing the card and using it as the boot drive. I purchased a 128 GB 2242 Sata3 SSD Card (what SSD Cards work in these laptops – more later).

Installing a SSD Card

For this 1st laptop, a HP Elitebook 840 G1 I purchased this SSD Card.

This is a 2242 Profile card and note the 2 notches for Sata3

Which went into this slot –

empty slot for a 2242 form factor m.2 SSD card
A 2242 (42mm long) SSD card installed above
Note: the 2242 card is 42mm long, the 2260 is 60mm long.

To install the card go in at an angle and slide in the connectors. Then lower the back end and install the securing screw. At this time we should warn you that all the G1 laptops took a 2242 profile card, the G2 took a 2242 or a 2260 profile, it depends where the screw slot is located.

2242 profile slot see screw slot in middle

2260 card profile see where the screw slot is on the left

Once you install the correct card, then close up the case and boot to the Bios (press escape “esc” key once on startup) then select f10 to go to the bios and ensure the M.2 slot is enabled.

Save the changes in bios and shut down. Now plug in your USB boot drive with windows 10 and boot up using the USB drive. So on startup Hit F9 to select boot menu (or hit the escape key & see the full bios menu).. On the Boot menu you will see the M2 SSD drive at the top of the boot order and go to USB drive and boot up to install windows.

Boot USB Drive

Ubuntu version 18.04 bootable USB drive (download zip file now 4.1GB)  – this can be used to install Ubuntu on any computer – download and unzip to root of USB Drive and boot to usb drive.

You may also make a bootable Windows 10 USB drive using a windows 10 image file. Any windows key may be used including windows 7 to upgrade your computer to a windows 10 machine. Or use the Windows 10 USB bootable drive zip file – (download now 3.7GB)

Using your own iso file – create your own bootable usb drive using Rufus (download Portable version now 1.2Mb ) – extract the zip file and run rufus without installing.

Rufus is a utility that helps format and create bootable USB flash drives – web site

If you wish to install windows 10 on your Mac Computer, see this Website.

Using Microsoft Access as a Front-end to MySQL

MySQL Connector/ODBC Developer Guide  /  …  /  Using Microsoft Access as a Front-end to MySQL

6.4.3 Using Microsoft Access as a Front-end to MySQL

You can use Microsoft Access as a front end to MySQL by linking tables within your Microsoft Access database to tables that exist within your MySQL database. When a query is requested on a table within Access, ODBC is used to execute the queries on the MySQL database.

To create a linked table:

  1. Open the Access database that you want to link to MySQL.
  2. On the External Data tab, choose ODBC Database.

    Figure 6.12 External Data: ODBC Database

    Content is described in the surrounding text.
  3. In the Get External Data dialog box that appears, choose Link to the data source by creating a linked table and click OK.

    Figure 6.13 Get External Data: Link To ODBC Database Option Chosen

    Shows the "Get External Data" dialog with two options: Import the source data into a new table in the current database, and Link to the data source by creating a linked table (selected).
  4. The Select Data Source dialog box appears; it lists the defined data sources for any ODBC drivers installed on your computer. Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table to. To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created.

    Figure 6.14 Selecting An ODBC Database

    Shows the Select Data Source dialog with two tabs: "File Data Source" and "Machine Data Source." The Machine Data Source tab is selected and displays three columns: Data Source Name, Type, Description. The selected row has "MySQL 5.7" defined as the Data Source Name, and "System" as the Type.


    If the ODBC data source that you selected requires you to log in, enter your login ID and password (additional information might also be required), and then click OK.

  5. Microsoft Access connects to the MySQL server and displays the list of tables that you can link to. Choose the tables you want to link to (or click Select All), and then click OK.

    Figure 6.15 Link Tables Dialog: Selecting Tables to Link

    Content is described in the surrounding text.


    Notes
    • If no tables show up for you to select, it might be because you did not choose the Database to connect to when you defined or logged in to the DSN. Reconfigure the DSN and specify the Database to connect to (see Section 5.3, “Configuring a Connector/ODBC DSN on Windows” for details), or choose a Database when you log in to the DSN.
    • If your database on Access already has a table with the same name as the one you are linking to, Access will append a number to the name of the new linked table.
  6. If Microsoft Access is unable to determine the unique record identifier for a table automatically, it will ask you to choose a column (or a combination of columns) to be used to uniquely identify each row from the source table. Select the column[s] to use and click OK.

    Figure 6.16 Linking Microsoft Access Tables To MySQL Tables, Choosing Unique Record Identifier

    Shows the "Select Unique Record Identifier" dialog with a list of fields in the selected table. In this example, the table name is cats2 and the unique fields are CatID, CatName, OwnerID, and Birthday. The available buttons are "OK" and "Cancel".

Once the process has been completed, you can build interfaces and queries to the linked tables just as you would for any Access database.

Use the following procedure to view links or to refresh them when the structures of the linked tables have changed.

To view or refresh links:

  1. Open the database that contains links to MySQL tables.
  2. On the External Data tab, choose Linked Table Manager.

    Figure 6.17 External Data: Linked Table Manager

    Shows "Linked Table Manager" under the "External Data" tab in Microsoft Access. Underneath are two panes: The All Access Objects pane shows the available tables, and the second pane shows data from the table. The "cats2" table is selected.
  3. The Linked Table Manager appears. Select the check box for the tables whose links you want to refresh. Click OK to refresh the links.

    Figure 6.18 External Data: Linked Table Manager Dialog

    Shows the "Linked Table Manager" dialog with the cats2 table selected with its associated checkbox selected.


    If the ODBC data source requires you to log in, enter your login ID and password (additional information might also be required), and then click OK.

Microsoft Access confirms a successful refresh or, if the tables are not found, returns an error message, in which case you should update the links with the steps below.

To change the path for a set of linked tables (for pictures of the GUI dialog boxes involved, see the instructions above for linking tables and refreshing links) :

  1. Open the database that contains the linked tables.
  2. On the External Data tab, choose Linked Table Manager.
  3. In the Linked Table Manager that appears, select the Always Prompt For A New Location check box.
  4. Select the check box for the tables whose links you want to change, and then click OK.
  5. The Select Data Source dialog box appears. Select the new DSN and database with it.

WordPress site speedup with compression added code to .htaccess file.

I had a slow Gtmetrix reading on the speed of my website. used htaccess file to compress my files on the server – see https://kinsta.com/knowledgebase/enable-gzip-compression/

added code to my htaccess file and see the difference

After gzip added to htaccess file


.htaccess code added at bottom of file:

<IfModule mod_deflate.c>
# Compress HTML, CSS, JavaScript, Text, XML and fonts
AddOutputFilterByType DEFLATE application/javascript
AddOutputFilterByType DEFLATE application/rss+xml
AddOutputFilterByType DEFLATE application/vnd.ms-fontobject
AddOutputFilterByType DEFLATE application/x-font
AddOutputFilterByType DEFLATE application/x-font-opentype
AddOutputFilterByType DEFLATE application/x-font-otf
AddOutputFilterByType DEFLATE application/x-font-truetype
AddOutputFilterByType DEFLATE application/x-font-ttf
AddOutputFilterByType DEFLATE application/x-javascript
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE font/opentype
AddOutputFilterByType DEFLATE font/otf
AddOutputFilterByType DEFLATE font/ttf
AddOutputFilterByType DEFLATE image/svg+xml
AddOutputFilterByType DEFLATE image/x-icon
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/javascript
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/xml

# Remove browser bugs (only needed for really old browsers)
BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
Header append Vary User-Agent
</IfModule>

my htaccess file:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

# END WordPress

# jc start to set 301 fault page and no www.

RewriteEngine On
RewriteCond %{HTTPS} on [OR]
RewriteCond %{HTTP_HOST} ^www\. [NC]
RewriteCond %{HTTP_HOST} ^(?:www\.)?(.+)$ [NC]
RewriteRule ^ http://%1%{REQUEST_URI} [L,NE,R=301]

# jc end

RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.*) /404.php
ErrorDocument 404 /404.php

# jc gzip call
<IfModule mod_deflate.c>
# Compress HTML, CSS, JavaScript, Text, XML and fonts
AddOutputFilterByType DEFLATE application/javascript
AddOutputFilterByType DEFLATE application/rss+xml
AddOutputFilterByType DEFLATE application/vnd.ms-fontobject
AddOutputFilterByType DEFLATE application/x-font
AddOutputFilterByType DEFLATE application/x-font-opentype
AddOutputFilterByType DEFLATE application/x-font-otf
AddOutputFilterByType DEFLATE application/x-font-truetype
AddOutputFilterByType DEFLATE application/x-font-ttf
AddOutputFilterByType DEFLATE application/x-javascript
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE font/opentype
AddOutputFilterByType DEFLATE font/otf
AddOutputFilterByType DEFLATE font/ttf
AddOutputFilterByType DEFLATE image/svg+xml
AddOutputFilterByType DEFLATE image/x-icon
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/javascript
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/xml

# Remove browser bugs (only needed for really old browsers)
BrowserMatch ^Mozilla/4 gzip-only-text/html
BrowserMatch ^Mozilla/4\.0[678] no-gzip
BrowserMatch \bMSIE !no-gzip !gzip-only-text/html
Header append Vary User-Agent
</IfModule>