Wednesday, 29 June 2011

10 things you can do to conserve Internet bandwidth



Takeaway: You can take a number of practical steps to reduce your organization’s bandwidth consumption. Here’s a rundown of some strategies to consider.
As organizations move more and more services to the cloud, it is becoming increasingly important to make efficient use of the available Internet bandwidth. Here are a few techniques you can use to conserve Internet bandwidth in your own organization.

1: Block access to content-streaming Web sites

If your organization allows employees to use the Internet for personal use, the first thing you should do is block access to streaming media sites, such as Netflix, YouTube, and MetaCafe. Playing the occasional YouTube video probably isn’t going to have a crippling effect on your Internet connection, but streaming videos do consume more bandwidth than many other Web-based services.

2: Throttle cloud backup applications

If you’re backing up your data to the cloud, check to see whether your backup application has a throttling mechanism. An unthrottled cloud backup solution will consume as much bandwidth as it can. This might not be a big deal if you’re backing up small files (such as Microsoft Office documents) throughout the day. But when you first begin backing up data to the cloud, an initial backup must be created. I have seen this process last for months, and if left unchecked, it can have a major impact on your Internet bandwidth.

3: Limit your use of VoIP

VoIP is another bandwidth-intensive protocol. If you plan to use VoIP, you might implement a policy stating that phones are to be used for business calls only. While I will be the first to admit that employees sometimes need to make calls that aren’t specifically related to work, almost everyone has a cell phone these days, so limiting the office phones to business use only shouldn’t be a big deal.

4: Use a proxy cache

A proxy cache can help limit the amount of traffic created by Web browsers. The basic idea is that when a user visits a Web site, the contents of the page are cached on a proxy server. The next time that person visits that Web page, the content does not have to be downloaded because it already exists in the cache. Using a proxy cache not only saves bandwidth, but it can give users the illusion that your Internet connection is much faster than it really is.

5: Centralize application updates

Today, almost every application is designed to download periodic updates over the Internet. You can save a lot of bandwidth by centralizing the update process. For example, rather than let every PC in your office connect to the Microsoft Update Service, you should set up a WSUS server to download all the updates and then make them available to the individual PCs. That way, the same updates aren’t being downloaded over and over again.

6: Use hosted filtering

If you operate your own mail servers in-house, a great way to save bandwidth is to take advantage of hosted filtering. With hosted filtering, your MX record points to a cloud server rather than to your mail server. This server receives all the mail that’s destined for your organization. The server filters out any spam or messages containing malware. The remaining messages are forwarded to your organization. You can save a lot of bandwidth (and mail server resources) because your organization is no longer receiving spam.

7: Identify your heaviest users

In any organization, there will be some users who use the Internet more heavily than others. It’s a good idea to identify your heaviest users and to determine what they are doing that’s causing them to consume so much bandwidth. I have seen real-world situations in which a user was operating peer-to-peer file-sharing software even though the administrator thought that the users’ desktops were locked down to make it impossible for anyone to do so.

8: Aggressively scan for malware

Malware can rob your organization of a tremendous amount of bandwidth by turning PCs into bots. Be aggressive in your efforts to keep the desktops on your network clean. Here are some resources that can help:

9: Use QoS to reserve bandwidth

QoS stands for quality of service. It is a bandwidth reservation mechanism that was first introduced in Windows 2000, and it’s still around today. If you have applications that require a specific amount of bandwidth (such as a video conferencing application), you can configure QoS to reserve the required bandwidth for that application. The bandwidth reservation is in effect only when the application is actively being used. At other times, the bandwidth that is reserved for the application is available for other uses.

10: Make sure you’re getting the bandwidth you’re paying for

A lot of factors affect Internet bandwidth, so you can’t expect to connect to every Web site at your connection’s maximum speed. Even so, your Internet connection should deliver performance that is reasonably close to what you are paying for.
I haven’t ever seen a situation in which an ISP intentionally gave someone a slower connection than they were paying for, but I have seen plenty of situations in which a connection was shared between multiple subscribers. In the case of a shared connection, a neighbor’s online activity can directly affect your available bandwidth. If your Internet connection isn’t as fast as it should be, talk to your ISP and find out if your connection is shared. You might pay a bit more for a non-shared connection, but the extra cost may be worth it.
         

                              

