Inside SQL Server 2005 Tools
Inside SQL Server 2005 Tools
- ISBN 13:
9780321397966
- ISBN 10:
0321397967
- Edition: CD
- Format: Paperback w/CD
- Copyright: 01/01/2007
- Publisher: Addison-Wesley Professional
Rent
Sorry, this item is currently unavailable.
Free Shipping On Every Order
Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Extend or Purchase Your Rental at Any Time
Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.
Summary
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.
Table of Contents
Read moreForeword | xvii | ||||
Preface | xix | ||||
Acknowledgments | xxvi | ||||
About the Authors | xxvii | ||||
| 1 | (22) | |||
| 1 | (1) | |||
| 2 | (1) | |||
| 3 | (2) | |||
| 3 | (1) | |||
| 3 | (1) | |||
| 4 | (1) | |||
| 4 | (1) | |||
| 4 | (1) | |||
| 5 | (1) | |||
| 5 | (13) | |||
| 5 | (1) | |||
| 6 | (1) | |||
| 7 | (2) | |||
| 9 | (2) | |||
| 11 | (2) | |||
| 13 | (1) | |||
| 13 | (2) | |||
| 15 | (1) | |||
| 16 | (1) | |||
| 16 | (1) | |||
| 17 | (1) | |||
| 18 | (3) | |||
| 21 | (2) | |||
| 23 | (50) | |||
| 25 | (6) | |||
| 26 | (1) | |||
| 27 | (1) | |||
| 27 | (4) | |||
| 31 | (1) | |||
| 31 | (1) | |||
| 31 | (24) | |||
| 32 | (13) | |||
| 45 | (1) | |||
| 45 | (2) | |||
| 47 | (1) | |||
| 48 | (1) | |||
| 49 | (2) | |||
| 51 | (1) | |||
| 51 | (1) | |||
| 52 | (2) | |||
| 54 | (1) | |||
| 54 | (1) | |||
| 55 | (17) | |||
| 55 | (1) | |||
| 56 | (1) | |||
| 57 | (6) | |||
| 63 | (6) | |||
| 69 | (1) | |||
| 69 | (1) | |||
| 70 | (2) | |||
| 72 | (1) | |||
| 73 | (56) | |||
| 74 | (9) | |||
| 74 | (2) | |||
| 76 | (5) | |||
| 81 | (1) | |||
| 81 | (2) | |||
| 83 | (45) | |||
| 83 | (5) | |||
| 88 | (3) | |||
| 91 | (1) | |||
| 92 | (2) | |||
| 94 | (2) | |||
| 96 | (2) | |||
| 98 | (2) | |||
| 100 | (2) | |||
| 102 | (3) | |||
| 105 | (1) | |||
| 106 | (1) | |||
| 106 | (1) | |||
| 107 | (1) | |||
| 108 | (14) | |||
| 122 | (1) | |||
| 123 | (1) | |||
| 124 | (1) | |||
| 125 | (3) | |||
| 128 | (1) | |||
| 129 | (52) | |||
| 130 | (27) | |||
| 132 | (1) | |||
| 133 | (24) | |||
| 157 | (23) | |||
| 158 | (1) | |||
| 159 | (1) | |||
| 160 | (1) | |||
| 161 | (1) | |||
| 161 | (1) | |||
| 162 | (1) | |||
| 163 | (3) | |||
| 166 | (2) | |||
| 168 | (1) | |||
| 169 | (2) | |||
| 171 | (1) | |||
| 172 | (1) | |||
| 173 | (1) | |||
| 174 | (3) | |||
| 177 | (2) | |||
| 179 | (1) | |||
| 180 | (1) | |||
| 181 | (18) | |||
| 181 | (4) | |||
| 184 | (1) | |||
| 185 | (1) | |||
| 185 | (12) | |||
| 187 | (1) | |||
| 188 | (1) | |||
| 189 | (1) | |||
| 190 | (7) | |||
| 197 | (2) | |||
| 199 | (38) | |||
| 199 | (17) | |||
| 200 | (2) | |||
| 202 | (4) | |||
| 206 | (3) | |||
| 209 | (2) | |||
| 211 | (1) | |||
| 211 | (3) | |||
| 214 | (1) | |||
| 215 | (1) | |||
| 216 | (1) | |||
| 217 | (12) | |||
| 218 | (2) | |||
| 220 | (9) | |||
| 229 | (1) | |||
| 230 | (5) | |||
| 230 | (1) | |||
| 231 | (1) | |||
| 231 | (2) | |||
| 233 | (1) | |||
| 234 | (1) | |||
| 235 | (2) | |||
| 237 | (36) | |||
| 237 | (3) | |||
| 240 | (23) | |||
| 243 | (1) | |||
| 244 | (4) | |||
| 248 | (2) | |||
| 250 | (1) | |||
| 250 | (3) | |||
| 253 | (3) | |||
| 256 | (7) | |||
| 263 | (9) | |||
| 265 | (4) | |||
| 269 | (1) | |||
| 270 | (2) | |||
| 272 | (1) | |||
| 273 | (32) | |||
| 273 | (10) | |||
| 273 | (1) | |||
| 274 | (1) | |||
| 275 | (1) | |||
| 276 | (4) | |||
| 280 | (3) | |||
| 283 | (3) | |||
| 283 | (1) | |||
| 283 | (2) | |||
| 285 | (1) | |||
| 286 | (6) | |||
| 286 | (1) | |||
| 286 | (3) | |||
| 289 | (3) | |||
| 292 | (1) | |||
| 292 | (5) | |||
| 297 | (3) | |||
| 300 | (3) | |||
| 303 | (2) | |||
| 305 | (32) | |||
| 305 | (7) | |||
| 305 | (3) | |||
| 308 | (4) | |||
| 312 | (9) | |||
| 313 | (2) | |||
| 315 | (2) | |||
| 317 | (1) | |||
| 318 | (3) | |||
| 321 | (2) | |||
| 323 | (13) | |||
| 326 | (1) | |||
| 327 | (6) | |||
| 333 | (3) | |||
| 336 | (1) | |||
| 337 | (20) | |||
| 337 | (7) | |||
| 337 | (3) | |||
| 340 | (3) | |||
| 343 | (1) | |||
| 344 | (11) | |||
| 344 | (1) | |||
| 344 | (2) | |||
| 346 | (2) | |||
| 348 | (3) | |||
| 351 | (1) | |||
| 351 | (3) | |||
| 354 | (1) | |||
| 355 | (1) | |||
| 356 | (1) | |||
| 357 | (28) | |||
| 358 | (1) | |||
| 359 | (3) | |||
| 360 | (1) | |||
| 361 | (1) | |||
| 361 | (1) | |||
| 362 | (1) | |||
| 363 | (6) | |||
| 364 | (1) | |||
| 365 | (2) | |||
| 367 | (2) | |||
| 369 | (5) | |||
| 370 | (1) | |||
| 371 | (2) | |||
| 373 | (1) | |||
| 374 | (2) | |||
| 376 | (1) | |||
| 377 | (4) | |||
| 378 | (1) | |||
| 379 | (1) | |||
| 380 | (1) | |||
| 381 | (1) | |||
| 382 | (1) | |||
| 383 | (2) | |||
| 385 | (44) | |||
| 385 | (3) | |||
| 386 | (1) | |||
| 386 | (2) | |||
| 388 | (3) | |||
| 391 | (20) | |||
| 394 | (14) | |||
| 408 | (3) | |||
| 411 | (16) | |||
| 414 | (1) | |||
| 415 | (2) | |||
| 417 | (3) | |||
| 420 | (1) | |||
| 421 | (3) | |||
| 424 | (3) | |||
| 427 | (2) | |||
| 429 | (90) | |||
| 430 | (13) | |||
| 430 | (10) | |||
| 440 | (3) | |||
| 443 | (74) | |||
| 446 | (6) | |||
| 452 | (1) | |||
| 453 | (2) | |||
| 455 | (4) | |||
| 459 | (1) | |||
| 459 | (2) | |||
| 461 | (3) | |||
| 464 | (3) | |||
| 467 | (1) | |||
| 467 | (2) | |||
| 469 | (3) | |||
| 472 | (2) | |||
| 474 | (4) | |||
| 478 | (1) | |||
| 478 | (3) | |||
| 481 | (3) | |||
| 484 | (3) | |||
| 487 | (3) | |||
| 490 | (1) | |||
| 491 | (6) | |||
| 497 | (2) | |||
| 499 | (1) | |||
| 500 | (1) | |||
| 500 | (2) | |||
| 502 | (3) | |||
| 505 | (1) | |||
| 505 | (1) | |||
| 506 | (1) | |||
| 507 | (3) | |||
| 510 | (3) | |||
| 513 | (1) | |||
| 513 | (3) | |||
| 516 | (1) | |||
| 517 | (2) | |||
| 519 | (24) | |||
| 520 | (1) | |||
| 521 | (21) | |||
| 522 | (1) | |||
| 523 | (2) | |||
| 525 | (2) | |||
| 527 | (1) | |||
| 528 | (4) | |||
| 532 | (1) | |||
| 532 | (2) | |||
| 534 | (1) | |||
| 535 | (1) | |||
| 536 | (2) | |||
| 538 | (2) | |||
| 540 | (2) | |||
| 542 | (1) | |||
| 543 | (58) | |||
| 543 | (5) | |||
| 544 | (2) | |||
| 546 | (1) | |||
| 547 | (1) | |||
| 547 | (1) | |||
| 548 | (14) | |||
| 548 | (5) | |||
| 553 | (4) | |||
| 557 | (4) | |||
| 561 | (1) | |||
| 562 | (2) | |||
| 562 | (1) | |||
| 563 | (1) | |||
| 563 | (1) | |||
| 564 | (35) | |||
| 564 | (11) | |||
| 575 | (6) | |||
| 581 | (1) | |||
| 582 | (1) | |||
| 583 | (5) | |||
| 588 | (3) | |||
| 591 | (2) | |||
| 593 | (2) | |||
| 595 | (1) | |||
| 596 | (1) | |||
| 597 | (1) | |||
| 598 | (1) | |||
| 599 | (2) | |||
| 601 | (78) | |||
| 602 | (2) | |||
| 604 | (25) | |||
| 604 | (4) | |||
| 608 | (1) | |||
| 608 | (10) | |||
| 618 | (2) | |||
| 620 | (1) | |||
| 621 | (2) | |||
| 623 | (3) | |||
| 626 | (1) | |||
| 627 | (1) | |||
| 627 | (2) | |||
| 629 | (1) | |||
| 629 | (47) | |||
| 630 | (4) | |||
| 634 | (19) | |||
| 653 | (4) | |||
| 657 | (19) | |||
| 676 | (3) | |||
| 679 | (32) | |||
| 680 | (2) | |||
| 680 | (1) | |||
| 680 | (1) | |||
| 681 | (1) | |||
| 682 | (10) | |||
| 682 | (4) | |||
| 686 | (2) | |||
| 688 | (1) | |||
| 689 | (2) | |||
| 691 | (1) | |||
| 692 | (6) | |||
| 692 | (1) | |||
| 693 | (3) | |||
| 696 | (2) | |||
| 698 | (11) | |||
| 698 | (2) | |||
| 700 | (3) | |||
| 703 | (2) | |||
| 705 | (1) | |||
| 706 | (3) | |||
| 709 | (2) | |||
Appendix A Sample KPI Client Code--- Retrieving and Exposing Your First KPI | 711 | (2) | |||
Appendix B KPI Utilities---Code for Parsing Display Folders and Getting Image Indexes | 713 | (8) | |||
Appendix C KPI Viewer | 721 | (2) | |||
Appendix D Complete List of Data Mining Stored Procedures | 723 | (10) | |||
Index | 733 |
Supplemental Materials
Read moreWhat is included with this book?
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Excerpts
Read morePreface Foreword SQL Server has always distinguished itself by, among other things, its management tools. One of the earliest design principles for the team was "It just works." We accomplished this by replacing the usual database knobs and levers with intelligent defaults and adaptive behavior. We never felt that we could or should remove all administrator control. Instead we delivered Enterprise Manager in SQL Server 7.0 and SQL Server 2000. Enterprise Manager grew a huge fan base over the years. So it was with some trepidation that we undertook a massive rewrite, yielding SQL Server Management Studio (SSMS) in SQL Server 2005. The most nerve-wracking experience for software developers is receiving the user initial feedback on a new product or feature. We released an early version of SSMS in SQL Server 2005 Beta 1. You might recall this as Yukon Beta 1. When we received the summary of an early user survey, we were delighted to find SSMS as the most liked new feature in the beta release. At the same time, we were mortified to also find it as the most disliked feature! Getting past our bewilderment, we realized that we were getting incredible feedback from our users. In fact, we found out that we had two distinct user populations. We had taken our management tools in the direction of supporting DBAs as developers in addition to administrators. The feedback told us we were on the right track, but that we had serious work to do. The users that felt like developers--that is, those that wrote and maintained scripts, schemas, stored procedures and other objects--loved the new paradigms in the product. This affirmed our assumptions and research. The users that felt like administrators--that is, they worried about users and user access, backup and restore and other operations--hated the new paradigms. We had assumed that most DBAs were both developers and administrators. With the amazing growth of SQL Server, it is not surprising that DBAs have specialized. Armed with user feedback, we made substantial changes to SQL Server Management Studio. Your authors were in the thick of the action. They shaped the feature set and the user interface you use when you manage your SQL Server. They know the tool set inside and out. I had the privilege of working with them for five years. Irs"m delighted to see them write this book and deliver their insights, their advice, and a behind the scenes perspective. Several chapters stand out. Chapter 4 covers administration, vital to keeping your server running optimally and securely. DBAs receive constant requests to move data for users. SQL Server 2005 features Integration Services, the successor to Data Transformation Services. Chapter 16 covers this new and improved tool. And as the guy who drove Business Intelligence in SQL Server, I of course recommend the coverage of this topic in Chapter 13. BI is growing rapidly in our industry. Even if you are not engaged in BI, this chapter is worth your time. You will be getting requests for Business Intelligence in the future. Enjoy this book, and enjoy SQL Server 2005! Bill Baker General Manager, SQL Server Business Intelligence Redmond, WA June 2006 Preface 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 Databa
Write a Review
Currently unavailable