MS SQL SERVER 2012 : FACETS

After installing MS SQL 2012 evalutaion version am exporing the New features, one among them is FACETS which is used to configure MS SQL surface configuration.

This is used to enable and disable the key SQL services.

To configure surface area using facets:

1) Connect to the MS SQL instance.
2)In Object Explorer, right on the server, and then clisk facets.
3) In the view facets screen, expand the Facet list, and select the approriate Surface Area Configuration facet.
4)In the Facet properties area, select the values that you want for each property.

unable to register local servers on SQL Server 2008 Installation.

Today i was installing two MS SQL Server 2008 instances on the Prod server, after installation i was unable find the instance on the local server. Using the Registration of the new server added the two SQL instances even then i was unable to see them on the Local server instead can see them on the Network servers.

Workaround:
Install sevice pack 1 on the exisitng MS SQL Server 2008 instance and reboot the server.

http://www.microsoft.com/en-us/download/details.aspx?id=26727

Here is the Oracle 11G architecture diagram taken from Offical Oracle website.

Naveen Mukkasa