Migrating Oracle Databases to SQL Server 2000

SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE.
In comparison with SQL Server 2000, Oracle 9i Database supports all known platforms, including Windows-based platforms, AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, Sun Solaris and so on.

Sometimes there is the migration issue, so here goes...

There are some nice articles on Oracle to SQL Server migration at

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

SQL Server vs Oracle Feature differences
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm

There is a nice tool for the Migration of stored procs/SQL at
http://www.swissql.com/oracle-to-sql-server.html

Latest Top Ten TPC-C by PerformanceVersion 5 Results
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp

Top Ten TPC-C by Price/PerformanceVersion 5 Results
http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp

Oracle vs SQL Server
http://www.dba-oracle.com/oracle_tips_oracle_v_sql_server.htm

Thanks to the authors of these public sites for the relevant information.

Should 4+1Views based Architecture be a standard for High Level Design documents

The template and details are at:

http://www.cs.ubc.ca/~gregor/teaching/papers/4+1view-architecture.pdf

"To describe a software architecture, we use a model composed of multiple views or perspectives. In order to eventually address large and challenging architectures, the model we propose is made up of five main views

• The logical view, which is the object model of the design (when an object-oriented design method isused),
• the process view, which captures the concurrency, availability, performance and synchronization aspects of the design,
• the physical view, which describes the mapping(s) of the software onto the hardware and reflects its distributed aspect,
• the development view, which describes the static organization of the software in its development environment.
• The description of an architecture—the decisions made—can be organized around these four views, and then illustrated by a few selected use cases, or scenarios which become a fifth view."

Thanks to the Author - Philippe Kruchten - and IEEE for this invaluable experience paper.

Testing SSL on Win Server 2003/IIS6

Hi there,
Been busy with lots of work with .NET Remoting Performance Testing and stuff.
Found something interesting so here goes.

There's a nice easy way to test your IIS6 - SSL performance, install the free SelfSSL Certificate(SelfSSL Version 1.0) from the IIS Resource Kit (http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&displaylang=en) . Its very easy to use (that's what we look for right?) . Check out http://www.visualwin.com/SelfSSL/ for detailed directions on how to get your site into https (for testing only).

The following very useful (performance, analysis and deployment) tools are also available in the IIS6 Resource Kit package :

• IISCertDeploy.vbs Version 1.0
• Log Parser Version 2.1
• Metabase Explorer Version 1.6
• Permissions Verifier Version 1.0
• Web Capacity Analysis Tool Version 5.2
  

Thanks to Microsoft and the authors of the http://www.visualwin.com/ site on which there is lots of other interesting info. on Win 2003 and IIS6.