August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 BibleBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Organizing the Interface
Management Studio includes a wide variety of functionality organized into thirteen tools, which you can open from the View menu, from the standard toolbar, or from the associated hotkey:
- Object Explorer (F8): Used for administering and developing SQL Server database objects. The Object Explorer Details page presents a list of objects under the selected node.
- Registered Servers (Ctrl+Alt+G): Used to manage the connections to multiple SQL Server engines ranging from SQL Server 2005 all the way up to SQL Server 2012. You can register database engines, Analysis Services, Report Servers, SQL Server Express, SQL Server Express LocalDB, and Integration Services servers.
- Utility Explorer: Opens the Utility Explorer dashboard. Allows you to create a Utility Control Point (UCP) and enroll instances and monitor health states of those servers at a holistic level.
- Template Explorer (Ctrl+Alt+T): Used to create and manage T-SQL code templates.
- Solution Explorer (Ctrl+Alt+L): Organizes projects and manages source code control.
- Properties window (F4): Displays properties for the selected object.
- Bookmarks window (Ctrl+K, Ctrl+W): Lists current bookmarks from within the Query Editor.
- Web Browser (Ctrl+Alt+R): Used by the Query Editor to display XML or HTML results.
- Output window (Ctrl+Alt+O): Displays messages from Management Studio's integrated development tools.
- Query Editor: The descendant of SQL Server 2000's Query Analyzer, the Query Editor is used to create, edit, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.