Upgrading from SQL Server 2005 Express to SQL Server 2008 Express CTP

I currently have SQL Server 2005 Express Edition installed on my system. I also have the Visual Web Developer 2008 Express Beta 1 installed, but while installing it I did not choose for SQL Server 2008 Express to be installed. So now I am going to try and install it separately. This post is about what I am doing on my system and the steps here may not work in your case. But still I am putting it up as a reference.

 

Go to the Microsoft Express editions site and click on download SQL Server 2008 CTP. Also back up your existing databases. One thing I have learnt in the industry is that it is never too expensive to keep backups. Always keep a backup, at least for those things that you feel are critical.

 

 

After you have downloaded the setup, when you execute it, the first screen you get is the EULA.

Read the License at least once. Most of us don't read and select the I accept terms checkbox and click next. By reading I do not mean understand each and every thing, but just skim through it once to see if it contains anything that might interest you. e.g The above License says that it is valid till July 25, 2008, which is not very far and that the software will stop working after 180 days since installation. These are things which caught my eye.

When you proceed you get the following screen.

 

I clicked on Install and then get the following screen.

 

I see the option of Upgrade SQL Server 2005 to 2008 which says I should run the Update Advisor first. I can't find the Update Advisor so I just select the option to see what happens. It opens a new windows where it checks my system. In the options on the left side of the Wizard I can see Select instance, meaning I would have to select my SQL Server 2005 Instance which I want to upgrade. Since I came across this post in ASP.NET forums, I am not sure that is what I want to do. Plus there is nothing wrong in having both the versions of SQL Server running as different Instances. At work, I have seen people with both SQL 2000 and 2005 on their systems. So I cancel the Wizard and then in the window above I select New Installation.

I get the System Configuration Check again which is Successful. But now on the left side in the steps, I DO NOT see Select Instance. So my guess is that this is going to install a new Instance of SQL Server 2008 and not do anything to SQL Server 2005 already alive and kicking. I click on Next.

 

I select all the options and click on Next. (Actually I had already clicked on Next and moved to the Next Step when I realized that I had not taken the screen shot of the step. So I moved to previous one to take the screen shot. But notice that in the steps on the left, the Next Step is already checked. A BUG!)

Instead of Default Instance, I select Named Instance and Give it a new name SQL2008CTP. I can see 2 existing Instances towards the bottom, one of which is SQL 2005 instance.

Next it is asking for the User Name and Password (Credentials) to configure the service. Provide the appropriate details. You are then shown the screen below for database engine configuration.

 

I chose the mixed mode authentication. I am no DB guy and I do this because one of my first mentors told me that always choose Mixed Mode.

I then get a screen above for sending data to MSFT. I click on Next.

I then get the summary of the Installation order.I click Install to begin the installation.

 

Above is a screen shot I took while the installation was in progress. Though the progress bar did not reach 100% the next button was enabled and the progress bar remained that way for quite some time so I just pressed next to go the following screen.

I then go to services.msc  and check if the service has been installed.

 

As you can see, now there are three instances of SQL Server running. So SQL2008CTP seems to be running fine along with SQLEXPRESS which is SQL Server 2005 Express.  I now go to SQL Server Management Studio Express but I cant find the 2008 CTP instance I just installed. So I think I should restart my computer once. It is always better to restart in my experience.

I restarted and checked but still I don't see the 2008 CTP instance in Management Studio Express, probably because the Management Studio Express is and older version and may not recognize newer versions of SQL Server. So now I open VWD 2008 Express Beta 1 and go to Database Explorer and try to add a new connection.

As expected I can see the 2008 CTP instance I installed.  I provide the sa login and password and select tempdb database and test the connection and Voila!

So things seem to be working fine. Phew!

Hope this was helpful! Please comment if you have any queries.

Firefox 3 launch Goof up?

Many a times when techies talk about goof ups and product launches, they remember the OS crashing at the launch of Microsoft Windows 98, the video of which I have included just in case you forgot about it.

While that certainly is something which will probably rank first in the list of product launches and goof-ups, we have another one today.

