| Description |
1 online resource |
| Contents |
Ch. 1. Inside the fundamentals -- Ch. 2. Inside the installation and upgrade tools -- Ch. 3. Inside the configuration tools -- Ch. 4. Inside management and administration tools -- Ch. 5. Inside data authoring tools -- Ch. 6. Inside SQLCMD query tools -- Ch. 7. Inside turning and optimization tools -- Ch. 8. Inside scheduling tools -- Ch. 9. Inside monitoring tools -- Ch. 10. Inside email tools -- Ch. 11. Inside programming object models -- Ch. 12. Inside replication tools -- Ch. 13. Inside analysis services OLAP tools -- Ch. 14. Inside analysis services data mining tools -- Ch. 15. Inside notification services tools -- Ch. 16. Inside integration services tools -- Ch. 17. Inside the reporting services tools -- App. A. Sample KPI client code -- retrieving and exposing your first KPI -- App. B. KPI utilities -- code for parsing display folders and getting image indexes -- App. C. KPI viewer -- App. D. Complete list of data mining stored procedures. |
| Summary |
Direct from Microsoft Insiders: the Complete Hands-On Guide to SQL Server 2005's Powerful Tools! Microsoft SQL Server 2005's high-powered management tools can dramatically improve DBA productivity and effectiveness. Now there's a comprehensive guide to SQL Server 2005's toolset, straight from the Microsoft team that created it. This book covers the entire toolset in unprecedented depth, guides database professionals in choosing the right tools, and shows them how to use various tools collectively to solve real-world problems. The authors present "how-to" solutions and never-before-published tips for SQL Server 2005 installation, upgrades, configuration, authoring, schema design, development, deployment, optimization, troubleshooting, and more. Coverage includes  Understanding how SQL Server 2005 tools differ from their predecessors  Leveraging the new Business Intelligence Development Studio and Management Studio to accomplish dozens of common tasks  Improving security by reducing the "surface area" you expose  Executing queries with the new Query Editor and SQLCMD query tools  Optimizing with the revamped SQL Server Profiler and Database Engine Tuning Advisor  Scheduling maintenance tasks with the SQL Server Agent  Monitoring with the Activity Monitor, SQL Server Agent, and other tools  Moving data efficiently and reliably with Integration Services  Using SQL Server's new e-mail tool, Database Mail  Managing replication in complex distributed environments  Mastering SQL Server's Analysis Services' OLAP and Data Mining tools  Using Notification Services 2.0, Reporting Services, and more  Extending functionality using underlying APIs and the included CD-ROM's sample code. MICHAEL RAHEEM is the senior product manager of the Microsoft SQL Server team and led the design and implementation of several SQL Server tools, such as SQL Server Management Studio, Database Mail, Upgrade Advisors, and Surface Area Configuration. He currently leads the SQL Server enterprise marketing efforts including high availability, scalability, and performance. DIMA SONKIN is development lead in the SQL Server Tools group responsible for SQL Server Agent, SMO, DMO, SQL Profiler, Database Engine Tuning Advisor, Database Mail, SQLMail, SqlCmd, and OSQL. THIERRY D'HERS is the lead program manager on Microsoft's SQL BI Analysis Services team and has spent five years designing and specifying Analysis Services tools. KAMI LEMONDS is the documentation ... |
| Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Database management.
|
|
Client/server computing.
|
|
Bases de données -- Gestion. |
|
Architecture client-serveur (Informatique) |
|
Database management. |
|
Client/server computing. |
|
Client/server computing |
|
Database management |
| Added Author |
Raheem, Michael.
|
| Other Form: |
Print version: Inside SQL server 2005 tools. Upper Saddle River, N.J. : Addison Wesley Professional, 2006 0321397967 9780321397966 (DLC) 2006025109 (OCoLC)70836738 |
| ISBN |
0321397967 |
|
9780321397966 |
|
9780321491411 |
|
0321491416 |
|
More Resources