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

SQL Server 2010 available In Seven Editions:

SQL Server 2010 available In Seven Editions:

Following are the possible SQL Server 2010 editions available in this release.

• Starter Express Edition – only allows 3 databases.
• Developer Edition – optimized for cursors and triggers, and does not throw any error messages. 
• Standard Edition – I know what you’re thinking: it’s named after The Standard, a hip, humorous and luxurious boutique hotel chain. You’re wrong. 
• Hybrid Edition – has the SQL Server GUI, but a MySQL engine 
• Enterprise Edition – everything you really wanted in Standard. 
• Ultimate Edition – acts as a Media Center repository, so you can save your TV shows and por – I mean, “home movies” on it. Scheduled for early release on BitTorrent. 
• Cloud Edition – like Enterprise Edition, but you pay by the byte stored.

 Naveen Mukkasa

Microsoft® SQL Server® 2012 Evaluation: Download

Microsoft® SQL Server® 2012 Evaluation:

 System requirements:



Supported Operating Systems: Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2

•32-bit systems
◦Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
•64-bit systems
◦1.4 GHz or faster processor
•Minimum of 1 GB of RAM (2 GB or more is recommended.)
•2.2 GB of available hard disk space

Download Link:
http://www.microsoft.com/download/en/details.aspx?id=29066&ocid=aff-n-in-loc--pd


Naveen Mukkasa

Extracting data from OLAP to Excel 12.0 settings

Extracting data from OLAP to Excel 12.0 settings

I had this requirement of extracting data from OLAP cube to Excel 12.0, for which i had published article on SSAS-Info(Analysis Services Resource Website).

Link to the article:


http://www.ssas-info.com/analysis-services-articles/53-excel/942-extracting-data-from-olap-to-excel-120-settings




Naveen Mukkasa

View Login Details on MS SQL database

Some of the useful SQL syntax

Viewing logins and Databases:

SELECT * FROM sys.sql_logins;

SELECT * FROM sys.databases;
SP_helpuser:

Reports information about database-level principals in the current database.

Syntax: sp_helpuser

Naveen Mukkasa - MCTS  

SQL Server 2012 RC0 Download.

Guys am back after a long gap... Will continue blogging stuff which helps the community...

Here is the SQL Server 2012 RC0 download link...

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

Naveen Mukkasa