Mind Diary

sp_dbcmptlevel : This command is using to set certain database behaviors to be compatible with the specified version of SQL Servers.

Example:

   —-SQL Server 2005 database compatible level to SQL Server 2000
EXEC sp_dbcmptlevel <DBNAME>, 80;
GO

Version of SQL Server database can be one of the following:

• 60 = SQL Server 6.0
• 65 = SQL Server 6.5
• 70 = SQL Server 7.0
• 80 = SQL Server 2000
• 90 = SQL Server 2005

Please find the full post in Pinal Dave’s Blog

Reference : http://blog.sqlauthority.com/2007/05/29/sql-server-2005-change-database-compatible-level-backward-compatibility/

Popularity: 1% [?]

“Why do you blogging?” this is the question which always had in my mind at the time of starting of my blog. Then I had only one answer. I just want to update my knowledge. And I think for good blogging, specially for Technical blogging we need to go through latest technologies.

Do you know now, after TWO long years of blogging I am very much satisfied with my efforts. It helped me to update my knowledge, got lot of friends through blogging, lot of interaction with the great people through blog comments as well as through mailing, getting good appreciation from the people who don’t even know me. Thanks to Mr.Abrachan, the man who asked me to to start a blog. He only told me about the advantages of blogging at my starting time. Thank you very much Mr.Abrachan. I really remember you…

Now just let me ask the same question to me itself.  Why should I blog? Now I have some well defined answers…

1. It updates my knowledge: I have really realized that writing on a topic helps me think better and deeper in that technology area. I am going through so many feeds, technology links to get more knowledge about that topic . This is very helpful to me as a person who want to know more about the upcoming technologies. It also helps me to work better for my company too.
2. Sharing my knowledge: I am blogs about the works done by me. When I am going through something new in my working life then I am trying to blog that information. Hoping that it will be helpful to others. Because In my life so many blog posts helps me to do my work perfectly and “I just want to be one of them for others”.
3. For future reference: Yea!! really. It helps me to. When I come across any errors or exceptions which stuck me for a long time, I do blogging them. With the exact problem and its solutions. This certainly will help me in the future. And for others too. Simply in one word,  “this is the  better way of archiving my thoughts and knowledge”.
4. To create a Personal Voice: Express yourself!. I can express my thoughts about the latest things here and its an area where I will get the comments from other peoples about it.
5. Connect with Co-Workers/Employees: It helps me to keep in touch with my friends. They can also learn the new technologies which I am going through as well as they can get the solutions of the problems which I had faced in my working time.
6. Brand Recognition and Conversations: Blogging lets me have conversations. Multiple posts on a topic across multiple blogs weaves into a common thread that builds into a conversation.
7. Blogging is a good way to meet people: Another aspect of the conversations is to connect with others, which would simply not be possible otherwise. Blogging is a discovery vehicle that introduces me to new people based on the criteria I want. And very soon you can build relationships out of these, which is what has brought me here on this wonderful blog.

Thank god for every thing that you given to me. Without you I am nothing.

Popularity: 1% [?]

Continuum, Cruise Control and Hudson are some of the famous continuous integration tools which people are using nowadays. Cruise Control is the pioneer one and people are using from a long period of time. Continuum is from the Maven team and very high integration with Maven 1 and 2. Hudson is the new one but it is more popular now.

In our department my PM asked me and to my friend, to do the Cruise Control + SVN +Maven based continuous build mechanism. During this process I had gone through some more R&D on the tools which are available for the continuous build process. In that process I found some of the comments about Hudson. Those were very interesting.. So I thought of comparing this with our Cruise control.

Here in this post I am trying to compare Hudson and Cruise Control. The basic TEN points or features listed below are taken from Hudson’s official site and I am just trying to compare these all with the capabilities of cruise Control. I had tried to add my own experience with these. Correct me if there is any features that were wrongly entered or any new features that you know about these.

Versions and platform:

Hudson            : 1.213

Cruise Control : 2.7.1

Plat form         : Windows

	Hudson		Cruise Control
