Inside SQL Server 2005 Tools
Direct from Microsoft Insiders: the Complete Hands-On Guide toSQL Server 2005’s Powerful Tools!Microsoft SQL Server 2005’s high-powered management tools can dramaticallyimprove DBA productivity and effectiveness. Now there’s a comprehensive guideto SQL Server 2005’s toolset, straight from the Micros...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Buch |
Sprache: | eng |
Online-Zugang: | Volltext |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | Direct from Microsoft Insiders: the Complete
Hands-On Guide toSQL Server 2005’s Powerful Tools!Microsoft SQL Server 2005’s
high-powered management tools can dramaticallyimprove DBA productivity and effectiveness.
Now there’s a comprehensive guideto SQL Server 2005’s toolset, straight
from the Microsoft team that created it.This book covers the entire toolset in
unprecedented depth, guides databaseprofessionals in choosing the right tools,
and shows them how to use varioustools 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 andManagement 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 DatabaseEngine 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 includedCD-ROM’s sample code.MICHAEL RAHEEM is the senior product
manager of the Microsoft SQL Serverteam and led the design and implementation
of several SQL Server tools, suchas SQL Server Management Studio, Database
Mail, Upgrade Advisors, andSurface Area Configuration. He currently
leads the SQL Server enterprisemarketing efforts including high
availability, scalability, and performance.DIMA SONKIN is development lead in
the SQL Server Tools group responsiblefor 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 AnalysisServices team and has spent five years
designing and specifying AnalysisServices tools.KAMI LEMONDS is the documentation
manager for Microsoft’s SQL Server UserEducation te |
---|