Yes, today is Download Day. I did get the mail on time reminding me about the download. But there has been a goof up in this all hyped Guinness style product launch.

As you can see in the above screen shot, I have showed you the mail which I got informing of the download time. There when I hover above the link download Firefox 3, I get the url on the status bar of the browser which I have encircled.

Now, when I go to the same url what do I get?

Firefox 2?? You got to be kidding me!! And all we get is a sneak peek into Firefox 3, to test drive the latest version.

Probably, the guys at Mozilla were so busy counting the numbers pledged for the download that they forgot to make the to do list, or worse they made the to do list and forgot to update the page that the url redirects to.

I dont know what was the mistake and who made it, but you sure dont want to this to happen when you are publicizing the event with the Guinness tag attached to it!

So what do you guys think went wrong?

My Date with the VC's

As I had said in one of my previous posts, one fine Saturday I had been to an event called Startup City organized by the The Smart Techie. I had mailed a few of my friends about the event and lured a few of them to wake up early on a Saturday morning. I almost did not make it, as I was feeling very sleepy and did not feel like getting up, but since I had promised NEO that I would be picking him up around 8:00 am I got up and got ready. We reached 10 minutes before the start of the event and decided to have breakfast somewhere. By the time we were finished with our Masala Dosas and Musambi Juice it was well past 9:30. I had already missed the event which I had come for, opening address by Mr. Ashish Gupta about the milestones in the journey from an idea to a successful venture. When I reached, a techie from Sun Microsystems was talking about how Sun can help startups. Frankly, it was more of a marketing presentation which I did not find very riveting.

 

I moved around the stalls where some startups were displaying their products and services. It reminded me of BangaloreIT.In of 2006 where Darshan and me had gone though the venue this time was very small as compared to that. You can read about the exhibiting startups here. I then went in to the room where you could meet the VC's. People from different Venture Capital firms from over India were present.

 

I must say that never before has there been a better time to start a company. With 13 Venture Capital firms, each planning to invest around a million dollars per annum into new Ventures in India, you have approximately 10 million dollars of Venture Capital flowing in. That is huge! And it is not just for the technology companies!

 

So what did I get to know in my date with the VC's? I have put them down in points as follows:

• They got the money and they are looking for ventures to invest.
• An Idea is not good enough! They need a Proof of Concept!
• If you worry about the hassles of managing things like marketing, finance etc., don't worry. They have their networks and will help you find people who can help you manage aspects of your company.
• They are looking to invest in areas which have a proven market and growth areas. So in case you have something revolutionary as Google, don't expect it to be easy to get funded.
• People in their network help them to evaluate their ideas. e.g. if I have been funded by a VC and have been successful, she may ask me to evaluate your idea.
• Be as frugal as you can.

One very important thing that I noticed there was that there were quite a lot of people there who had already started off something and were looking for venture capital to expand. I mean like anything else in India, the competition to get a slice of the VC pie is hot here as well. But that doesn't mean you wont get a slice.

 

All said and done, it is always good to be aware of what is happening in the world. I became aware of a whole range of things thanks to event.

So, what do you feel about the points I mentioned above?

Guinness World Records

If you have studied MIT, Manipal around the same time that I did, you would think I was talking about the successful attempt by students of MIT to break the Guinness World Record for the longest chain of straws in the world. Around 1500 or so students of MIT joined hands and made a straw chain of over 8 kilometers if I remember correctly, breaking a record by made by some 16 school kids in the US. The record made has already been broken by someone else quite a while back, though I think it still holds good in the Limca Book of Records.

So how did a thousand students decide to come together to break into the Guinness Book of World Records? Was Manipal such a boring and dull place that the restlessness of the students got the better of them? Well, by no means is Manipal dull. With just students it is one of the most vibrant and energetic places to study in India.

The Guinness World Record attempt was a branding and marketing strategy by my old pal Rishabh Sachdeva, for the inaugural edition of techtatva. He wanted to create a niche brand for the event among other similar events in the region, and if I may say so, it is one of the most successful marketing and branding strategies that you will come across. Not only did it generate a buzz within Manipal, but was also responsible for attracting sponsorship for the inaugural edition of the event. Without this strategy I wonder how would the sponsors have looked at the event which was happening for the first time! The sheer genius of the idea is why I would have Rishabh be the marketing and strategy guy if I were to start a company some day.

