1 / 15

Navigating SQL Server

Learn about SQL Server graphical and non-graphical management tools, from SQL Server Management Studio and Configuration Manager to Surface Area Configuration, all crucial for database administration.

dustinm
Download Presentation

Navigating SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Navigating SQL Server Lesson 3

  2. Skills Matrix

  3. Graphical User Interface (GUI) Management Tools • SQL Server Management Studio • SQL Server Configuration Manager • SQL Server Surface Area Configuration (not available in SQL Server 2008) • SQL Server Books Online

  4. SQL Server Management Studio (SSMS) • SQL Server Management Studio offers an integrated environment for accessing, configuring, managing, administering, and developing all components of the RDBMS. • Management Studio combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.

  5. Query Analyzer

  6. SQL Server Configuration Manager • Used to start and stop Windows services, and to enable and disable network protocols.

  7. Configuring System-Wide Options • Microsoft has set defaults for 70+ server options.

  8. SQL Server Surface Area Configuration Tool for SQL Server 2005 • A management application that lets you start, stop, and disable unused components. • This tool exists in SQL Server 2005 but not in SQL Server 2008. • Surface area reduction helps to improve security by providing fewer avenues for potential attacks on your system.

  9. SQL Server Surface Area Configuration Tool for SQL Server 2005

  10. SQL Server Facets for SQL Server 2008 • In the default configuration of new installations of SQL Server, many features are not enabled. • SQL Server selectively installs and starts only key services and features, to minimize the number of features that can be attacked by a malicious user.

  11. Non-Graphical Support Tools • Catalog views enable you to query metadata about SQL Server database objects. • There are more than 200 catalog views. • SQL Server defines several categories of functions that return information about the database and database objects. • Catalog views enable you to query metadata about SQL Server database objects. • SQL Server defines several categories of system stored procedures that return information about the database and database objects. • SQL Server defines many DBCC routines to help you maintain your database.

  12. Summary • SQL Server comes with all of the management tools needed to implement, configure, and maintain an enterprise database.

More Related