Kegembiraan Bersama Sahabat

What Is MySQL And Does Your Business Need It?

noreply@blogger.com (Lajang Berjuang) — Sat, 18 Jul 2009 19:49:00 +0000

What is MySQL?

First released in May 23, 1995, MySQL is an open source database software. It is part of a large and growing family of open source software including Linux, Apache, and programming languages PHP and Perl. However, unlike many open source products where the copyright is owned by the individual authors or distributors, MySQL is owned and sponsored by a single for-profit firm, MySQL AB, which holds the copyright to most of the codebase. They develop and maintain the system, sell support, service contracts, and proprietary-licensed copies of MySQL.

MySQL is a relationship database, which is a collection of items or tables organized into predefined categories or described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. This format is enormously popular with more than 100 million copies of the software downloaded over the life of MySQL. The popularity stems from the fact that the databases are easy to create and access. Additionally, they are easy to extend, a new data category can be added without requiring that all existing applications be modified.

When creating a relational database, you can not only extend the data, you can define the domain of possible values in a data column and any additional constraints that you want to apply to the value of your data. This makes your information significantly more valuable and user friendly.

Uses of MySQL

There are many uses of MySQL for a business and you can find many significant case studies at http://www.MySQL.com/why-MySQL/case-studies/. Among them are many stories about how information generated from MySQL has saved IT teams thousands of man hours and thousands of dollars.

Hereâ€™s an example of how you can use it for your business. Consider a typical order entry database. It might include the following columns for customer information: name, address, and phone number. . Another table might describe an order and have these columns: product, customer, date, and sales price. This table and the relevant information could be used to show a report on all customers that bought products on a specific date. A financial services manager in the same company could, from the same tables, obtain a report on accounts that needed to be paid.

Craigslist uses MySQL to power more than 50 forums, among many other things, and Yahoo Finance uses it to aggregate headlines for its website.

Benefits of MySQL

Ease of use. A basic knowledge of SQL and database manipulation is required however MySQL is logical and easy to use. This means you don't have to spend as much time and money either training existing staff, or hiring developers.

Security. There are not a lot of databases that can compare to the security that MySQL offers. It includes solid data security layers that protect your sensitive information. Rights can be set to allow some or all privileges to either individuals or groups. Passwords are encrypted. The access to your database can be controlled by a remote machine that can completely control what a user can view. The system can be locked down even more through the operating system.

Capacity and memory. MySQL can handle almost any amount of data from only a few rows to as much as 50 million rows or more. The default file size limit is about 4 GB. It manages memory very well, which means it functions efficiently and speedily without crashing or dumping your information. Additionally, MySQL server has been thoroughly tested to prevent memory leaks.

Unbeatable flexibility. MySQL runs on many operating systems, including Novell NetWare, Windows, Linux, and UNIX

It supports several development interfaces including JDBC, ODBC, and scripting languages including PHP and Perl. This enables you to create database solutions that run on all major operating systems, including Linux, UNIX, and Windows.

More than one person can access business information at a time. This means that a large group of people can access the information at once but there can also be several connections at one time.

Multiple storage engines, or types of table, allow you to choose which one is most effective.

Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

Technical support. One of the drawbacks to many open source products is the fact that the support is sometimes nonexistent or slow to respond at best. The products are free or close to free so itâ€™s a trade off. However, MySQL Enterprise offers support itself, including 24/7 30-minute response time and the support team has direct access to the software developers.

Licensing. Weâ€™ve already discussed the fact that open source products are extremely cost efficient! MySQL AB makes MySQL Server available as free software, but they also offer the MySQL Enterprise subscription offering for business users and dual-license it under traditional proprietary licensing arrangements for cases where the intended use is incompatible with the General Public License agreement.

Drawbacks of MySQL

Early versions of MySQL lacked many standard relational database management system (RDBMS) features, usually with the goal of trading guaranteed accuracy for speed. Many (but not yet all) such criticisms have been remedied in later versions of the software, including transactions and relational integrity constraints.

Some say that MySQL's feature list leaves something to be desired, but its fans swear that a scaled-down feature set means you only have to deploy, configure and maintain what you need