Anyway, the idea behind the post was not to discuss about Rishabh or Manipal, but how Guinness World Records provide a great way to market your product. That is what Mozilla Foundation is doing by targeting for the maximum number of downloads in 24 hours for Firefox 3.They are calling this initiative as Download Day, which is on June 17. I have tried the beta version and it was pretty impressive. It is supposed to be fastest browser till date. I have already pledged my support for the initiative. What are you waiting for?

What's Cooking?

Now that the IPL is over, what am I up to these days? Well, last week I was completely involved in understanding the concepts and implementation of a 3 tier architecture using C# in an ASP.NET application. In fact, I had started on this subject about two weeks back and I am quite satisfied with the progress over the last the last two weeks. But more detailed posts on that may not be coming anytime soon as I have some other engagements till July.

 

Meanwhile, another news is that I have invested a heavy chunk of my savings in buying a Lenovo Ideapad Y500.Why the need for a notebook PC? Well first of all, I was kind of bored with my desktop. It has been a very good companion for the past five years and has been party to many memorable times, but was somewhat losing its charm. Secondly, there were issues with the Ethernet Card which really started to get on my nerves. Thirdly, and most importantly, I felt the need for a notebook PC. This was because earlier I was not at a level to use my desktop for writing code or anything like that. In fact, I did not write a blog as frequently and never felt that I needed my stuff with me all the time wherever I am. But lately, I have been having an itch for such an arrangement and decided that it was time to graduate to the next level. Plus Notebooks have a very different feel to them don't they!

 

So I guess now that I have a Notebook, you would expect a lot more blogs and info from me. Well, I don't blame you, especially given the fact that I am writing this blog using Windows Live Writer, a special editor especially for writing blogs easily. And I must confess, that the experience has been good so far. One of the only problems is that the Ideapad shipped with Windows Vista Home. I had heard a lot of people criticize Vista and after using it, I can see why. You will be a bit challenged by the OS and some of its irritating features like User Access Control, which prompts you for your permission every time you start a installation or a program. True that it improves the security vastly, but I was beginning to wonder what was better, being irritated by the security alerts every now and then and being secure or just plain and simple reinstalling Windows whenever you had taken a bad hit from a Virus attack. Or as some of my friends would say, use Mac or Ubuntu.

 

Anyway, I guess I am getting used to it. The UI certainly makes it a nice experience and goes to show how rich applications are going to be the driving force for developers in the next few years.

 

Here's a picture of mine clicked from the webcam. This is just to test how easy is it to post pictures using Live writer. It may look as if I am sleeping but my head is positioned in such a way that it looks like that. When I was in school, I was reading a book kept on my lap rather than on the desk and my head was straight but my eyes were down on the book. The teacher thought that I was sleeping but was surprised when I responded to the question that was asked. I told her that I was merely referring to the book. Later on I have used the same ploy many a times and teachers have never been able to make out if I was sleeping or awake! (At least no one has ever asked me not to sleep in the class or go and wash my face.  My aunt thinks that's because I look like a cute baby when I am asleep(Ahem! Are the girls listening??)and no one would want to wake me up.)BTW, the notebook has a face recognition software which is pretty cool. 

 

I had been to an event organized by The Smart Techie in Bangalore focusing on Startups. My friend Darshan Santani had asked me how was my date and I am yet to respond to him. Will be doing that in the next post soon.

And lots more coming on 3 tier architecture and Object Oriented Design in the weeks to follow. Cheers!!

What have I been upto?

There haven't been many posts in the past few weeks. I had promised that I would post a few things about UI and Web Designing but haven't done that as yet. I will definitely write a post about Web Designing within the next 2 months. But right now that is not what I am doing. I am learning UML.

