Chapter 2 - How to use Management Studio Flashcards
What is SQL Server Management Studio and what is it used for?
The primary graphical tool that a developer uses to work with a SQL Server 2012 database. You can use this tool to work directly with database objects and to develop and test SQL statements.
What is SQL Server Configuation Manager and what is it used for?
A graphical tool that you can use to start and stop the database server.
Where can you access documentation for SQL Server 2012?
Books Online which you can access from SQL Server Management Studio. To display books online, select Help-> View Help from Management Studio. See pg 79 in textbook for add’l info.
What is a schema? What is the default schema in SQL Server 2012?
A container that holds objects.
If you don’t specify a schema when you create an object, it’s stored in the default schema, dbo.