Saturday, April 20, 2019

Business kaise shuru kare -- How to start Business

Hiya Friends,
Topic: How to start Business -- Business kaise start kare

Bhai log hum sabhi log, business karna chahte hai, lekin kisi ko kuch problem hai to kisi to kuch aur. 

Lekin problem to har kisi ko hai... ye guarantee hai... hehehehh. 

To pehle problem ko side me rakho, aur socho kaise business start karna hai, kyunki business start karenge to, problem to aayenge, fir uska solution bhi ho jayega ye bhi gurantee hai... 

Ager aap succeessful aur less risk lena chahte hai business me, to pehle aapko ye niche points clear hona chahiye:

1. App business kyun karna chahte hai?

2. Jiska app business kar rhe hai, uske bare me achhe se jante hai ki nhi?

3. Appke pass kya hai, jis se business start kar sakte hai?

4. App kaha business start karna chahte hai? Kya waha, us business ka demand hai?
etc...

Bhai log business start karna badi baat nhi hai, usme success hona badi baat hai.

Business start karne se pehle, kuch Home work kar lena chahiye jaise:

1. Pura business plan likh lo, socho nhi ki dimag me hai na. use likho aur fir uske bare me socho.

2. Business ke liye kitna paisa hai.

3. Business me kitna paisa lagega?

4. Business agar fail hua to kya karenge?

5. Business kitna profit de sakta hai monthly or yearly?

6. Business start karne se pehle, ye maan lo ki 1-2 sal tak koi profit nhi hai, to ghar kaise chalega?

7. Agar business loss hua to, kya tum khud wo kaam kar sakte ho bina kisi employee ka?

Agar ye sab aap kar sakte ho, aur aapke pass ye sabhi ka jawab hai, to aap business ke liye ready ho...

Bhai log simple thing business karo yea na karo problem to hamesha jingadi me rahega hi, to kyun na kuch kar ke problem face kare…

Aur haan business me isssue/problem aayenge, to himmat nhi haro, use resolve karo... har probelm ka solution hota hai...

Most Important: Agar aap suru ke 2-3 sal business kar liya, aur aapko ghata/loss nhi hua, iska matlab aap business kar sakte hai,
aur aap business ke master hai. Uske baad aapko profit 100% milega hi milega...

Some more useful links:




Regards,
TechOrNonTech Team

Sunday, March 31, 2019

How to export query output to Excel in Oracle SQL Developer

Hiya Friends, 
We would like to share this important steps which is very important in daily task either for any technical person.

We every time used to ask the Query output in excel format which will be easy to read and understand.

Almost time we need the sql query output in excel format. So, please find the below steps which we tried to mention in easy and very clear steps.

So, we thought lets share the steps which may useful here.

1. Run you SQL Query in SQl Developer.

2. You get output below as "Query Result"

3. Then Right Click on "Output Result of query" anywhere.

4. Select "Export" option

5. A new pop-up will open in which you will get many option.

6. Select the "Format"  as "Excel 2003+ (xlsx)"

7. Untick "Include Commit Every" option.

8. Select the file name and location from "Browse" button.

9. Then Click on "Next" button.

10. Then Click on "Finish".

Some more useful links:






Thanks,
TechOrNon-tech Team

Sunday, February 24, 2019

How to check notepad++ backup files

Hiya Friends,
Hope you all are doing Well !!!

I would like to share one of my experiences "How to check notepad++ backup files" and "How to take backup of notepad++ files" here which may useful and helpful for everyone either technical or non-technical person.

Because many times people asked me about this and some of people they took their backup but they are not able to restore or open the files, So that way they missed their backup files.

As a technical person, we can understand how much a backup files is important which we need all in our life. And if once lost then how feel on that… So, hope this may useful and helpful here.

1. How and where to check notepad++ backup files.

To check the notepad++ backup files,

Please follow the below steps:

Goto "Settings" Menu at top of the notepad++

Then click on "Preferences..."

Then In the Left Hand Side, You will see "Backup"
at 10th position. Click on "Backup"

Now, In Right Hand Side you will see the "Backup Path"
as example: C:\Users\username\AppData\Roaming\Notepad++\backup\

From here, please copy the path and you can check you logs.

2. How to take backup of notepad++ files.