There are also a few common errors such as out of memory or packet too large they generally relate to the configuration of the server and are uncommon and the errors are fairly easy to remedy.

Bottom Line:

The uses of MySQL are seemingly endless and for a business the information gathered is priceless. Combined with PHP, it can be used to create dynamic web pages. If youâ€™re using any type of web 2.0 technology like forums, online ordering, subscription forms etcâ€¦must utilize a database of some sort to gather and analyze the information. When it comes to database technology, there really isnâ€™t anything that beats MySQL for stability, price, and ease of use.

MemberSpeed Content Management software can run on MySQL 3.23 and above.

Jeremy Gislason is a leading expert on membership sites, marketing and online business. For more Business Strategies, Resources and Membership Site Manager Software visit MemberSpeed.com

PowerPoint Tips

noreply@blogger.com (Lajang Berjuang) — Sat, 18 Jul 2009 19:48:00 +0000

Are you puzzled when using PowerPoint sometimes? In this article, I will list some small PowerPoint tips. Maybe they are all common, but practical ones. Hope these tips will make you convenient in your work and life.

1. How to Resize Pictures

You can size pictures in PowerPoint by clicking the picture with the mouse and dragging it to a new size. If you don't want to "stretch" the picture (keeping the horizontal aspect ratio the same) but enlarge it, hold the Crtl key when changing the size. You can also click the corner of the picture and enlarge it and the aspect ratio will remain the same.

2. How to Use Scanned Photos in PowerPoint

In Microsoft PowerPoint, you may want to add your own scanned photos into a slide to spice up your presentation. But very large pictures can slow down you slide show when they start to load. Even if a picture takes only a few seconds to load, it can throw off your entire presentation, as well as your timing. Recommend using smaller sized photos to help your slide show run exactly how it should.

3. How to Use Graphics with Text Efficiently

While working in Microsoft PowerPoint, you may decide to use text over graphics. This can either make or break your presentation, depending on how well you select your font and color. When working with text and a full color, it can be very difficult to pick the right color and font style. However, when working with a picture that only contains a few colors, text on top of it can spice up the slideï¿½s appearance.

4. How to Record a Narration in PowerPoint

You can record a narration into a PowerPoint slide easily. Do this:
* Go to the Slide you wish to add a narration to.
* From the Insert menu select Movies and Sounds.
* Click Record Sounds.
* When ready, click the Record button (the red circle).
* When finished recording, click the black Stop button.
* Click OK.

5. How to Add a Background Sound to a PowerPoint Slide

To add a background sound to a PowerPoint slide, follow this:
* Open the Insert menu.
* Select Movies and Sounds.
* Click Play CD Audio Track.

6. When Using AVI files with Presentations

Using an AVI file with a presentation may spice it up, but it can also ruin it. Make sure to keep your AVI file normal size. A movie playing that is viewed too big will not have anywhere near the quality that a smaller viewed movie will.

7. How to Convert Your PowerPoint to DVD

You can use Windows Movie Maker, but you may not be able to keep the animations and sounds in your presentation. Another choice is to use a professional tool to help you do this easily. Here I recommend the Wondershare PPT2DVD. With a high conversion quality, you can do it easily.
More information you can go to http://www.ppt-to-dvd.com

Small PowerPoint tips but useful. Welcome to share more tips here!

Difference between 32 bit and 64 bit OS

noreply@blogger.com (Lajang Berjuang) — Sat, 18 Jul 2009 19:46:00 +0000

During my research about 64 and 32 bit operating system I found many people confused about what computer they should purchase or what bit system they should choose…I think this article should be a great help for people to choose the correct machine for their use.

I found many people asking about that what is the difference between 32 and 64 bit operating system?... I hope after reading this article people would feel free to choose the best machine for them.

A 32 bit processor is faster than a 64 bit processor, 64 bit processors are very commonly used that you can find it easily in any home pc but the main difference is the hardware you are having on your machine. For 32 bits there isn’t any need of any wide main bus to carry 32 bits at a time but for 64 bits its must that you should have a wider bus to carry 64bits.

