|
Inside SQL Server 2005 Tools
Ebooks category
SQL Server
, eBook Downloads [2091]
This book reveals the power of the SQL Server 2005 tools to database management system professionals, enabling you to maximize
productivity.
The authors of the book have been working on the SQL Server 2005 team since its inception, they share the philosophy behind the design
of the tools, and they are familiar with insider tips and tricks.
The SQL Server 2005 family of products consists of Database Engine, Analysis Services,
Reporting Services, Integration Services, Notification Services, and SQL Server Mobile Edition (SQL Server Everywhere Edition).
This book describes the
core functionality of all the SQL Server 2005 tools, and closely examines the Database Engine tools.
The book provides solutions for installation,
upgrade, configuration, schema design, management, authoring, development, optimization, deployment, operation, and troubleshooting.
It covers the
Installation Wizard, Upgrade Advisor, SQL Server Configuration Manager, SQL Server Management Studio, Database Tuning Advisor, SQLCMD, Database Mail, SQL Server
Agent, and SQL Server Profiler.
It also touches on technologies that these tools are built upon, such as SQL Server Management Objects (SMO), the
Windows Management Instrumentation (WMI) Provider, and ADO.NET.
The book describes individual features and how they work together to create end
-to-end scenarios.
For the beginning user, we have screenshots and code samples. We provide examples with code snippets where applicable.
When we introduce particular aspects of tool behavior or scenarios, we start first by describing them and relating them to other previously described tasks.
Screen shots show how these things look inside the tools.
For the more experienced users, we provide tips and insight.
In addition, we provide code snippets to illustrate how particularly interesting functionalities can be implemented with underlying APIs.
|

Download
this eBook
File size
34.44 MB
Free eBook Review
|