Life as a Programmer – Page 4 – Basic Website Solutions

March 13, 2021

Why is my hard disk empty? Working on Microsoft SQL Server project

Recently I have download Microsoft SQL Server for a small interesting project I was working. Then all of a sudden, my hard disk space became 0 in my Drive C.

Puzzled for a few days a encountered a blog post that featured a nifty little software that I will now keep in my software belt.

It shows you the disk size of each folder in your pc. Quite a good find. The name of the software is TreeSize Free version.

For the culprit, the folder is located at :

C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Polybase\dump

When I looked at the folder, it came to 91gb.

So just in case you are working on a project in Microsoft SQL Server, be sure that the hard disk space will be close to zero, unless you can clean the dump folder.

Hope it helps

Stay safe guys

Coffee Cup

September 25, 2020

SB Admin PHP – Fixed Table Header with Scrollable Body

Hi guys,

This question was raised to me recently and it peeked my interest to solve and find out how to do this. After digging around i found 2 working codes for my case.

To explain further my tables are generated dynamically so the column widths and gaps differ by each refresh of the table

There are the 2 options that i found

////////////// OPTION 1 //////////////////////
table tbody { display:block; max-height:450px; overflow-y:scroll; }
table thead, table tbody tr { display:table; width:100%; table-layout:fixed; }

table width=”100%” class=”table table-striped table-hover” id=”dataTables-example”

////////////// OPTION 2 //////////////////////
table {
overflow-y: auto;
height: 10vh;
}
thead th {
position: sticky;
top: 0;
}

table width=”100%” class=”table table-striped table-hover” id=”dataTables-example”

Hope this code helps out somebody out there. If you have any questions, just drop me a line.

Coffee Cup

August 3, 2020

Acer Aspire 3 – Microphone not working

Hi guys, well, that’s not the whole story. Actually while using zoom I disabled the microphone by mistake.

So far after that day, I wasn’t able to use the microphone on my laptop.

Then at last I found a way to fix it. Actually another software that I was using gave me the idea on how.

Hope it helps

Coffee Cup

August 2, 2020August 2, 2020

Error 432. Setup has detected that unInstallShield is in use. Please close unInstallShield and restart setup.

Recently I purchased a new laptop and had tried to install a lot of my legacy software. One of them suddenly popped out a message saying ”
Error 432. Setup has detected that unInstallShield is in use. Please close unInstallShield and restart setup. “

You need to be logged in as the computer’s Administrator.
Delete an instance of the file IsUninst.exe from the C:\Windows directory. If the file cannot be deleted, you need to reboot the machine and try again.

I have included a picture to show where the file is located

Hope this helps.

Coffee Cup

June 14, 2020

How to change table row count in the bootstrap website?

I have been working with bootstrap websites for quite some time and making admin backend pages have been a new experience for me.

Lately the default 10 row table data have a lot of people ask if we can increase it to a certain number other than 10.

Fortunately, I came across the code to grant this request. But we need to go into the source code page to accomplish this.

Inside the HTML page, at the bottom, you will see a script section

We need to add more code to it.

When you refresh the page, you will see that it now starts at 50 rows

That’s just about it.

Enjoy,

Coffee Cup

Youtube link is
https://www.youtube.com/watch?v=GdH3IkYBwI4

June 14, 2020

Automatically Let Google Translate Your Webpage

There was a requirement before that the webpage needs to be converted to any language that the guest will be coming from.

So I got digging and found the code that will let Google translate convert it on the fly. Take note that this might need a few web source tinkering.

Here it is :

And the output you will see is :

I’m not sure why I cannot copy and paste code to WordPress for now. I am suspecting that you cannot copy <DIV> statements. But soon I will know why. But for now, a screenshot will do.

Now, of course, there is a downside to using this one. The translation going back from Chinese-to-English for example might not yield the same result. Just be careful if you are using words like Parent’s Portal that might be translated as an intergalactic dimension.

Just to be safe, we can keep it to plain or simple words that google can understand.

As always stay safe

Coffee Cup

You can view the youtube video here :
https://youtu.be/Q0Hqbn-4p6I

June 12, 2020June 12, 2020

How to make PowerPoint widescreen to 16:9 or 16:10 to post to YouTube

Hi guys, I’m happy to be back inspired to make my own youtube channel and promoting the sharing of knowledge to those who try to survive in this COVID-19 pandemic.

When you see my first video, the screen on Powerpoint seems to have empty spaces on the left and right side of the screen, so I had to research how to make it look like the DVD player version once I upload it to youtube.

My goal is to use PowerPoint presentations and background music to share what I know and how to solve daily problems in computers.

Here are the steps :

Select the Design tab of the toolbar ribbon.
Select the Slide Size Slide Size icon near the far right end of the toolbar.
Select Standard (4:3 aspect ratio) or Widescreen (16:9) or Custom Slide Size.

Now your excel should look like this one

And for those who are curious on what software I use to convert Powerpoint into Movie is that i use Ppt To Video Convert.

Comment below and let me know there’s anything I can help.

Coffee Cup

Here is my youtube link :
https://www.youtube.com/watch?v=lK1B-D3B4Gc

June 11, 2020

VPN Winscribe Free 10GB per Month

Hi guys,

I have been trying out free VPN and so far Winscribe offers 10GB of bandwidth for its free users. I was able to download and install it on my Win10 PC as well as in my Google Chrome as an extension.

Hopefully, it lasts me for a month. But i doubt. We’ll see how it turns out.

For the promo of 10GB per month, it only starts of as 2GB. To get to 10GB you need to register your email and verify it.

So far what I learned is when you initially open it, Viber would have issues with the PORT monitoring and will jack up your CPU usage to 100%. Once you allow it by disabling the PORT being used, everything goes back to normal in the Task Manager.

So far observing before recommending. We need to make our connections secure especially now with wifi hacking and working-from-home scenarios being prevalent in this COVID-19 epidemic.

I’m still hopeful that we can still come out of this era and once again enjoy the fresh air of beaches and resorts.

Till my next update

Coffee Cup

View my youtube link here :
https://youtu.be/lK1B-D3B4Gc

June 10, 2020

Windows cannot find “c:\…..\AcroRd32.exe”. Make sure you typed the name correctly, and try again.

This was recently a problem that I encountered and the first thought that came to my mind was to uninstall and re-install acrobat reader.

Try as I might, the error message persisted. Then I tried to look at the shortcut settings and still no answer.

Finally, I found the solution:

1- Close Reader

2- Hold down Windows key and press R on your keyboard, this will bring up Run dialogue box.

3- Type regedit in the run dialogue box and hit Enter, click Yes when User Account Control pop-up appears.

4- Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options, delete the key AcroRd32.exe

5- Relaunch Reader

Note : just in case you are like me who didn’t find the Image File Execution Options, what I did in regedit was to use the ‘Find’ command.

After a few skips, I finally found it. I also removed an additional folder in the registry with the _info extension. True enough, after that, Acrobat reader is now working.

Hope you enjoyed

Coffee Cup

November 25, 2019November 25, 2019