Will Google’s self-driving car lead to more sprawl?


Google’s self-driving car is amazing.
The Days of Summer
It’s has driven more than 140,000 miles with only one accident. And as Sebastian Thrun, one of the builders of Google’s self-driving car, explains in his TED talk, the self-driving car would could make cars more safe and make commuting by car much less of a headache.
Dream With Me
But will this science fiction-to-reality success story lead to some unintended consequences?
Writing for Fast Company, Greg Lindsay, author of Aerotropolis (read his interview with SmartPlanet here), paints the picture of how driverless cars could lead to suburban sprawl.
Driverless cars would be a perfect match for car-sharing services such as Zip 
ar or Getaround, gradually replacing the idea of car ownership with “mobility-as-a-service.” That, in turn, may lead to a precipitous fall in car ownership–as high as 50%–while breathing new life into suburbia and creating more congestions as the pain of commuting lessens.
What if you could watch movies, make Skype calls, or play with your children in the back seat until you were delivered to your doorstep? A game-changer in terms of commuting time and cost, it would breathe new life back into suburban sprawl; it’s not a problem to live two hours from work when you can spend those two hours as if you were on your couch.
Maybe Lindsay’s getting ahead of himself. But it’s easy to see how the intrigue and ease of using a self-driving car could create the perfect storm that could lead to a new generation of sprawling suburbs. Using a car would be easier than it is now if self-driving cars were linked with programs like Zipcar– you wouldn’t need to worry about maintenance, insurance, and all the other hassles of car-ownership. Plus, commuting in a car might actually be a pleasant experience.
The Lord of the Rings: The Motion Picture Trilogy (Extended Edition + Digital Copy) [Blu-ray]
But, really, it’s a worry for another day. Because meanwhile there are 250 million personal vehicle in the U.S. today. And everyday they’re embarking on a commute that is killing them. The reality is, people who want to live in the suburbs will live there whether commuting is easy or not. And people who want to live in walkable, dense community will live there even if commuting in a car is easier. If nothing else, I can’t imagine that Google’s self-driving car would make sprawl any worse than it is today.
Smokin' Seventeen: A Stephanie Plum Novel
Dell Optiplex Computer with LCD Flat Panel Monitor (Single Core 2.8Ghz Pentium 4 Processor, 1 GB RAM, 40 GB Hard Drive, Windows XP)
Apple iMac MC508LL/A 21.5-Inch Desktop
Toshiba Satellite L655-S5158 15.6-Inch Laptop (Black)
HP Omni 100-5050 All-in-One Desktop PC - Black
Dell 2.8 Ghz. Super Fast GX Computer with 19 inch LCD Flat Panel Monitor, Gigantic 750GB Hard Drive, 4GB RAM, DVD Burner (DVD-RW), and New Licensed Windows XP with Genuine Microsoft Authorized CD
Dell D600 Laptop (1.6ghz, 40 GB Hard Drive, DVD/CD-RW)
Compaq Presario CQ5700F PC (Black)Dell Optiplex GX620 Desktop Computer With LCD Monitor
How Computers Work (9th Edition)
Apple MacBook MC516LL/A 13.3-Inch Laptop

Tuesday, 28 June 2011

10 ways to change up your spreadsheet design!


Wrong references, missing values, and invalid data aren’t the only things that will ruin a spreadsheet. The development process starts before you do a thing, while you’re planning the design. These types of mistakes are worse than bugs because you can’t troubleshoot them. All you can do is start over. Here are 10 mistakes to avoid early in the process, when you’re still in the decision-making phase.

1: That sheet has a million rows and I’m going to fill them all!

An Excel 2007 sheet suggests that you can have up to a million rows of data — but you really can’t. If you have that much data, you need more power than Excel has to offer. Consider a new strategy, such as using SQL Server Express. Excel simply can’t handle that much data even if it gives the impression that it can.

2: I use Excel as my database

“Hi! I’m working on a database project and I’m using Excel.” Um… not with my help, you’re not. An Excel sheet and a database table may look similar. Excel displays data in rows and columns, but that’s as close as an Excel sheet and a database table get. If you must use an Excel workbook to store data in database-like fashion, think in terms of a flat file database (which repeats values from record to record). If you need a relational database system, use Access or SQL Server. Having multiple sheets doesn’t give a workbook relational capabilities. You’ll just break your heart trying to use Excel that way.

