SQL Server 2005 has changed the paradigm on how a DBA will work with the product and no change is more different than the client tools.
SQL Server 2005 has gone back to the thick client model, perhaps even the very thick client model, with than the new tool for managing your servers, SQL Server Management Studio (SSMS). This tool contains pretty much every function the DBA will want to perform on their server. It's big, complex, and works in some funny ways.
Dale Elizabeth Corey, a regular contributor at SQLServerCentral.com 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 Invisor
- and more
Check out an excerpt from the book: Chapter 1 - The SSMS Environment and Registered Servers
or read a review by a SQL Server Guru.
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).