Friends, whenever you are taking backup of the notepad++ files, don't take directly only files backup.

For example our path is: C:\Users\username\AppData\Roaming\Notepad++\backup\

So, here take the backup of the "Backup" directory as shown above.

People searched for below:

Thanks !!!
TechOrNontech Team

AWR Concepts and details

Hiya Friends, Topic: AWR (Automatic Workload Repository) understanding…
Damn sure you all are doing well in your life… If you have any problem means you are doing something big in your life.

Today, we would like to share regarding AWR (Automatic Workload Repository) which is a very important in oracle DBA’s life. And also, it is designed especially for oracle internal purpose.

Actually, we are collecting main points and trying to make it easy to understand.
Hope it may useful also we will put some more points here as days goes…

AWR:
In 11.2 spawrrac.sql is replaced by the AWR Global RAC report (awrgrpt.sql) report, a Server Performance AWR RAC report.

$ORACLE_HOME/rdbms/admin/awrgrpt.sql (for RAC)

$ORACLE_HOME/rdbms/admin/awrrpt.sql ( for single instance)

When we need AWR report:
We need the AWR when the performance is slow or degraded over time due to increased user activity.
When the performance of the database over time has been slow-down or degraded due to the changing or increased content in the database.
AWR helps in the performance of DB has become slower if the either patchset applied or app server version has changed.
Also, it helps to when the performance of DB has become slower after either database patchset applied or the database version has changes.

We need to check in AWR:

At top 3rd line, we will see
Begin Snap, End snap, Elapsed and DB time

So, here if the “DB Time” value is higher than “Elapsed” value , it means session is waiting for something…

DB Time > Elapsed = Session is waiting for something.

Sessions: Here value is 00:47 start and End at 00:31, it means before running AWR, Database was busy. So we need to calculate after the 10 min of start time and before 10 min end time.

2. You will see Load Profile:
It shows the brief description about the database uses and workload.

For example if the values of “Redo Size” per second is 194 K and per Transaction is 45 K, it means the average transaction generates about 45 K of redo data and the Database produces 194K redo per second.

3. Cache load profile (Interconnect traffic in kb = 5 mb)

4. Buffer Cache Section (data block should access from local cache, % should be high. ie. cache fusion)

5. Global Cache and Enqueue Services (global cache operation should be less (milisec) -- if more than 5ms then we need to check cluster interconnections.

6. GCS and GES messages across the private network. (It should be less.)

To be continued…

Some more useful links:

Regards,

Friday, February 22, 2019

How to Study and Prepare for Exams

Hiya Friends,
I would to share some tips which I have been used for study purpose and got the good results in my life.

While studying we think as it is easy and now will remember for long time. But after some time or days, we will forget it.

Then we think that ohhh whatever I read, I forget the stuff, I am not good or my mind is not sharp like others.

But the Truth is "Everybody forgets the stuff".

If you don't want to forget anything, whatever you have read or studies. You must need to keep revision periodically which everyone does.

I am damn sure many people are not aware about these things but I have learned from my experiences and IITian's friends experiences:

For example, here very few people check the Index pages of the books but that is very important pages for quick revisions.
Also, I would like to give some tips which are very important.

Tips:
1. When you studying anything like Mathematics, Science, Physics... ALWAYS READ AND WRITE WITHOUT SEEING.

See, we have to understand the stuff also, that's right but this is easy way to learn and remember for long time.
Just try it and let me know the result, Damn sure it will work.

2. While you are doing revision, always revise through Topic or check the INDEX page of the books.

While you revise or go through the index page of the books, automatically everything will recollect to your mind whatever you have read.
And also, you will come to know what you are missing or forgetting.
I would like to share my real time experiences, during exam time we have prepare for all the subjects.

Especially In Mathematics, when you check or see the Math's Questions, you will feel as "Yes I know it and I can do it" but when do solve on paper, 98 percent of the people will not able to solve it and they do mistakes in exams.

Amazon offers
Mathematics can't be read, it should be always solved on paper. Even last date of exam, you must take paper and pen and solve the Questions.
You should not just see and then think as you can do it.

For quick revision, always see the Index of books and revise from there, I am sure it will very helpful.

While studying Mathematics, Physics or Chemistry always use notebook and pen.

Try and come back for any Queries… Waiting for response…

Thank…