I just have to say something about this. Don't forget to add comments to your programs! I know it can be a little time consuming to add comments to your programs but it will save you tons of time down the road. Just think of how much time you would have saved if you ad commented out some of the programs you've worked with lately. Or better yet, think of the other applications you've worked with lately that someone else built and they forgot to add comments.
Now do you understand why I say add comments? Think of the amount of time you have had to waste picking up someone else's code and trying to figure out what it is really suppose to be doing. Or how about the time you go back and look at code you wrote years earlier. How much time would having comments in the code have saved you?
Sure, comments do bloat the size of the application a little but it causes little to no speed difference. Comments in pre-compiled languages are completely ignored and do not slow down anything and inside of files such as javascript, they are ignored but do add very slight size differences in downloading, but nothing in execution.
These are just a quick list of things that I have noticed during imports from Microsoft SQL 2000 to Microsoft SQL 2008 R2 that, if you are doing this, you should watch for. This is probably not the complete list of issues, but one's that I have noticed so far:
- Stored Procedures do not get imported. You will need to deal with these manually.
- User-Defined Functions do not get imported. You will need to deal with these manually.
- Views get imported as tables instead of Views. I've imported these manually as well.
- There are much more strict rules in SQL 2008 R2, so some bad programming that may have passed in Stored Procedures and Functions in 2000 will not just come across, even manually to 2008 R2. You may have some programming to deal with.
If you have more you would like to add, please feel free and I'll update the list. I've found that this upgrade for a database is a royal pain unless it's a simple database to begin with.
Today, while at work, I started thinking about what kind of project I could play with next, so here is my idea. I think I would like to build a CMS run on Google Go, using a MongoDB and have the front end use HTML5 and CSS3. With that being said, I've started getting the environment setup.
- First I installed the Eclipse plugin: goClipse.
- After goClipse, I downloaded MongoDB and installed it to my machine and built a directory for the database on my laptop. Check MongoDB Quickstart documentation for Windows.
- After MongoDB was installed, I added mEclipse to Eclipse as well so that I could easily work with MongoDB in Eclipse.
Now I just need to get Google Go installed on this machine and functioning properly. I wish there was an easy way to install it to a Windows machine.