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
- 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
Introduction to SQL Server 2005 Management Studio (SSMS)
What Did Microsoft SQL Server Customers Want?
What Did Microsoft SQL Server Customers Get?
What Does the Experienced SQL Server User Want to Know?
What are the Packaging and Pricing Options for SQL Server 2005?
Chapter 1 The SSMS Environment and Registered Servers
1.01 The SSMS Environment
Floating, docking, tabbing, and hiding windows
Closing a window
Tabbed vs. Multiple-Document Interface
Help and Dynamic Help
1.02 Registered Servers
Server groups, registrations, and connections
Exporting and importing registered servers
Chapter 2 Object Explorer
2.01 Object Explorer
Object Explorer functionality
Viewing the Object Explorer window and task menus
Databases: Database diagrams
Databases: Table Properties for more than one table can now be seen side by side
Databases: Building joins has become even easier in Object Explorer when using query by example
Databases: Generating scripts
Databases: Full text index
Databases: Service Broker
Management: Maintenance Plans
Management: SQL Server Logs
Management: Activity Monitor
Management: Database Mail
Management: Distributed Transaction Coordinator and Full Text Search
SQL Server Agent
Chapter 3 Query Editor and Template Explorer
3.01 Starting a new query
Editing and composing queries
Disconnecting and changing connections
Query Editor windows
The T-SQL Editor
Code Editor Keyboard Shortcuts
IntelliSense, hyperlinks in comments, and squiggles
Catalog Views, Dynamic Management Views, and Compatibility
Running QE in SQLCMD mode
3.02 Template Explorer
Chapter 4 Solution Explorer
4.01 Solution Explorer – Solutions and Projects
Encoding and line ending type
T-SQL/DDL scripts example project/solution
Chapter 5 Other Management Tools and Features of SQL Server 2005
5.01 Other Management Tools and Features
Dedicated Admin Connection
SQL Configuration Manager
SQL Server Surface Area Configuration Tool
Database Tuning Advisor (DTA)
Chapter 6 Conclusion
Chapter 7 Bibliography