In Feburary 2016 24,
Run SQLite queries from the command prompt with the 'sqlite3' program by typing:$ sqlite3 my_db.dbThis will create a database with the name 'my_db.db' if it doesn't already exist. It also places you in the sqlite3 environment, which you can exit with the commands '.quit', '.q' or '.exit.'
Call the 'strftime (format, timestring, modifier, modifier)' function to return a formatted date from a time string. This is useful for comparing dates, displaying a date in a certain format to a user or to upload a date in a consistent matter. The format of a time string follows the rules from the C 'strftime' function. Some of the valid time string formats include 'YYYY-MM-DD,' 'YYYY-MM-DD HH:MM,' 'YYYY-MM-DD HH:MM:SS,' 'YYYY-MM-DD HH:MM:SS.SSS,' 'DDDDDDDDDD' and 'now.' The 'Y' character stands for year, 'M' for month, 'D' for day, 'H' for hour, 'M' for minute and 'S' for second. The 'DDDDDDDDDD' format represents a unix timestamp. For example, the following query will compute how many seconds have passed since a date in 2002:$ sqlite3 my_db.db SELECT strftime('%s','now') - strftime('%s','2002-05-11 01:56:23');
Call the 'date,' 'time,' 'datetime' or 'julianday' functions to use a pre-formatted version of the 'strftime' function. The 'date' function returns the date with the format 'YYYY-mm-dd,' the 'time' function returns it as 'HH:MM:SS,' the 'datetime' function returns it as 'YYYY-mm-dd HH:MM:SS' and the 'julianday' function returns the Julian day number. For example, the following query will return a date from 2009 as '2009-09-22,' removing the hour, minute and second information:$ sqlite3 my_db.db SELECT date('2009-09-22 02:57:13');
In Feburary 2016 24,
Showing posts with label call. Show all posts
Showing posts with label call. Show all posts
Wednesday, 24 February 2016
Tuesday, 23 February 2016
How to Get Teenagers to Clean Up After ThemselvesIn Feburary 2016 23,
In Feburary 2016 23,
Write down your cleaning expectations. Your teen will look for ways out of consequences by claiming you were not clear. Write down the rules for cleaning up after yourself and make copies to put them in areas of the house that your teen frequents. If cleaning up after meals means putting your plate in the dishwasher, for example, write it down plainly. Write down that cleaning his room includes vacuuming and hanging clothes in the closet, if that is what you expect.
Make the consequences clear. Your teen should know that for every instance of not cleaning up after himself, he can expect a consequence. Stay absolutely firm on this to get the point across. If you decide to remove his TV privileges when he doesn't clean up after himself, do not give in 'just this once,' if he pleads with you. Otherwise your teen will start to think they can get away with breaking the rules.
Never clean up your teen's mess under any circumstance, even after giving your teen a consequence. Make him do what he should have done in the first place and clean up the mess he made.
Practice what you preach. If you do not model cleaning up after yourself, you can hardly expect your teen to do the same. He will not hesitate to call you out on your messy and hypocritical behavior, so don't leave the newspaper you just read strewn on the coffee table. Hang up your coat in the closet, rather than tossing it on to a chair when you get home.
Take extreme measures when absolutely necessary. If the regular consequences are not having an effect on your teen, let him know that you will turn your problem into his problem. For example, If your teen constantly leaves the table without putting his plate in the dishwasher, leave his dirty plate, cup and utensils right where they are until the next meal. He will have to wash it himself and re-use it to enjoy dinner. If your teen keeps leaving his wet towel on the bathroom floor, he can no longer use the towels. Make him buy his own with his allowance, and if he leaves that one on the floor, take it. It is your bathroom and those are the rules.
Negotiate within reason. Teens often have hectic schedules, which can make it tough for them to maintain your cleaning expectations. If cleaning up his room is the major issue, talk to your teen about establishing a cleanup day once a week, when he has time to do a thorough cleaning, provided he at least keeps the clothes off his floor during the rest of the week. If he has a particularly busy week, allow him to negotiate for easier or quicker chores with his siblings, such as taking out the trash instead of mopping the kitchen floor.
Talk to your teen. Teens often think parents just want to nag them about doing chores for no reason. Have a heart-to-heart with your teen to explain that you are trying to prepare them for a future where they will have to share their living space with others. Not cleaning up after himself will show a disregard for his roommates and their shared space. Explain that it also makes you feel he has little regard for the upkeep of the home that you and your spouse worked hard to provide for him and the rest of the family. Helping him see the issue from your perspective might make him think twice before walking away from his own mess.
In Feburary 2016 23,
Write down your cleaning expectations. Your teen will look for ways out of consequences by claiming you were not clear. Write down the rules for cleaning up after yourself and make copies to put them in areas of the house that your teen frequents. If cleaning up after meals means putting your plate in the dishwasher, for example, write it down plainly. Write down that cleaning his room includes vacuuming and hanging clothes in the closet, if that is what you expect.
Make the consequences clear. Your teen should know that for every instance of not cleaning up after himself, he can expect a consequence. Stay absolutely firm on this to get the point across. If you decide to remove his TV privileges when he doesn't clean up after himself, do not give in 'just this once,' if he pleads with you. Otherwise your teen will start to think they can get away with breaking the rules.
Never clean up your teen's mess under any circumstance, even after giving your teen a consequence. Make him do what he should have done in the first place and clean up the mess he made.
Practice what you preach. If you do not model cleaning up after yourself, you can hardly expect your teen to do the same. He will not hesitate to call you out on your messy and hypocritical behavior, so don't leave the newspaper you just read strewn on the coffee table. Hang up your coat in the closet, rather than tossing it on to a chair when you get home.
Take extreme measures when absolutely necessary. If the regular consequences are not having an effect on your teen, let him know that you will turn your problem into his problem. For example, If your teen constantly leaves the table without putting his plate in the dishwasher, leave his dirty plate, cup and utensils right where they are until the next meal. He will have to wash it himself and re-use it to enjoy dinner. If your teen keeps leaving his wet towel on the bathroom floor, he can no longer use the towels. Make him buy his own with his allowance, and if he leaves that one on the floor, take it. It is your bathroom and those are the rules.
Negotiate within reason. Teens often have hectic schedules, which can make it tough for them to maintain your cleaning expectations. If cleaning up his room is the major issue, talk to your teen about establishing a cleanup day once a week, when he has time to do a thorough cleaning, provided he at least keeps the clothes off his floor during the rest of the week. If he has a particularly busy week, allow him to negotiate for easier or quicker chores with his siblings, such as taking out the trash instead of mopping the kitchen floor.
Talk to your teen. Teens often think parents just want to nag them about doing chores for no reason. Have a heart-to-heart with your teen to explain that you are trying to prepare them for a future where they will have to share their living space with others. Not cleaning up after himself will show a disregard for his roommates and their shared space. Explain that it also makes you feel he has little regard for the upkeep of the home that you and your spouse worked hard to provide for him and the rest of the family. Helping him see the issue from your perspective might make him think twice before walking away from his own mess.
In Feburary 2016 23,
Monday, 8 February 2016
How to Retrieve Skype Users IPIn Feburary 2016 08,
In Feburary 2016 08,
Click the 'Start' button, then click the 'Search' box. Type 'cmd' in the 'Search' box, and then right-click on the command line icon that appears and click 'Run as Administrator.'
Click the 'Start' button, then click 'Programs.' Click the 'Skype' program group in the program list that appears, and then click the 'Skype' icon. The Skype application window will appear.
Click the 'Contacts' button located toward the top of the 'Skype' window. Locate and then click on a Skype contact you wish call from the list of contacts presented in the Skype window.
Click the green 'Call' button to connect with the contact through Skype. When the contact has accepted the call and video, audio or an instant message response is received, the connection is established.
Type 'netstat -nb' on the command line. Press the 'Enter' key. Find the Skype program listed in the first column of the command line output. Note the IP addresses listed for the Skype application.
Navigate to the large file you wish to transfer using Windows Explorer. Place the mouse cursor over the file, hold down the left mouse button and then drag the file over the icon of the contact that is in the chat session. Release the left mouse button to start the file transfer.
Type 'netstat -nb' on the command line. Press the 'Enter' key once the file transfer has started. Find the Skype program listed in the first column of the command line output. Note the new IP address added to the list for the Skype program, as that is the IP address of the Skype contact to which the large file is being transferred.
In Feburary 2016 08,
Click the 'Start' button, then click the 'Search' box. Type 'cmd' in the 'Search' box, and then right-click on the command line icon that appears and click 'Run as Administrator.'
Click the 'Start' button, then click 'Programs.' Click the 'Skype' program group in the program list that appears, and then click the 'Skype' icon. The Skype application window will appear.
Click the 'Contacts' button located toward the top of the 'Skype' window. Locate and then click on a Skype contact you wish call from the list of contacts presented in the Skype window.
Click the green 'Call' button to connect with the contact through Skype. When the contact has accepted the call and video, audio or an instant message response is received, the connection is established.
Type 'netstat -nb' on the command line. Press the 'Enter' key. Find the Skype program listed in the first column of the command line output. Note the IP addresses listed for the Skype application.
Navigate to the large file you wish to transfer using Windows Explorer. Place the mouse cursor over the file, hold down the left mouse button and then drag the file over the icon of the contact that is in the chat session. Release the left mouse button to start the file transfer.
Type 'netstat -nb' on the command line. Press the 'Enter' key once the file transfer has started. Find the Skype program listed in the first column of the command line output. Note the new IP address added to the list for the Skype program, as that is the IP address of the Skype contact to which the large file is being transferred.
In Feburary 2016 08,
How to Roast a CoworkerIn Feburary 2016 08,
In Feburary 2016 08,
Structure your roast speech around a particular event that the coworker is tied to; instruct the others participating in your roast to do the same. Use the coworker's birthday, anniversary, retirement or promotion for humor fodder (e.g., a retirement roast is perfect for jokes about aging; a promotion roast would call for jokes about poor workmanship).
Keep speech length at around 5 minutes, so all who wish to speak can do so without boring the audience. Avoid engaging in jokes and put-downs that are too harsh or are not directly related to the occasion at hand.
Include characteristics, traits and idiosyncrasies of the honoree, such as the honoree's style of dress, habits, personality quirks and communication style. Avoid subjects pertaining to family dysfunction, physical or emotional handicaps or romantic/sexual relationships.
Set up for the festivities. Arrange the podium and seating in a U formation, with all the seating facing the podium, which is at the center. Provide a microphone at the podium.
In Feburary 2016 08,
Structure your roast speech around a particular event that the coworker is tied to; instruct the others participating in your roast to do the same. Use the coworker's birthday, anniversary, retirement or promotion for humor fodder (e.g., a retirement roast is perfect for jokes about aging; a promotion roast would call for jokes about poor workmanship).
Keep speech length at around 5 minutes, so all who wish to speak can do so without boring the audience. Avoid engaging in jokes and put-downs that are too harsh or are not directly related to the occasion at hand.
Include characteristics, traits and idiosyncrasies of the honoree, such as the honoree's style of dress, habits, personality quirks and communication style. Avoid subjects pertaining to family dysfunction, physical or emotional handicaps or romantic/sexual relationships.
Set up for the festivities. Arrange the podium and seating in a U formation, with all the seating facing the podium, which is at the center. Provide a microphone at the podium.
In Feburary 2016 08,
Thursday, 4 February 2016
Is it Better to Host Your Own Server or Lease Server Space?In Feburary 2016 04,
In Feburary 2016 04,
When you lease server space from a Web hosting company, the provider handles the important tasks of properly storing and maintaining the server. Web servers must be stored in special facilities and thoroughly maintained to ensure an extended lifespan and prevent problems like overheating. If you were to host your own server, you would need to set up the server at home or pay the fees required to store it at a dedicated server facility.
Ease of Expansion
With a leased server, expansion merely requires putting in a call to your hosting company and requesting whatever it is you need -- whether it's a faster processor, more memory, a large hard disk drive or a bigger database. If you purchase your own server, you are solely responsibly for making these upgrades, meaning you must know how to open up a server, remove deprecated components and replace them with newer, better-functioning modules.
Shorterm/Longterm Costs
Shared and dedicated servers may be leased for as little as $4.99 to $99.99 per month, depending on the server's specifications. To set up your own server, however, you would need to spend at least $500, if not much more, to cover the processors, memory cards and hard drives. This doesn't even take into consideration the fees associated with storing the server at a data center, assuming you were to take that route.
Cloud Computing
Another option is to pursue cloud computing, a revolutionary form of data management wherein everything -- including hardware, applications -- is provided through the Internet via what is known as a 'cloud.' It's slowly gaining popularity because, according to PC Magazine, it allows 'companies [to] spend more money on infrastructure and less money on the actual hardware.' One limiting factor, however, is that like with shared hosting, you are essentially 'at the mercy of the provider.'
In Feburary 2016 04,
When you lease server space from a Web hosting company, the provider handles the important tasks of properly storing and maintaining the server. Web servers must be stored in special facilities and thoroughly maintained to ensure an extended lifespan and prevent problems like overheating. If you were to host your own server, you would need to set up the server at home or pay the fees required to store it at a dedicated server facility.
Ease of Expansion
With a leased server, expansion merely requires putting in a call to your hosting company and requesting whatever it is you need -- whether it's a faster processor, more memory, a large hard disk drive or a bigger database. If you purchase your own server, you are solely responsibly for making these upgrades, meaning you must know how to open up a server, remove deprecated components and replace them with newer, better-functioning modules.
Shorterm/Longterm Costs
Shared and dedicated servers may be leased for as little as $4.99 to $99.99 per month, depending on the server's specifications. To set up your own server, however, you would need to spend at least $500, if not much more, to cover the processors, memory cards and hard drives. This doesn't even take into consideration the fees associated with storing the server at a data center, assuming you were to take that route.
Cloud Computing
Another option is to pursue cloud computing, a revolutionary form of data management wherein everything -- including hardware, applications -- is provided through the Internet via what is known as a 'cloud.' It's slowly gaining popularity because, according to PC Magazine, it allows 'companies [to] spend more money on infrastructure and less money on the actual hardware.' One limiting factor, however, is that like with shared hosting, you are essentially 'at the mercy of the provider.'
In Feburary 2016 04,
Monday, 1 February 2016
How to Calculate Download TimeIn Feburary 2016 01,
In Feburary 2016 01,
Reference the size of the file. If you are downloading from a website, or an FTP site, the download size might be listed next to the download link. On a peer-to-peer transfer program, the size is usually listed in one of the columns.
Determine your connection speed. This information should have been provided when you signed up for your Internet service. If not, call you Internet service provider and ask them your connection speed. Common connection speeds are 56 Kb for dial up or 3.0 to 10.0 Mbps for high-speed access. You can also test your speed using online speed tools, such as Speedtest.net, Speakeasy.net and CNET.com.If you know the website or P2P connection speed, and it is slower than yours, then use that speed for the calculation. When downloading, you can only download as fast as the slowest connection.Alternatively, begin downloading the file and look at the progress window. Typically, the actual download speed is displayed. Using this figure saves you to trouble of determining your or the website's connection speed.
Convert the connection speed into the same units as displayed for the download. As an example, If the download was 200 MB, then you will want to convert your connection speed to MB. As an example, you might have a 3.0 Mbps connection. Note the difference between the capitalized and lower case 'B,' which signifies 'bytes' or 'bits' respectively. Since there are 8 bits in a byte, you would divide 3.0 Mb by 8 to convert the connection speed to 0.375 MB per second.
Divide the download size by the connection speed to calculate download time. In the example, 200 MB divided by 0.375 MB per second gives you a download speed of 533 seconds, or 8 minutes and 53 seconds.
In Feburary 2016 01,
Reference the size of the file. If you are downloading from a website, or an FTP site, the download size might be listed next to the download link. On a peer-to-peer transfer program, the size is usually listed in one of the columns.
Determine your connection speed. This information should have been provided when you signed up for your Internet service. If not, call you Internet service provider and ask them your connection speed. Common connection speeds are 56 Kb for dial up or 3.0 to 10.0 Mbps for high-speed access. You can also test your speed using online speed tools, such as Speedtest.net, Speakeasy.net and CNET.com.If you know the website or P2P connection speed, and it is slower than yours, then use that speed for the calculation. When downloading, you can only download as fast as the slowest connection.Alternatively, begin downloading the file and look at the progress window. Typically, the actual download speed is displayed. Using this figure saves you to trouble of determining your or the website's connection speed.
Convert the connection speed into the same units as displayed for the download. As an example, If the download was 200 MB, then you will want to convert your connection speed to MB. As an example, you might have a 3.0 Mbps connection. Note the difference between the capitalized and lower case 'B,' which signifies 'bytes' or 'bits' respectively. Since there are 8 bits in a byte, you would divide 3.0 Mb by 8 to convert the connection speed to 0.375 MB per second.
Divide the download size by the connection speed to calculate download time. In the example, 200 MB divided by 0.375 MB per second gives you a download speed of 533 seconds, or 8 minutes and 53 seconds.
In Feburary 2016 01,
Subscribe to:
Posts (Atom)