Now Playing Tracks

SQL Server 2008 Evaluation Edition Expiration

This happened to me today…check this out.

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/20/sql-server-2008-evaluation-edition-expiration-woes.aspx

here is currently a workaround that can be done to resolve this problem.  Open RegEdit and change the value of the CommonFiles REG_DWORD under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState registry from 1 to 3 and then rerun the Edition Upgrade.  This will allow the Upgrade to Management Studio to complete properly.

Next: Run the install manager, and go to maintenance for Edition Upgrade.

Insert the Key (The key is on the CD/DVD) for SQL Server 2008.

SQL Server 2005 Backup a Remote Database

So you have a remote SQL Server 2005 database running on a different network than your client machine and you want a backup copy of that database. Most common scenario, the database is on your web hosting server. Somehow I never thought this would be a big issue. I am so used to just using the SQL Management Studio, right clicking on a database, selecting Tasks, and then backup. But when you backup SQL Server, it is to a local drive or a mapped network drive that the server itself has access to. Implying that if you are accessing SQL Server on a server on another network on a machine that you do not have access to, you cannot backup SQL Server to your drive. So how do you get a backup copy? I found it quite frustrating that I can connect to the database using SQL Management Studio, run queries, make changes etc, but I cannot get a copy of the database to my machine. Under Tasks there is an option to Copy Database but I just could not get that to work. I kept getting a security Exception. One day I will have to look into why. Until then lets proceed to the so called right way to do it. Remember DTS from all prior versions of SQL Server? We it kind of vanished with SQL Server 2005. Not really, it has a new name, SSIS and is installed when you install Integration Services. Once installed you will see “SQL Server Business Intelligence Development Studio” on your Start Menu under SQL Server 2005. Click on it and Visual Studio will launch. At first I thought this has got to be a mistake. But no, I was at the right spot. I created a new Integrated Services Project and under Project I selected the SSIS import export wizard. Now the familiar DTS Wizard pops up and you can do what you were used to doing in all prior versions of SQL Server 2005. Connect to the remote database and get all your data to a local database. Why couldn’t this be a single link on Management Studio as a simple Copy Database? Because that would make it logical and simple. By the way, my data transfer failed several times before succeeding, so be patient. :-)

HTML 5

I was just reading about HTML5 and I have to admit, it’s pretty awsome and has so many great features that enhance the user’s experience with the web.

But…

The only problem I found is that it’s not yet supported on all browsers…

So I guess I’ll just use my good old classic HTML and css and maybe some javascript for the time being until HTML 5 gets supported on all browsers…

From Nokia to Android (Copy SMS Messages)

Nokia2AndroidSMS is a small application that allows you to convert SMS messages from Nokia Ovi datafiles into an xml file supported by SMS Backup & Restore Android application.

Process for transferring SMS messages to your new Android Phone is the following.

Nokia phone side:

  1. Install Nokia OVI, (You don’t need the OVI account!)
  2. synchronize messages from your phone with OVI
  3. Disconnect your Nokia Phone and close the Nokia OVI application. WATCH OUT. Noia OVI likes to minimize to system tray please be sure you relay closed the application

Conversion:

  1. Download Nokia2AndroidSMS and extract it to any directory.
  2. Run Nokia2AndroidSMS.exe
  3. The application should automatically find all datastores created by Nokia OVI and automatically select the 1st one.
  4. If it should fail to detect datastores you’ll have to find it by yourself, you can either drag and drop datastore file from Windows Explorer onto the Nokia2AndroidSMS window or use the Open button to find it.
  5. You can change the datastore in the 1st selection list if there is more than one
  6. If you have more than one phone in the datastore than you can select for which you’d like to export the messages, they are listed by their IMEI number.
  7. Press Convert button and you should get an xml file in the same folder you extracted Nokia2AndroidSMS to

Android:

  1. Install SMS Backup & Restore
  2. Connect the phone onto the PC (You MUST select Disk drive as connection type)
  3. Copy the xml file into the SMSBackupRestore Folder on the phone, create it if it’s not already there
  4. Run SMS Backup & Restore and import messages.

Here’s the link to Nokia2AndroidSMS application:

http://www.simail.si/nokia2androidsms/

Just few things to clarify for other users. When copying xml file to Android phone’s sdcard you have to create a new folder in it (using ur usb connection to create a folder from ur pc), if not already there, and name it as “SMSBackupRestore” without quotes. Once the xml file is successfully copied to sdcard you then have to disconnect the USB cable from your computer (by stopping it properly). Only then you should run the SMS Backup & Restore application and select “Restore SMS Messages”.

Worked like a charm. I copied my messages from Nokia N85 to Sony Ericsson Xperia X10 :))

The Humble Programmer

This post is from this amazing article I found at Coding Horror:

http://www.codinghorror.com/blog/2004/08/why-im-the-best-programmer-in-the-world.html

The intense inwardness of programming makes personal character especially important. You know how difficult it is to put in eight concentrated hours in one day. You’ve probably had the experience of being burned out one day from concentrating the day before or burned out one month from concentrating too hard the month before. You’ve probably had days on which you’ve worked well from 8:00 am to 2:00 pm and then felt like quitting. You didn’t quit, though; you pushed on from 2:00 pm to 5:00 pm and then spent the rest of the week fixing what you wrote from 2:00 to 5:00.

Programming work is essentially unsupervisable because no one ever really knows what you’re working on. We’ve all had projects in which we spent 80 percent of the time working on a small piece we found interesting and 20 percent of the time building the other 80 percent of the program.

Your employer can’t force you to be a good programmer; a lot of times your employer isn’t even in a position to judge whether you’re good. If you want to be great, you’re responsible for making yourself great. It’s a matter of your personal character.

At the top of the list of desirable personal character traits is humility:

Nobody is really smart enough to program computers. Fully understanding an average program requires an almost limitless capacity to absorb details and an equal capacity to comprehend them all at the same time. The way you focus your intelligence is more important than how much intelligence you have

At the 1972 Turing Award lecture, Edsger Dijkstra delivered a paper titled “The Humble Programmer.” He argued that most of programming is an attempt to compensate for the strictly limited size of our skulls. The people who are best at programming are the people who realize how small their brains are. They are humble. The people who are the worst at programming are the people who refuse to accept the fact that their brains aren’t equal to the task. Their egos keep them from being great programmers. The more you learn to compensate for your small brain, the better a programmer you’ll be. The more humble you are, the faster you’ll improve.

The purpose of many good programming practices is to reduce the load on your gray cells. You might think that the high road would be to develop better mental abilities so you wouldn’t need these programming crutches. You might think that a programmer who uses mental crutches is taking the low road. Empirically, however, it’s been shown that humble programmers who compensate for their fallibilities write code that’s easier for themselves and others to understand and that has fewer errors. The real low road is the road of errors and delayed schedules.

When interviewing candidates for programming positions, I always look for someone who is brave enough to say “I don’t know” when they need to. Candidates who can’t or won’t do this get red flagged; those types of programmers are dangerous. “Can-do” attitiudes have a superficial allure, but they’re actually poison in our field.

Isn’t the world of development blogs, an amazing fountain of seemingly endless knowledge— also incredibly humbling? There are so many people, many of them giants in the field, who are far smarter and just plain better than I will ever be.

But it’s not our job to be better than anyone else; we just need to be better than we were a year ago.

To Tumblr, Love Pixel Union