Our very own Dale Elizabeth Corey has just completed a new ebook on SQL Server 2005's Management Studio and it is available for purchase and download now!
SQL Server 2005 has introduced a new paradigm in many ways, and none will be more obvious than the new tool for managing your servers, SQL Server Management Studio (SSMS). Dale has gone through this comprehensive tool and put together a great introduction to the capabilities and features of this new tool. If you are interested in learning more about this tool and get a great desktop reference, this is the book for you!
This book covers the main functions of SSMS, including:
- Introduction and registering servers
- The Object Explorer
- The Query Editor and Template Explorer
- Solution Explorer
- SQLCMD
- The Database Tuning Advisor
- and more
We've listed the Table of Contents below.
Check out an excerpt from the book: Chapter 1 - The SSMS Environment and Registered Servers
We've produced this book in ebook form for the low introductory cost of US$8 downloaded to your desktop today. We may go to print later if there is a demand (let the webmaster know).
Order Yours Today from SQLServerCentral.com today!!
Table of Contents
About the Author and Dedication | 1 |
Preface | 2 |
Introduction to SQL Server 2005 Management Studio (SSMS) | 3 |
What Did Microsoft SQL Server Customers Want? | 3 |
What Did Microsoft SQL Server Customers Get? | 4 |
What Does the Experienced SQL Server User Want to Know? | 8 |
What are the Packaging and Pricing Options for SQL Server 2005? | 10 |
Chapter 1 The SSMS Environment and Registered Servers | 12 |
1.01 The SSMS Environment | 12 |
Startup options | 12 |
Keyboard shortcuts | 12 |
Floating, docking, tabbing, and hiding windows | 13 |
Auto hide | 13 |
Closing a window | 14 |
Docking | 14 |
Tabbed vs. Multiple-Document Interface | 16 |
Properties | 17 |
Intellisense | 18 |
Web browser | 18 |
Toolbox | 19 |
Help and Dynamic Help | 20 |
1.02 Registered Servers | 21 |
Server groups, registrations, and connections | 21 |
Exporting and importing registered servers | 26 |
Chapter 2 Object Explorer | |
2.01 Object Explorer | 28 |
Object Explorer functionality | 28 |
Viewing the Object Explorer window and task menus | 29 |
Summary Page | 30 |
Databases: Database diagrams | 31 |
Databases: Table Properties for more than one table can now be seen side by side | 34 |
Databases: Building joins has become even easier in Object Explorer when using query by example | 34 |
Databases: Generating scripts | 40 |
Databases: Full text index | 52 |
Databases: Views | 56 |
Databases: Synonyms | 58 |
Databases: Programmability | 59 |
Databases: Service Broker | 60 |
Databases: Storage | 61 |
Databases: Security | 63 |
Security | 63 |
Replication | 64 |
Management: Maintenance Plans | 64 |
Management: SQL Server Logs | 75 |
Management: Activity Monitor | 79 |
Management: Database Mail | 81 |
Management: Distributed Transaction Coordinator and Full Text Search | 87 |
Notification Services | 87 |
SQL Server Agent | 87 |
Chapter 3 Query Editor and Template Explorer | |
3.01 Starting a new query | 93 |
Editing and composing queries | 93 |
Disconnecting and changing connections | 94 |
Query Editor windows | 94 |
Toolbars | 96 |
Editor Features | 98 |
The T-SQL Editor | 100 |
Code Editor Keyboard Shortcuts | 102 |
Indents/tabs | 104 |
Tab groups | 105 |
IntelliSense, hyperlinks in comments, and squiggles | 106 |
External tools | 106 |
Query options | 107 |
Execution plans | 110 |
Catalog Views, Dynamic Management Views, and Compatibility | 111 |
Debugging | 112 |
Source control | 112 |
Running QE in SQLCMD mode | 118 |
3.02 Template Explorer | 118 |
Chapter 4 Solution Explorer | |
4.01 Solution Explorer – Solutions and Projects | 121 |
Projects | 121 |
Solutions | 121 |
Encoding and line ending type | 121 |
T-SQL/DDL scripts example project/solution | 123 |
Chapter 5 Other Management Tools and Features of SQL Server 2005 | |
5.01 Other Management Tools and Features | 131 |
SQLCMD | 131 |
Dedicated Admin Connection | 133 |
SQL Configuration Manager | 134 |
SQL Server Surface Area Configuration Tool | 137 |
Profiler | 141 |
Database Tuning Advisor (DTA) | 148 |
Chapter 6 Conclusion | 155 |
Chapter 7 Bibliography | |
7.01 References | 157 |