How to Resize an Image in a Wikipedia ArticleIn Feburary 2016 29,

In Feburary 2016 29,
Go to Wikipedia's main page: http://en.wikipedia.org/wiki/Main_Page. You can also key in Wikipedia in any search engine.
Go to the top-right corner of the page. Click on 'Create Account.' Register by providing a username and a unique password. The account is created immediately. Your username will appear in red at the top of the page.
Resize an Image in a Wikipedia article
Go to the 'Edit' tab/box of the article in which you need to display or insert the image.
Use the syntax '{Image:Image name|thumb|caption}' where you want the image to appear. The thumb refers to the width specified already. Typically, 180 pixels is the default size.
Change the thumb-width to the size you want. For example, if you want 120 pixels, type '{Image:Image name|120p|caption}.' The image can only be as large as its original size. You can make it as small as you want.
Use 'frame' in the image syntax to maintain the original size of the image. For example, '{Image:Image name|frame|caption}.'
Specify the width options in your account preferences. Click on 'My Preferences,' the third tab/box on the top of the page.
Click on the 'File' tab/box in the 'My Preferences' page.
Set the size of the thumbnails, either 120, 150, 180, 200, 250 or 300 pixels.
Specify the resolution of the images on the 'Image Description' page. The default sizes of the width and height are 800 or 600 pixels.
Choose from the options listed. There are approximately six preferences listed for the height and width of images.
In Feburary 2016 29,

How to Use Picasa as an Image Host for WordPressIn Feburary 2016 22,

In Feburary 2016 22,
Register for a free Google account. Google is Picasa's parent company, and you'll need a Google account to create a Picasa Web Album. From the Picasa Web Albums home page, click the blue 'Create an Account' button and follow the instructions to create your free account.
Create a Picasa Web Album account by creating a Google profile, which includes the 'Photos' feature. This is where you manage and update your online photo albums through Picasa. While logged into your Google account, visit the Picasa Web Albums home page at http://picasaweb.google.com. Log in using your newly created Google account. Click the 'Yes, Create My Google Profile' button and follow the on-screen instructions to create your Google profile.
Download and install the Picasa software onto your hard drive. Click the blue 'Free Download' button and follow the on-screen instructions to install the software onto your computer. At the end of the installation dialog, leave 'Run Picasa' checked before clicking the 'Finished' button, so that the software launches automatically.
Allow the Picasa software to automatically populate with all the photos on your hard drive.
Upload the photo you wish to use in your WordPress post to your new Picasa Web Album. Double-click on the image in the Picasa software, then click the small 'Upload' button on the bottom of the screen. Customize the display information and designate an album in which to upload the image, if you wish. Click the 'Upload' button uploading the image to the server. The software may prompt you to log in again; if so, enter your Google user name and password.
Copy to your computer clipboard the direct URL of the image on the Picasa servers. Click the 'View Online' button to see your newly uploaded image in your Picasa Web Album. If you're using the Firefox browser, right-click on your image and select 'Copy Image Location' to copy the direct URL to your clipboard. In Chrome, right-click and open the image in a new tab, from which you can copy the URL.
Insert the photo into the WordPress page or post. While editing the WordPress page document, click the 'Image Insert' button above the content field next to the words 'Upload/Insert.' Click the 'URL' tab at the top. Paste the direct image URL in the 'Image URL' field, and fill out the rest of the form with your image's information. Click the 'Insert Into Post' button when you're done to insert the image into your WordPress page or post.
Click the blue 'Publish' button. Your WordPress document will publish with the Picasa photo embedded in its content.
In Feburary 2016 22,

SQL Scripting TutorialIn Feburary 2016 20,

In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,

How to Open Files With PTB ExtensionsIn Feburary 2016 14,

In Feburary 2016 14,
Find out what the file is, if you're not already sure. There are three major possibilities: the PTB file could be a guitar tablature generated by Power Tab Editor; it could be a table generated by the computer-assisted design program Pro/Engineer; or it could be a backup archive created by the Peachtree accounting program. If you have either Pro/Engineer or Peachtree installed on your system, it's likely the source of the file; if you downloaded the PTB file from a guitar tab website, its identity isn't a mystery.
Obtain a program that will open the file. If it's a guitar tab file, you can download either the Power Tab Editor (for Windows) or TabView (for Mac OS) -- both programs are linked in Resources. Pro/Engineer and Peachtree files, meanwhile, require purchased programs to open -- see Resources.
Install the program. To install Power Tab Editor, right click the downloaded ZIP file, select 'Extract,' then double click 'Setup.exe' and follow the on-screen instructions. To install TabView, double click the downloaded DMG file and follow the on-screen instructions. To install Pro/Engineer or Peachtree, just insert the CD.
Navigate to the location of the PTB file and double click it to open it. If it doesn't work, run the program you installed and click 'File,' then 'Open,' and select the PTB file.
In Feburary 2016 14,

What is Web Hosting?In Feburary 2016 09,