3: I know a few blank cells won’t matter

Empty cells aren’t wrong, but they can interfere with the way some functions work. For instance, the AVERAGE() function evaluates the value 0 and an empty cell differently. In addition, many features interpret a blank cell as the end of your data. For these reasons, avoid a design that accommodates blank cells when possible. If empty cells are valid, define those values within the context of the tools and functions you’ll be using, so you can avoid unexpected errors and bad data.

4: I always start at A1

Many developers anchor their spreadsheets at A1 — it’s a habit. That means summarizing functions and expressions are at the bottom or the right of all the data. In a small sheet, it doesn’t matter, but a large sheet is another story. Users will waste a lot of time scrolling between the data and summary values. You can build a custom view or show users how to use [F5], but there’s a more efficient alternative. Leave a few blank rows at the top and a few blank columns to the left of the data range. That way, you can insert summarizing functions in the first screen the users see. Those top blank rows are also a good spot for advanced filter criteria.

5: I put as much as possible in each cell

An Excel sheet isn’t a trash compactor. The more data you put into a single cell, the fewer opportunities you’ll have to use and extract the data you need. Instead, atomize! Within the context of designing a spreadsheet, atomize means to break down your data into the smallest possible elements. For instance, if you’re storing names, split the first and last names into two columns instead of one. If you store the names in firstname lastname format, you can’t sort by last name. If you think the easy solution to that dilemma is to use lastname firstname format, you might get a surprise later on — someone is sure to ask for that type by first names. Always break your data into the smallest reasonable pieces. You can concatenate values later, but it’s difficult to reverse-engineer data.

6: I set all my sheets to manual to speed things up

By default, Excel automatically recalculates formulas when a dependent cell changes. In a poorly designed or large workbook, all that calculating can slow things down. A common reaction to a slow workbook is to set the calculation mode to manual. The sheet will then recalculate only when you explicitly tell it to by pressing [F9]. There’s an unseen consequence to this madness, though: Eventually, you will refer to a value that hasn’t been updated. Manual calculation isn’t bad; it just isn’t the right fix for a slow workbook.

7: I did it myself!

This is one of those tips that won’t benefit the folks who need it the most — they won’t recognize themselves. Most of us (and I include myself in this group) don’t have all the necessary skills to build from scratch every spreadsheet we need. We’re not stupid. We just lack a particular skill set. When you don’t feel quite up to the task, rely on someone else. It’s okay to start with a prebuilt template and make changes to meet your needs. Your end product will be more dependable and you’ll save time.

8: I love to jazz up my spreadsheets with WordArt

“Word on the street is, he uses WordArt. Amateur!” I don’t understand why, but WordArt is definitely taboo. Professionals absolutely hate it. If you use it, no one will notice your efficient formulas or helpful macros. All they’ll see is your snazzy WordArt headings. They’ll shake their heads and call another developer. WordArt produces some interesting effects, but never use it in a professional application.

9: I put everything on Sheet1 so it’s easy to find

By default, Excel provides three two-dimensional sheets, and you can add more. The inclination is to put everything on the first sheet and to ignore the rest. It’s an extreme you should avoid. If you cram everything onto that first sheet, you’ll end up with a mess that’s hard to use. When designing sheets, think in terms of major functions or tasks. Everything doesn’t have to fit on one screen — it’s about function, not display. Each sheet’s task should be specific and autonomous. Dedicated sheets are easy to use and maintain.

10: I distribute everything across a whole bunch of sheets

The opposite of #9 is using dozens of sheets, each containing just a small amount of data. This design mistake won’t make data easier to find. In fact, the more sheets your users have to browse, the more difficult it will be to find what they need. And once you spread your data across too many sheets, mistakes start creeping in. You reference the wrong sheets, the wrong cells — it’s difficult to keep track of all the pieces when they’re spread out like that.



Microsoft Office 2010 Home & Student (Disc Version)
Microsoft Office Home and Student 2007 [Old Version]
Microsoft Office Home & Student 2010 Product Key Card
Microsoft Office Home & Business 2010 Product Key Card
Microsoft Office 2010 Professional


LINK: http://www.techrepublic.com/blog/10things/10-ways-to-screw-up-your-spreadsheet-design/2562?tag=nl.e101