RSS
 

Archive for April, 2010

Installing Subversion Source Control on WINDOWS

30 Apr

http://www.devx.com/codemag/Article/38974

http://ale.riolo.co.uk/2007/01/how-to-install-subversion-14x-with.html

http://d3planet.com/rtfb/2009/12/02/windows-server-2008-and-subversion-over-https/

http://www.west-wind.com/presentations/subversion/

 
 

Trac Project…How to Install on WINDOWS

30 Apr

http://trac.edgewall.org/wiki/TracInstall#MandatoryDependencies

http://geekswithblogs.net/twickers/archive/2010/02/02/137766.aspx

 
 

VisualSVN Source Control

30 Apr

this is great video illustrate how you can use VisualSVN as your source control

http://www.visualsvn.com/visualsvn/demo/

http://visualsvn.com/visualsvn/download/

 
 

Visual Studio 2010 Product Registeration

30 Apr

follow this link to register visual studio 2010 http://www.microsoft.com/express/support/regins/

 
 

Assembly Qualified Name…Get It

30 Apr

before we start to know how we can get the qualified name of the assembly, let’s define first assembly ”Assemblies are the building blocks of .NET Framework applications; they form the fundamental unit of deployment, version control, reuse, activation scoping, and security permissions. An assembly is a collection of types and resources that are built to work together and form a logical unit of functionality“ and assembly content

Assembly Content

then let’s define Global Assembly Cache :The global assembly cache stores assemblies specifically designated to be shared by several applications on the computer. Now, we can write code using reflection to can get the Fully Qualified Name of assembly”

public static void Main(){
        Type t = typeof(System.Data.DataSet);
        string s = t.Assembly.FullName.ToString();
        Console.WriteLine("The fully qualified name {0}.", s); }
My Source: http://msdn.microsoft.com/en-us/default.aspx
 
 

TFS 2008 not supported on 64bit operating systems

27 Apr

we can’t install Team Foundation System (TFS) on windows 64bit. 64bit will be supported in TFS 2010 so i Google to search for any workaround  but first list summarize the following:

For more information about 64-bit versions of Windows Server 2003, visit the Microsoft Web site. Team Foundation Server supports running the Team Foundation data-tier and Microsoft SQL Server 2005 on both 32-bit and 64-bit operating systems. Team Foundation Server requires that the application tier run in a native 32-bit environment. The application tier does not support WOW64 or native modes. The following table shows the components that you can install on specific 64-bit operating systems.

First have look on the following website, it contains useful information about installing TFS

http://msdn.microsoft.com/en-us/library/ms253078(VS.90).aspx

http://pointstoshare.spaces.live.com/blog/cns!AEC42F315B4528B0!3280.entry

 
No Comments

Posted in TFS

 

Show() & ShowDialog() @.Net

11 Apr

when you create new form windows you want to show it so you use Show() or ShowDialog(), so what is the difference? ShowDialog is the same as Show, it just shows the form as a modal window. Modal meaning the form cannot lose focus until it is closed. (The user can’t click on other windows within the same application.)

in other meaning, ShowDialog the form is shown in a modal window. A modal form generally is used to show a dialog that must be closed until it takes back to the caller…for instance, the messagebox.show shows the message as a dialog, so the user should close it before the code continues to the next line. In the other hand, the show method just shows the form and continues executing the next line of the caller, when you open a form from a menu you usually shows it as no modal.

 
No Comments

Posted in C#

 

Software Engineer, Computer Science, System Engineering

07 Apr

**Software Engineer: is an engineering discipline that is concerned with all aspects of software production, it is systematic and well-defined techniques, methodologies and tools (to analyze, design, code, test and maintain quality software)

**Computer Science is concerned with theory and fundamentals; software engineering is concerned with the practicalities of developing and delivering useful software

**System Engineering is concerned with all aspects of computer based systems development including hardware, software and process engineering, system engineers are involved in system specification, architectural design, integration and deployment

 
 

JDBC Intro

05 Apr

in this post, i will list two links explain more and more about JDBC and how your java application to datasource like SQL Server:

http://support.microsoft.com/kb/313100

http://www.jdbc-tutorial.com/

 
No Comments

Posted in J2SE

 

Can’t Change Structure of existing table in SQL Server 2008

04 Apr

“saving changes is not permitted. the changes you have made require the following tables to be dropped and recreated. you have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created”,

i got this error when i tried to change identity of table created in SQL server 2008, search and found that this error will be raised every time you will try to change the structure of the table so the solution is to disable certain feature by follow::–>

Click on the Tools drop down menu and selecting Options.  Under the Designers menu option, select the “Table and Database Designers” menu option and uncheck the “Prevent saving changes that require table re-creation” option.  After clicking OK you will be able to save the changes.

the following links describe the solution with screenshoot…..

http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx

and from Microsoft forums i found this post

  1. There are three transactions, one for each table. But it is really all one operation, and it’s not correct to commit before the foreign keys from Child to Parent has been re-added. Thus if the operation fails before the FK is re-added, you will run the database without the FK constraint.
  2. The script does not consider the possibility that an operation may fail with an error that aborts the transaction. If such an error occurs, the script will continue and perform the rest of the steps. I am told that the issue exists only if you run the generated script. If you run Save directly, the client will have control over the transaction and abort.
  3. Constraints that are reapplied are reapplied WITH NOCHECK, that is without verifying that they are valid. This means that SQL Server will mark them as “not trusted” and the optimizer will ignore them. In some situations this can have a serious impact on performance, for instance in partitioned views.
  4. In the scenario above, assume that you first made a change to Child then generated a script. Then you realised that you were changing the wrong table, so you closed Child without saving changes. Then you change Parent as above. If you now save changes, the changes to Child you discarded will now be carried out.
  5. As I think I’ve already mentionrf, the Table Designer only uses ALTER TABLE where SQL 6.5 would permit it. Which means that it would not use ALTER TABLE for a simple change like varchar(10) to varchar(20).

There may be more issues that I have forgotten. It is very clear that the people who wrote and designed this tool, did not understand what it means to make changes to a table. Certainly, it is not a  trivial matter, but changing tables in a production environment requires careful planning. Nevertheless, it’s frightening that MS for so long has included this toy tool in a program for managing enterprise databases.

Again, I strongly recommend that you do not use the Table Designer for implementing table changes, and if
you do, generate a script and review it carefully, and change the script to cater for the defects.

 
 
 

You need to log in to vote

The blog owner requires users to be logged in to be able to vote for this post.

Alternatively, if you do not have an account yet you can create one here.

Powered by Vote It Up