The main difference between a 32 bit and 64 is that 32 bit system has 4gb(gigabytes) of space for addressing means that the 32 bit system has a limit of 4GB RAM to process data where as the 64 bit operating system has 2^64 bits of space to address and supports 16 hexabytes of RAM to process data.

A person who does not care about the category will find 64 bit more beneficial than 32 bit because he can use 64 bit OS with 32 bit Os and softwares. If we compare 64 bit with 32 bit OS, 64 bit is faster and performs more upgraded silicon processes and have more no of transistors which proves it to be more advantageous than 32 bit.

Now most of the software companies are developing their softwares in accordance to the 64 bit environment, it’s really hard for the consumers to run a 64 bit application in 32 bit environment, in this case they have to upgrade their hardware’s such as RAM which is also a big issue because most of the computer users have less than 1Gb in their systems.

So instead of changing your hardware day by day I would recommend d32 bit OS which is more user friendly and enables it users to run applications of 64 bit in 32 bit environment.

Nama Kabupaten/Kota ditiap Provinsi

noreply@blogger.com (Lajang Berjuang) — Mon, 15 Jun 2009 12:19:00 +0000

Nama Kabupaten/Kota ditiap Provinsi tersebut, langsung klik Nama Provinsi untuk melihat daftar tersebut.

Nama Provinsi :

Jawa Barat

Banten

DKI Jakarta

Jawa Tengah

DI Yogyakarta

Jawa Timur

01.Kabupaten/Kota Di Jawa Barat :

1. Kabupaten Bandung (Soreang)
2. Kabupaten Bandung Barat (Ngamprah)
3. Kabupaten Bekasi (Bekasi)
4. Kabupaten Bogor (Cibinong)
5. Kabupaten Ciamis (Ciamis)
6. Kabupaten Cianjur (Cianjur)
7. Kabupaten Cirebon (Sumber)
8. Kabupaten Garut (Garut)
9. Kabupaten Indramayu (Indramayu)
10. Kabupaten Karawang (Karawang)
11. Kabupaten Kuningan (Kuningan)
12. Kabupaten Majalengka (Majalengka)
13. Kabupaten Purwakarta (Purwakarta)
14. Kabupaten Subang (Subang)
15. Kabupaten Sukabumi (Sukabumi)
16. Kabupaten Sumedang (Sumedang)
17. Kabupaten Tasikmalaya (Singaparna)
18. Kota Bandung (Bandung)
19. Kota Banjar (Banjar)
20. Kota Bekasi (Bekasi)
21. Kota Bogor (Bogor)
22. Kota Cimahi (Cimahi)
23. Kota Cirebon (Cirebon)
24. Kota Depok (Depok)
25. Kota Sukabumi (Sukabumi)
26. Kota Tasikmalaya (Tasikmalaya)

Kembali Ke Nama Provinsi

02.Kabupaten/Kota Di Banten :

1. Kabupaten Lebak (Rangkasbitung)
2. Kabupaten Pandeglang (Pandeglang)
3. Kabupaten Serang (Serang)
4. Kabupaten Tangerang (Tigaraksa)
5. Kota Cilegon (Cilegon)
6. Kota Serang (Serang)
7. Kota Tangerang (Tangerang)
8. Kota Tangerang Selatan (ciputat)

Kembali Ke Nama Provinsi

03.Kabupaten/Kota Di DKI Jakarta :

1. Kabupaten Administratif Kepulauan Seribu (Pulau Pramuka)
2. Kota Administratif Jakarta Barat (Jakarta Barat)
3. Kota Administratif Jakarta Pusat (Jakarta Pusat)
4. Kota Administratif Jakarta Selatan (Jakarta Selatan)
5. Kota Administratif Jakarta Timur (Jakarta Timur)
6. Kota Administratif Jakarta Utara (Jakarta Utara)

Kembali Ke Nama Provinsi

Kabupaten/Kota Di Jawa Tengah :

