Author: jepoy_ong

Posted on

7 Truths to become rich. Richest man in Babylon (20201120)

Truths of becoming rich

These are tried and tested rules for the rich and those who want to become one. All of these rules we need to keep near our financial wallets in order to survive. There they are

  1. Start your purpose for wallet fattening – Save 10% from 100% income. So far this is the hardest part and we start with this one. A famous rich person once said, it’s either you increase your income or you shrink to your income.
  2. Control thy expenditures – Budgets are good in these situations. We need to sacrifice today, for our financial situation to improve in the future.
  3. Put each coin to labor – This means to have investments in things that produce more money. A simple example of this is the bank account. But nowadays, people invest in digital investments that give 2% to 3% interest.
  4. Guard thy treasure from loss – The people we lend money must have the power to repay it back. We need security to the risk. We can do this by issuing a collateral.
  5. Make thy dwelling a profitable investment – If you buy a house, make sure you do not overpay for it. As a rule of thumb, you need to provide security and make wifey happy.
  6. Ensure a future income – We also need to plan for the future. Invest or become a money lender. That is called leverage. It can also give protection to the family.
  7. Increase they ability to learn – Cultivate skills and build confidence in yourself. Learn from the masters you want to reach.

Posted on

Real Estate Income Tips (20201221)

Rental Estate Tips

For those who want to enter the real estate market, I have a few ideas on what to do with it.

  • Townhouses for rent to friends , family and officemates
  • Condo units register it as Air-Bnb
  • Foreclosed properties as flipping
  • Empty lots good for planting , parking and mini stalls
  • Family home with multiple doors for rental income

Things to look out for

  • Titles and down payments. You might need to hire a lawyer
  • Rental price vs competition
  • Loan rates for personal or corporate
  • Tenant contract for house rules
  • Cash flow. Need to know the profit per year and per door
  • Unit profile. Need to know the square foot, when it was made, and how many it has changed hands
  • Debt on the deal. If it is still being paid in the bank and how much interest it is on.
  • Repair cost. This is for carpets, paint, fence, layout
  • Property manager. It can also be a broker who will take care of the property
  • Location. Crime rates, what stores are around, businesses and schools, if there are street lights
  • Banks loan rates, what is the last trade price
Posted on

Win10 Cannot Connect to Shared Printer

Recently i encountered a problem that doesn’t allow me to add a shared printer. It seems to be new so it might have something to do with the windows update.

Then i found the solutions. Its to add a registry entry. here it is :

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Print\RpcAuthnLevelPrivacyEnabled to 0

Once you do this you can now continue.

Enjoy,

Coffee Cup

Posted on

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

Posted on

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

Posted on

Delphi 6 – Get Date From and Date To With Number of Days

So far I have recreated this code far more in the 16 years that I have been using Delphi. Just wanted to log it here so that when I need it again, it will be here.

Hope it can also help other people

Enjoy

Coffee Cup

procedure TfrmPassword.BitBtn1Click(Sender: TObject);
var
vWeekDay : String;
begin
//DateUtils
//get the first and last day
if (ALMONTH.VALUE <= 11) then
begin
ALFROM.VALUE := StrToDate( ALMONTH.Text + ‘/01/’ + ALYEAR.Text );
ALTO.VALUE := StrToDate( IntToStr(ALMONTH.VALUE + 1) + ‘/01/’ + ALYEAR.Text ) – 1;
end
else
begin
ALFROM.VALUE := StrToDate( ’12/01/’ + ALYEAR.Text );
ALTO.VALUE := StrToDate( ’01/01/’ + inttostr(ALYEAR.Value + 1) ) – 1;
end;
//loop the number of days
ALDAYS.VALUE := DaysBetween(ALTO.VALUE, ALFROM.VALUE) + 1;
ALDATE.VALUE := ALFROM.VALUE;
ALSUN.VALUE := 0;
ALTOTAL.Value := 0;
while (ALDATE.Value <= ALTO.Value) do
begin
vWeekDay := LongDayNames[DayOfWeek(ALDATE.Value)]; if (vWeekDay = 'Sunday') then ALSUN.VALUE := ALSUN.VALUE + 1 else ALTOTAL.Value := ALTOTAL.Value + 1; ALDATE.Value := ALDATE.Value + 1;
end;
end;
Posted on

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

Posted on

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. “

  1. You need to be logged in as the computer’s Administrator.
  2. 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

Posted on

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

Posted on

Automatically Let Google Translate Your Webpage

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