Why this sudden change of course, like an aircraft on autopilot, whose autopilot program was infected with a virus? Well, there was a training being held on UML and sighting the opportunity I jumped right in. Now, I already had had a training on UML when I joined my company but that was a long time back and I hardly used UML in the past one and a half years. (I guess hardly would be a blatant exaggeration, but anyway!) So I decided to refresh my concepts and enjoy the 2 day break from work. Moreover, having just finished the first version of the application that I was working on at work, I thought it would be a really nice time to learn how can I use UML in action.

The problem with these trainings is that they start at wee hours of the morning (come on, 9:30 am is toooo damn early) and you have to reach on time. To reach on time you also have to get up early because you dont want to get caught in the rush hours (8-10:15 am). So you see how much of an ordeal these trainings are! Still, for both the days I managed to reach on time. The very first day as I entered the training room I was greeted with the familiar sight of our trainer. He was the same guy who had conducted training almost 2 year ago. I wondered if he would remember me.

After the introductions I was pretty sure that he did not remember me as he went on with his lecture. Man I hate lectures! Why can't they be more interactive and give you a problem and then have discussions on how to solve it and explain the theory along with that? Still I was intrigued by the object orientation concepts he was talking about, which was a very good refresher and managed to stay focussed. But when he started off with the History of UML, I could not help myself and however hard I tried I lost my concentration and was feeling drowsy. I guess my sleepy face was enough to ring a bell in the instructor's mind of having faced something similar sometime before and he quickly moved on to UML diagrams. The 2 days on UML was not enough but it was a good refresher and the best part was that we got UML in a Nutshell by O'Reilly as the Reference Material. Also this time the audience in the training was a nice mix of people, from varying backgrounds and experiences so some of the discussions were enlightening.

In the end, the training was over and I was happy to have attended it and gained from it. But as with all trainings, if you do not apply what you have learned then with time you will forget. So I decided to put other things on the back burner for the time being and decided to learn a bit of UML.(The keywords there were BIT OF)

There is an opportunity to put what I have learned into practice so I guess would be a bit tied up. But that is what I have been up to lately.

One of the interesting things to come out of the training was looking at Systems from an Object Oriented point of view. I sort of have been doing that but you will not find any pure classes in my application for real world entities. More on this on the next post where I will talk about using Typed Data Sets vs Custom Business Objects in your application. But the object oriented approach has thrown a few questions to me for which I haven't been able to find any answers till now. All this and more coming up in future posts.

Disappointment and Google Reader

Why would I title my post as "Disappointment and Google Reader"? What were my expectations and why am I disappointed with Google Reader? Wait! I never said I was disappointed with google reader. In fact I am pretty satisifed ever since I started using it. I had wondered before how do RSS feeds work and what is their advantage? I had tried Google Reader a long time back when I was inept at understanding and using technology like geeks. I did not try to understand how does it work and left it. Recently, I got a mail from my old friend Darshan Santani where he had sent an article through Google Reader. This prompted me to try out Google Reader once more and so I logged in hoping I would get the hang of it now since I was a little less technically challenged.(I hope!) I really understood what RSS is and how it has lead to people sharing content over the web. It is just amazing but still very few people who browse the internet use it.

One thing that Feed Reader does is that it brings all the interesting content you would want to read under one roof. You can even share whatever you like with your friends or even with people who visit your site or blog. And so I have put Some Shared Sassy Articles for you on the side. It is nothing but what I share from my reader. You will find some interesting articles on various topics, mostly related to technology. Hope you like this new feature!


Coming back to disappointment, in my previous post I had mentioned about IPL and the fact that I was supporting the Royal Challengers from Bangalore. But being at the bottom of the table is not what I was expecting from them. I have been terribly disappointed and dont see how things are going to change.Dr. Mallya had fired the CEO Charu sharma and brought in Mr. Brajesh Patel as the new one in charge of the affairs expecting some change. But that didn't happen either. I 'don't see where will they go from here! Where will they get the change? Maybe Dr. Mallya should get Mr.Barack Obama to give a speech to the Royal Challengers on "Change We can Believe In!". The way he speaks might just be the pep talk that these guys need.