Tuesday, August 27, 2013
Isaac Asimov predictions for 2014
After visiting the Worlds Fair in 1964, Isac Asimov wrote an article on what the Worlds Fair of 2014 would be like. I find it impressive that he has gotten so many things right. Follow the link below to read the full article August 16, 1964, Isaac Asimov
Sunday, July 28, 2013
10 key characteristics that make IT projects succeed.
I have been involved, over the years, in a large number of successful and a number of unsuccessful IT projects. As I have been helping other companies with projects, I can usually tell ahead of time, when a project will be successful or when it will be left wanting.
What basic characteristics do successful IT projects have? Why are they successful?
I have put together my list of the 10 characteristics that make IT projects successful.
What basic characteristics do successful IT projects have? Why are they successful?
I have put together my list of the 10 characteristics that make IT projects successful.
- The project has a succinct definition.
- This is a key ingredient. If you cannot describe what the project is, it will be hard to measure its success.
- The project has a limited scope.
- Projects that try to fix or change too many things at a time often fail. If there is a need to change multiple technologies in an organization, then it is better to have multiple projects that do not go live at the same time.
- The project has buy in from upper management and the affected business units.
- This is key, no one likes to be surprised with change.
- Communication.
- The project has mechanisms in it to keep key people in the know, and also keeps the end user abreast of implementation time frames.
- The project has a backup plan with a tested recovery process.
- A tested backup plan and recovery process is needed to get your production data into test (most of the time). This is also key to any back-out plan and it should be part of the organization as a whole.
- The project is tested in a non-production environment when applicable.
- This is another key component. Never take a vendors word that nothing adverse will happen in your environment, every environment is unique.
- The project has a change management process
- Change managment is needed to put the project into production methodically. There should be no surprises, and no thinking needed when doing the actual work.
- The only time critical thinking will be needed is if something unexpected happens during the change process.
- The project has a set, well defined, back-out plan.
- Sometimes with even the best testing in a great test environment, things outside of the projects control happen and necessitate backing out the changes.
- Think power outage, new virus/trojan, etc.
- Make sure that there is sufficient time to restore data, if needed, before your maintenance window expires.
- The project offers a realistic time-frame to be accomplished.
- I have seen many small projects be under estimated. This can cause unexpected issues with users, cause all night installations. I like to use a real test scenario time frame, then add an extra 20 percent overhead to account for unknowns.
- End users have training on the project.
- Before the project is rolled into production there needs to be a thought-out training plan. Is the project small enough so that an emailed document suffices for the training?
- Is the project massive in scope for a certain department? Then make sure that key individuals have had hands on training from IT or the product manufacturer.
- Training is often overlooked, but performing it keeps your end users happy, and it keeps the help desk from getting inundated with support calls the day after the project has finished.
Thursday, May 9, 2013
Cost of HealthCare in the United States... Why does healthcare cost so much compared to the rest of the world?
Getting healthcare in the US is expensive. It is expensive if you have insurance, I continue to see my co-pay's go up and my coverage go down. My out of pocket expenses continue to go up as well as the number of items that are now non-covered or only partially covered by insurance continues to increase.
How do we get out of this healthcare dilemma? How can I make my own costs go down? In my opinion, the only way that we are going to be able to start making healthcare costs go down is to have the ability to easily find out what a medical procedure will cost from nearby hospitals and clinics before making the decision to have a procedure performed.
We (by we I mean the entire US healthcare system) need to make finding and comparing healthcare costs easier to perform for average US citizens. This one action would drive some of the costs for healthcare down.
The following are realities of our current healthcare:
- Each healthcare insurance company negotiates rates independently of each other.
- Usually the reimbursement rate for private insurance is a bit less than what medicare\medicaid pay
- The costs to a person without healthcare coverage is much more expensive then the same procedure performed on a person with healthcare coverage.
- Costs for a procedure at one facility vs costs for the same procedure at another facility vary widely.
Minnesota HealthScores has a decent attempt at comparing costs: http://www.mnhealthscores.org/index.php?p=cost_landing&category=all&sf=group
HealthCare BlueBook has a decent approach to this as well: http://www.healthcarebluebook.com/page_Default.aspx
I have not seen the issue of comparing costs come up at either major political party. I wonder if any one else has?
Lance
Wednesday, May 1, 2013
Laptop destruction stories
A photo from an Intel tweet landed on my twitter page this morning. Laptop
This photo brought to mind some of the best stories I have heard from people about how their computer was destroyed.
These are in no particular order: (almost all of them have something to due with travel)
Lance
This photo brought to mind some of the best stories I have heard from people about how their computer was destroyed.
These are in no particular order: (almost all of them have something to due with travel)
- "The TSA agent dropped it when testing it for bomb residue." This is a real thing that happens often...
- "The child sitting next to me on the airplane spilled his Coke on it." The laptop booted up one time, all data was lost... (no backup either).
- "The airline attendant spilled orange juice on the me and the laptop." I have seen something similar while on a flight, the laptop data was recovered.
- "I forgot that my briefcase was on the roof." the laptop screen was shattered, it was cheaper to replace the laptop then fix the screen. No data loss.
- "I took my laptop bag out of the trunk, then got into the car to move it, and backed over it (laptop bag)." Surprisingly the laptop actually booted up, the screen was shattered and the chassis was bent. The hardware manufacturer didn't cover the damage and a replacement laptop was issued.
- "I stopped at Como Park (a free park and zoo in St. Paul, MN) put my laptop in the trunk of the car. When I came back someone had used sheet metal cutters to open the trunk and steal the laptop" - Laptop gone, data gone...
- My favorite, since this was a laptop that I owned... "My son watched a movie at a hotel and put the laptop on the bed with all venting blocked off by a blanket, it eventually overheated turned off and never turned on again." I didn't have a backup, but didn't have too much data on it that I didn't have elsewhere.
Lance
Tuesday, April 30, 2013
The effects of short DHCP leases with long DNS scavenging times
Do you have the issue where you create a share on a client and cannot connect to it from another computer? I have seen many customers with this issue and many times the solution is a simple one.
The issue can be caused by the interaction of DNS entries and how quickly DHCP addresses are renewed.
How do you tell if this is the case? One simple way is to open up DNS look for duplicate IP entries. Look for a single IP address with 2 or more computers registered to it.
How does this happen?
Lets use the following example to illustrate one way the issue can occur.
My rules of thumb for these three settings are:
On my network I have DHCP lease set at 7 days.
No-refresh scavenging set at 3 days.
Refresh scavenging set at 3 days.
To fix my example above? I made the DHCP duration be 5 days, the DNS scavenging 2 days for both No-refresh and Refresh. I also made the wireless network use a different IP range than the wired network.
Josh Jones wrote a great blog about Scavenging check it out. Follow his advice on scavenging. There is a DNScmd switch, if run without knowing the consequences, may cause you to either restore from a good backup or spend hours adding back in static DNS entries.
Happy DHCPing and DNSing!
Lance Caven
The issue can be caused by the interaction of DNS entries and how quickly DHCP addresses are renewed.
How do you tell if this is the case? One simple way is to open up DNS look for duplicate IP entries. Look for a single IP address with 2 or more computers registered to it.
How does this happen?
Lets use the following example to illustrate one way the issue can occur.
- DHCP has its lease duration set to 2 days. (why 2 days? The site was running out of usable IP addresses and this was the easiest way to fix it.)
- DNS Scavenging is set to the default of 7 days for both the No-refresh interval and Refresh interval.
- Client A connects to the network gets IP address 10.1.1.100.
- Client A registers with DNS. The person using Computer A goes on a 1 week vacation leaving Computer A turned off.
- Three Days later Client B's computer is turned on after being off for 4 days. It gets IP address 10.1.1.100 from the DHCP server.
- Client B cannot remove Client A's entry so it registers with DNS and creates a duplicate DNS entry.
My rules of thumb for these three settings are:
- DHCP lease - make this a long as you can, but be aware of how many IP addresses you are consuming, etc. If the lease is too long you may run out of available IP's.
- Set No-refresh scavenging at 1/2 of the DHCP lease (no less than 1 day).
- Set Refresh scavenging at 1/2 of the DHCP lease (no less than 1 day).
On my network I have DHCP lease set at 7 days.
No-refresh scavenging set at 3 days.
Refresh scavenging set at 3 days.
To fix my example above? I made the DHCP duration be 5 days, the DNS scavenging 2 days for both No-refresh and Refresh. I also made the wireless network use a different IP range than the wired network.
Josh Jones wrote a great blog about Scavenging check it out. Follow his advice on scavenging. There is a DNScmd switch, if run without knowing the consequences, may cause you to either restore from a good backup or spend hours adding back in static DNS entries.
Happy DHCPing and DNSing!
Lance Caven
Monday, April 29, 2013
IT Software Support - Why does it suck so?
Don't you hate it when: You have a problem with your computer software and when you contact the company that supports the software they insinuate or indicate that you are to blame for the problem?
I have had a recent issue where the company I was working with didn't believe that I had a real problem. The support department had been working on my problem for 3 weeks and I couldn't get the issue escalated to the developers. The people in the support dept had never seen the issue before, but the developers didn't believe that the issue I was having was possible and would not assist.
The attitude that the issue is not possible, is one of my pet peeves and an attitude that no software company should ever have. There is always an explanation for a customers software issue. Covering your eyes and ears to your customers issues only make a new customer for your competitor.
Unfortunately for many good software products, technical support is terrible and sales dip or dry up.
Good customer support keeps customers allows for additional sales to them and creates new customers.
Here is my short list of what characteristics a company needs to perform above average support.
Exhibit a "get things done attitude" - be the customers advocate internally. Good support organizations have the ability to escalate issues quickly and get others involved as needed without multiple layers of approvals
Patience with new customer questions. New customers don't know that the question has been asked hundreds of times.
Quickly getting to a root cause of a problem. This makes customers happy (not waiting for the issue to be diagnosed)
Automate support where it makes sense. I don't mean the 25 level automated support tree so that you know a customer has x version of the software running on y hardware. Automate with the following goals.
Comments? Make them here.
I have had a recent issue where the company I was working with didn't believe that I had a real problem. The support department had been working on my problem for 3 weeks and I couldn't get the issue escalated to the developers. The people in the support dept had never seen the issue before, but the developers didn't believe that the issue I was having was possible and would not assist.
The attitude that the issue is not possible, is one of my pet peeves and an attitude that no software company should ever have. There is always an explanation for a customers software issue. Covering your eyes and ears to your customers issues only make a new customer for your competitor.
Unfortunately for many good software products, technical support is terrible and sales dip or dry up.
Good customer support keeps customers allows for additional sales to them and creates new customers.
Here is my short list of what characteristics a company needs to perform above average support.
Exhibit a "get things done attitude" - be the customers advocate internally. Good support organizations have the ability to escalate issues quickly and get others involved as needed without multiple layers of approvals
Patience with new customer questions. New customers don't know that the question has been asked hundreds of times.
Quickly getting to a root cause of a problem. This makes customers happy (not waiting for the issue to be diagnosed)
Automate support where it makes sense. I don't mean the 25 level automated support tree so that you know a customer has x version of the software running on y hardware. Automate with the following goals.
- Getting data to the right person faster
- Making it easier for the customer to help themselves
- Being able to data mine to identify subtle problems in the software
Comments? Make them here.
Friday, April 26, 2013
I published a SQL server deck about data and SQL Server
A link to my discussion about how SQL Server interacts with data.
How to Optimize SQL Server’s Interaction with Your Data
Let me know if this is helpful to anyone.
Lance
How to Optimize SQL Server’s Interaction with Your Data
Let me know if this is helpful to anyone.
Lance
Labels:
Disk,
IO,
SQL Server
Location:
Minneapolis, MN, USA
Wednesday, April 3, 2013
Your computer is gone, now what?
What do you mean your computer is gone? You have had a major problem and the computer doesn't work or maybe it is as simple as someone stole your laptop during the night.
You have a full backup of your data right? No? that is not surprising according to a recent blog that I read only 10% of people perform a daily backup. http://blog.backblaze.com/2012/06/12/10-now-back-up-daily-90-to-go/
What now? You have had a major data loss. You will be distracted for awhile, this issue with cause you to spend time recovering and/or recreating critical data and hinder new work from occurring.
The good news: You can recover some of your data without recreating it from scratch. Look at each of your email accounts. Your sent and received mail will have some of the data you have sent to other people. The data may not be 100 percent current, but will prevent you from recreating the data totally from scratch.
If you had a hardware failure, sometimes (very dependent on the type of failure that has occurred) data can be recovered by taking out the hard-drive from the failed computer, attaching the old hard-drive to a new computer and recovering data.
Do you use Google Drive, Drop-box or Microsoft SkyDrive? You can get your data back from those cloud based storage solutions.
Lost photos? This is one time where Facebook, friends and family are very helpful in getting photos of your vacation or kids back to your computer.
Missing music? If you use Google play or the Amazon cloud player your music can be downloaded to your new device. I don't use iTunes, but have heard that iCloud is worth looking at to prevent data loss
Full disclosure: I backup my data 2 times per day. I work for a company that provides solutions for small/mid size businesses to backup all of their data securely, on-site and off-site. I have helped restore data for disasters big and small.
Most of the recovery issues I work on relate to human error, malicious files of some sort, hardware failure or theft of equipment. I have helped members of my own family recover data. My son learned the hard way when the only copy of a file is on a memory stick and the memory stick gets washed, the data is forever gone and the homework has to be re-created from scratch.
What should you do now before losing computer data? You will eventually lose data
With the advent of more and more cloud based computing, store your data in the cloud. Office 365, SkyDrive, Drop-box, Google Drive, etc. If you are a remote user for a corporation, make an effort to copy your files to the designated location advocated by your IT department.
I like to have data on-site in a NAS device to allow me to manually put files on another computer system. (This is not true backup but allows a second copy of data in many cases which is good) I use a QNAP NAS with 4 hard drives installed. This device has tons of functionality more than I use and allows me to have iTunes, files, photos etc all accessible from one location. This device also allows me to access files from my phone while on the road. (some minor firewall work did need to be performed for this feature)
I also advocate true backups and keeping them off-site. The easiest in my opinion are cloud based from companies like backblaze for end users. You can also sign up for the one that my company hosts at DeltaWare Data Solutions. We have customers primarily in the Midwest USA, but the great thing about cloud backup is that distance is not an issue.
Your backup/recovery solution could be as simple as buying 2 external hard drives and using the no cost automated backup in Windows 7/8. You would backup to one of the hard drives while keeping the other hard drive in a different location. Swap the 2 hard drive locations about 1 time per week.
The key is to create a solution that works for you and doesn't take much time or effort. The day is coming when you will lose data, be prepared for it.
You have a full backup of your data right? No? that is not surprising according to a recent blog that I read only 10% of people perform a daily backup. http://blog.backblaze.com/2012/06/12/10-now-back-up-daily-90-to-go/
What now? You have had a major data loss. You will be distracted for awhile, this issue with cause you to spend time recovering and/or recreating critical data and hinder new work from occurring.
The good news: You can recover some of your data without recreating it from scratch. Look at each of your email accounts. Your sent and received mail will have some of the data you have sent to other people. The data may not be 100 percent current, but will prevent you from recreating the data totally from scratch.
If you had a hardware failure, sometimes (very dependent on the type of failure that has occurred) data can be recovered by taking out the hard-drive from the failed computer, attaching the old hard-drive to a new computer and recovering data.
Do you use Google Drive, Drop-box or Microsoft SkyDrive? You can get your data back from those cloud based storage solutions.
Lost photos? This is one time where Facebook, friends and family are very helpful in getting photos of your vacation or kids back to your computer.
Missing music? If you use Google play or the Amazon cloud player your music can be downloaded to your new device. I don't use iTunes, but have heard that iCloud is worth looking at to prevent data loss
Full disclosure: I backup my data 2 times per day. I work for a company that provides solutions for small/mid size businesses to backup all of their data securely, on-site and off-site. I have helped restore data for disasters big and small.
Most of the recovery issues I work on relate to human error, malicious files of some sort, hardware failure or theft of equipment. I have helped members of my own family recover data. My son learned the hard way when the only copy of a file is on a memory stick and the memory stick gets washed, the data is forever gone and the homework has to be re-created from scratch.
What should you do now before losing computer data? You will eventually lose data
With the advent of more and more cloud based computing, store your data in the cloud. Office 365, SkyDrive, Drop-box, Google Drive, etc. If you are a remote user for a corporation, make an effort to copy your files to the designated location advocated by your IT department.
I like to have data on-site in a NAS device to allow me to manually put files on another computer system. (This is not true backup but allows a second copy of data in many cases which is good) I use a QNAP NAS with 4 hard drives installed. This device has tons of functionality more than I use and allows me to have iTunes, files, photos etc all accessible from one location. This device also allows me to access files from my phone while on the road. (some minor firewall work did need to be performed for this feature)
I also advocate true backups and keeping them off-site. The easiest in my opinion are cloud based from companies like backblaze for end users. You can also sign up for the one that my company hosts at DeltaWare Data Solutions. We have customers primarily in the Midwest USA, but the great thing about cloud backup is that distance is not an issue.
Your backup/recovery solution could be as simple as buying 2 external hard drives and using the no cost automated backup in Windows 7/8. You would backup to one of the hard drives while keeping the other hard drive in a different location. Swap the 2 hard drive locations about 1 time per week.
The key is to create a solution that works for you and doesn't take much time or effort. The day is coming when you will lose data, be prepared for it.
Labels:
Backup,
lost files,
Recovery
Location:
St. Louis Park, MN, USA
Thursday, February 28, 2013
I have a new job. I am now working with a consulting company and building their service business from the ground up.
My first set of work items? Setting up a basic infrastructure, then moving to setup the recovery architecture that we will utilize for small businesses.
HP core switch, SonicWall firewall, MS Active Directory 2012, MS Exchange 2013 to start.
Next items to tackle are Hyper-V Live Migration, Replication and Clustering.
Lance
My first set of work items? Setting up a basic infrastructure, then moving to setup the recovery architecture that we will utilize for small businesses.
HP core switch, SonicWall firewall, MS Active Directory 2012, MS Exchange 2013 to start.
Next items to tackle are Hyper-V Live Migration, Replication and Clustering.
Lance
Subscribe to:
Posts (Atom)