1	Open Source	1	Open Source
2	Easy installation: Just java -jar Hudson.war, or deploy it in a servlet container. No additional install, no database.	2.	It also gives us very easy installation. Just unzip the downloaded zip file. That’s it. It is actually using an internal Jetty server. No Database, no install here also.
3	Easy configuration: Hudson can be configured entirely from its friendly web GUI with extensive on-the-fly error checks and inline help. There’s no need to tweak XML manually anymore, although if you’d like to do so, you can do that, too.	3.	Big difference comes here. The GUI providing by Cruise control for configuration is not at all good. It just displays the config.xml file. Its no way near to Hudson for Configuration GUI part. If you want to configure Cruise Control then you must study about the structure of the Config.xml first.
4	Change set support: Hudson can generate a list of changes made into the build from CVS/Subversion. This is also done in a fairly efficient fashion, to reduce the load of the repository.	4.	Cruise control also show the list of files which are changes at this check-in process.
5	Permanent links: Hudson gives you clean readable URLs for most of its pages, including some permanent links link “latest build”/”latest successful build”, so that they can be easily linked from elsewhere.	5.	Uhm… Cruise control is not giving this. It gives a link with some log code number attached with it. Its looking horrible and cant be easily likable.
6	RSS/E-mail/IM Integration: Monitor build results by RSS or e-mail to get real-time notifications on failures.	6.	It also gives RSS and email functionality. Don’t know about IM support. If we need to change the Email structure then either we have to change XSL or CSS file which we are using  in the email config.
7	After-the-fact tagging: Builds can be tagged long after builds are completed	7.	N.A.
8	Detect new failing tests while build	8	Failing tests will show in the dashboard. But no separation between new and old.
9	Notify when first test in build fails	9	No such type of notification.
10	JUnit/TestNG test reporting: JUnit test reports can be tabulated, summarized, and displayed with history information, such as when it started breaking, etc. History trend is plotted into a graph.	10	It is showing all the unit test results but not as good as Hudson does. There is no detailed information like when it started breaking, History etc. and no graph for unit results too.
11	Distributed builds: Hudson can distribute build/test loads to multiple computers. This lets you get the most out of those idle workstations sitting beneath developers’ desks.	11.	The build distribution is done through the maven install goal. Its
12	File fingerprinting: Hudson can keep track of which build produced which jars, and which build is using which version of jars, and so on. This works even for jars that are produced outside Hudson, and is ideal for projects to track dependency.	12.	No idea.
13	Plugin Support: Hudson can be extended via 3rd party plug-ins. You can write plug-ins to make Hudson support tools/processes that your team uses.	13.	Plug-ins are there in Cruise control also.
14	Dash board: Hudson has an attractive dashboard with Colorful as well as meaningful icons. We can separate this building projects into subgroups also. It will also shows building projects. Well designed Ajax pages.	14.	It gives an attractive Dash board. It displays all the necessary information which we need to know. We can directly build from there also. Viewing/ downloading the log file is also allowed from this Interface.
15	Local Copy of projects: Handled by Hudson itself. No need to do by the user.	15.	Maintaining a local copy with the exact SVN data makes us more uncomfortable. The user has to copy the Project into the local folder with SVN data.
16	Auto copy of SVN updates: No need to provide any other code to copy the project from SVN to the local compiling folder.	16.	Its not copying the data from the SVN directly. We need to write (In our case we wrote an ANT build file to download the latest copy of Project from SVN) something separate.
17	Running In background: If the server where we deployed the war is running then its okay for Hudson.	17.	If we want to run it without console then we need to make it a separate ‘WINDOWS Service’ using any third party tool.
18	We can deploy the war file in any of the server we wanted.	18.	Jetty server is using internally.
19	User authorization schemes. more configurable.	19.	User authentication is there but no schemes at all.
20	Very Active mailing list.	20.	From a long period people are using this. So it gives so many search results. But its mailing list is not that much active when compared with Hudson.

Alternative building tools available.

I got this list from ThoughtWorks. HERE we will get a good comparison of these all.

• AnthillPro
• Bamboo
• Borland Gauntlet
• CI Feature Matrix
• Continuum
• Hudson
• Parabuild
• Pulse
• QuickBuild
• Rubber Chicken Build
• TeamCity
• Luntbuild

Conclusion:

In my opinion Hudson much more better than Cruise Control. The time we will take to start to use Cruise control will be high when we compared with Hudson. The GUI which makes all the Configurations very very easy. The Ajax support makes the configuration more “Error Free”. Though Cruise control is using by a lot of people, when we looked into the features, mailing list, the fastness and support from Developers I think Hudson will be a good option.

Related links : Continuous Integration with Hudson: A Presentation and an Interview podcast

Popularity: 100% [?]

This is the presentation that Carlo delivered at the Javaday Torino 2007.

[slideshare id=139405&doc=continuous-integration-with-hudson-1192801285234240-2&w=425]

Please Visit Glassfish Podcast blog for an Interview with Kohsuke Kawaguchi about Hudson

Popularity: 1% [?]