Purpose of the Surface Area Configuration Tool in SQL Server 2005

Next>>         SQL Server tutorial  

SQL Server - Purpose of the Surface Area Configuration Tool in SQL Server 2005  - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

What is the purpose of the Surface Area Configuration Tool in SQL Server 2005?

Surface Area Configuration tool is used to selectively install and start key services and features to reduce attackable surface of the system. A system Admin can use this tool to enable/disable features after the installation has happened. This tool is a set of dialog boxes which allows a user to enable/disable various stored procedures, windows/web services, remote client connectivity etc.

SQL Server - Purpose of the Surface Area Configuration Tool in SQL Server 2005  - May 05, 2009 at 22:00 PM by Rajmeet Ghai

What is the purpose of the Surface Area Configuration Tool in SQL Server 2005?

The SQL Server 2005 Surface Area Configuration Tool helps in turning ON features that are turned OFF by default. It uses the Window Management Instrumentation (WMI) to view and change server settings. Surface Area Configuration can be called from command line using SAC.EXE. Web Services, SQL mail and native xml can all be configured using SAC tool.

SQL Server - Purpose of the Surface Area Configuration Tool in SQL Server 2005  - June 21, 2009 at 09:00 AM by Amit Satpute

• A surface area is directly proportional to the number of ways software can be attacked.
• Smaller the surface area, fewer are the ways it can be attacked.
• This is controlled by factors like fewer open ports, fewer APIs, fewer protocols, etc.
• OSQL Server 2005 lets manage the software's surface area explicitly.

Next>>

Also read

FOR XML in SQL Server 2005

Discuss the TYPE directive of FOR XML with an example.
Explain the RAW mode of FOR XML with an example.
Explain the AUTO mode of FOR XML with an example.
Explain the EXPLICIT mode of FOR XML with an example..............

CLR support for SQL Server 2005

Overview of integration of CLR with SQL Server, Advantages of CLR integration............

XML Data type implementation in SQL Server 2005

What is Untyped XML?
Provide examples for : Create a table with a untype XML column, Insert into an untyped XML data type column
What is typed XML?
The XML data type comes with five methods. Explain them
Differentiate between Untyped XML and Typed XML.
Explain with an example how to apply defaults constraint to an XML data type column.
You can add constraints to XML data type columns. Illustrate with an example.

Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?

XML Schemas in SQL Server 2005

Syntax and example for creating and dropping XML schema collection.
Limitations of the XML Schema collections.
Discuss about XML schema collection permission.