In Feburary 2016 09,
Web hosting is the method in which surfers of the web can successfully browse the Internet. A web server is a computer that sends the information for a personal or a business site to the Internet. Web hosting companies provide servers to its clients with the options of presenting information, files, pictures and bandwidth for the traffic its website brings in. This is a convenient technique for people to place ideas, products or personal touches on the World Wide Web.
Significance
The purpose for web hosting is practicality. A person with no website experience can create a meaningful site just like a knowledgeable professional. You do not need a web host to create a site linked to the Internet. However, setting up a server from your personal PC takes in-depth understanding that most people do not want to take the time to learn. That is why web-hosting companies provide simple access to the Internet. Anyone can create a site and have it viewed by millions.
Types
There are several styles of web hosting services. This depends on the type of website you have created. Websites that are more complex contain scripts, user generated information or an automated system requires CGI or PHP scripts. This method to have your script properly displayed is available by some companies while others do not offer this technique.
Free website hosting is rare. This style has advertisements in the form of banners or pop-ups. The free companies offer limited functions for clients. Typically, a person that has does not require large traffic and space or involve scripts uses this type of service.
Dedicated hosting is a method in which the client has free range of their website and functionality. The service is unshared, which will give the business or person more bandwidth, which leads to higher traffic margins. Flexibility is the key when using a dedicated server. You will be able to choose your hardware and operating system for your special needs. This gives you complete control over the server. You are required to have in-depth knowledge of web hosting services before you can completely use a dedicated web hosting company.
Shared hosting is the most common style for businesses and personal use. This is when your website is on a server with a couple of hundred others. You upload your website through a browser or an FTP. Then you can make changes on your website directly from the server's control panel. Shared hosting offers a setup for any scripts your website requires. In addition, they will not apply advertisements to your website.
Benefits
When you run a website, you will need a domain name for others to find you. Your webpage is linked to this address. Most companies that require payment for their services offers you to choose a domain name free of charge. Some may ask for a small yearly fee to have the domain name of your choice. In addition, using a web hosting server allows you to have the freedom of allowing your content to be seen on the World Wide Web. You can have the benefit of having your company or personal page put on one search engine or several different ones.
Analysis
Choosing a web hosting company may be a difficult task. There are several functions and considerations that you should be aware. Most companies provide a list of its benefits on the company's webpage. However, it may be difficult to understand what it is that you are actually receiving from them.
A business website requires extensive scripts to run. This includes payment methods, forms to fill out and pictures to show your products. A successful business should have plenty of bandwidth to keep up with the traffic. They should also have a simple to manage control panel where you can change what you need and leave quickly. Time is money and the simplest options are required. You will also need to decide if your company is worth a dedicated server or if a shared server will be enough for your growing business.
A personal website does not need much consideration. Blogs, family or friend pictures and information that you wish to share with the world is usually the normal webpage. You could also have a form or another method where people can share their thoughts, like a guest book. A form is a simple script but you will need to have your web host be able to run scripts. Free or shared web hosting services are capable of running a personal site. Remember, free hosting companies often require advertisements on your page.
In Feburary 2016 09,

Pitfalls in Relational Database DesignIn Feburary 2016 08,

In Feburary 2016 08,
Choosing names is an aspect of database design that is often neglected but can have a considerable impact on usability and future development. To avoid this, both table and column names should be chosen to be meaningful and to conform to the established conventions, ensuring that consistency is maintained throughout a system. A number of conventions can be used in relational database names, including the following two examples for a record storing a client name: 'client_name' and 'clientName.'
Lack of Documentation
Creating documentation for a relational database can be a vital step in safeguarding future development. There are different levels of documentation that can be created for databases, and some database management systems are able to generate the documentation automatically. For projects where formal documentation is not considered necessary, simply including comments within the SQL code can be helpful.
Failure to Normalize
Normalization is a technique for analyzing, and improving on, an initial database design. A variety of techniques are involved, including identifying features of a database design that may compromise data integrity, for example items of data that are stored in more than one place. Normalization identifies anomalies in a database design, and can preempt design features that will cause problems when data is queried, inserted or updated.
Lack of Testing
Failure to test a database design with a sample of real, or realistic, data can cause serious problems in a database system. Generally, relational database design is started from an abstract level, using modeling techniques to arrive at a design. The drawback to this process is that the design sometimes will not relate accurately to the actual data, which is why testing is so important.
Failure to Exploit SQL Facilities
SQL has many capabilities that can improve the usability and success of a database system. Facilities such as stored procedures and integrity checks are often not used in cases where they could greatly enhance the stability of a system. Developers often choose not to carry out these processes during the design stages of a project as they are not a necessity, but they can help to avoid problems at a later stage.
In Feburary 2016 08,

How to Split a String Into Two Variables in PowerShellIn Feburary 2016 08,

In Feburary 2016 08,
Start Windows PowerShell by clicking the Windows 'Start' button and typing 'powershell' into the 'Search programs and files' text box. This will open the Windows PowerShell console.
Type 'notepad split.ps1' in the PowerShell console to open Microsoft Notepad and create a new script called 'split.ps1.' Click 'Yes' when prompted by Notepad to allow the new file to be created.
Type the following commands into the new file, then save the file:$text = 'Windows PowerShell - Hello world!'$split = $text.split('-')echo $split[0]echo $split[1]First, a string is created named '$text' which holds the text to be split. The string is then split using the PowerShell 'Split' function, passing in the character the string is to be split by. In the code above, the string is split at the location of the hyphen. This creates an array in '$split' with two elements. The first element contains all the text up to the hyphen and the second element contains all the text after the hyphen. The contents of the two elements are then displayed to verify the command has worked.
Run the script in PowerShell by typing '.\split.ps1' and the display will show the output below, indicating the command was successful:Windows PowerShellHello World!
In Feburary 2016 08,

How to Convert SQLite to TextIn Feburary 2016 03,

In Feburary 2016 03,
Load a SQLite database and enter the sqlite3 environment by typing the following text at the command prompt:$ sqlite3 mydb.dbReplace 'mydb.db' with the name of your database. A database with the specified name will be created if none already exists.
Convert a value to the TEXT data type with the 'CAST' expression by typing the following command at the command prompt:$ sqlite3 my_db.db INSERT INTO my_table VALUES(CAST(97 AS TEXT))Replace 'my_table' with the name of your table. In the code, the number 97 is inserted into the table as a TEXT value.
Exit the sqlite3 environment by typing '.quit', '.q' or '.exit.' and pressing the 'Enter' key.
In Feburary 2016 03,