Oracle Database Administration for Microsoft SQL Server DBAs

SQL Server Setup Versus Oracle Setup

With SQL Server, we tend to install an instance with the software, which creates the service and allocates the memory. The system databases are also created, with some of the defaults being set up in the model database for other databases. SQL Server databases can be a different collation and a different version than the server. For example, a server can have the collation of SQL_Latin1_General_CP1_CI_AS, and a new database can be created with a collation of French_CI_AI.

SELECTSERVERPROPERTY(′ProductVersion′) AS ProductVersion, SERVERPROPERTY(′Collation′) AS Collation;ProductVersion       Collation10.0.1600.22            SQL_Latin1_General_CP1_CI_ASCreate database Example1collate French_CI_AI;select name, collation_name, compatibility_level ...