1. Kabupaten Banjarnegara (Banjarnegara)
2. Kabupaten Banyumas (Purwokerto)
3. Kabupaten Batang (Batang)
4. Kabupaten Blora (Blora)
5. Kabupaten Boyolali (Boyolali)
6. Kabupaten Brebes (Brebes)
7. Kabupaten Cilacap (Cilacap)
8. Kabupaten Demak (Demak)
9. Kabupaten Grobogan (Purwodadi)
10. Kabupaten Jepara (Jepara)
11. Kabupaten Karanganyar (Karanganyar)
12. Kabupaten Kebumen (Kebumen)
13. Kabupaten Kendal (Kendal)
14. Kabupaten Klaten (Klaten)
15. Kabupaten Kudus (Kudus)
16. Kabupaten Magelang (Mungkid)
17. Kabupaten Pati (Pati)
18. Kabupaten Pekalongan (Kajen)
19. Kabupaten Pemalang (Pemalang)
20. Kabupaten Purbalingga (Purbalingga)
21. Kabupaten Purworejo (Purworejo)
22. Kabupaten Rembang (Rembang)
23. Kabupaten Semarang (Ungaran)
24. Kabupaten Sragen (Sragen)
25. Kabupaten Sukoharjo (Sukoharjo)
26. Kabupaten Tegal (Slawi)
27. Kabupaten Temanggung (Temanggung)
28. Kabupaten Wonogiri (Wonogoro)
29. Kabupaten Wonosobo (Wonosobo)
30. Kota Magelang (Magelang)
31. Kota Pekalongan (Pekalongan)
32. Kota Salatiga (Salatiga)
33. Kota Semarang (Semarang)
34. Kota Surakarta (Surakarta)
35. Kota Tegal (Tegal)

Kembali Ke Nama Provinsi

Kabupaten/Kota Di DI Yogyakarta :

1. Kabupaten Bantul (Bantul)
2. Kabupaten Gunung Kidul (Wonosari)
3. Kabupaten Kulonprogo (Wates)
4. Kabupaten Sleman (Sleman)
5. Kota Yogyakarta (Yogyakarta)

Kembali Ke Nama Provinsi

Kabupaten/Kota Di Jawa Timur :

1. Kabupaten Bangkalan (Bangkalan)
2. Kabupaten Banyuwangi (Banyuwangi)
3. Kabupaten Blitar (Blitar)
4. Kabupaten Bojonegoro (Bojonegoro)
5. Kabupaten Bondowoso (Bondowoso)
6. Kabupaten Gresik (Gresik)
7. Kabupaten Jember (Jember)
8. Kabupaten Jombang (Jombang)
9. Kabupaten Kediri (Kediri)
10. Kabupaten Lamongan (Lamongan)
11. Kabupaten Lumajang (Lumajang)
12. Kabupaten Madiun (Madiun)
13. Kabupaten Magetan (Magetan)
14. Kabupaten Malang (Kepanjen)
15. Kabupaten Mojokerto (Mojokerto)
16. Kabupaten Nganjuk (Nganjuk)
17. Kabupaten Ngawi (Ngawi)
18. Kabupaten Pacitan (Pacitan)
19. Kabupaten Pamekasan (Pamekasan)
20. Kabupaten Pasuruan (Pasuruan)
21. Kabupaten Ponorogo (Ponorogo)
22. Kabupaten Probolinggo (Probolinggo)
23. Kabupaten Sampang (Sampang)
24. Kabupaten Sidoarjo (Sidoarjo)
25. Kabupaten Situbondo (Situbondo)
26. Kabupaten Sumenep (Sumenep)
27. Kabupaten Trenggalek (Trenggalek)
28. Kabupaten Tuban (Tuban)
29. Kabupaten Tulungagung (Tulungagung)
30. Kota Batu (Batu)
31. Kota Blitar (Blitar)
32. Kota Kediri (Kediri)
33. Kota Madiun (Madiun)
34. Kota Malang (Malang)
35. Kota Mojokerto (Mojokerto)
36. Kota Pasuruan (Pasuruan)
37. Kota Probolinggo (Probolinggo)
38. Kota Surabaya (Surabaya)