Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
1. | Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook By: Ken England; Gavin JT Powell Publisher: Digital Press Publication Date: 09-APR-2007 Insert Date: 10-AUG-2012 Slots: 1.0 | Overview: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency. Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries,...
|
2. | By: J. Steven Jones; David W. Tschanz Publisher: Sybex Publication Date: 19-SEP-2006 Insert Date: 23-SEP-2011 Slots: 1.0 |
This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443) Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more The CD-ROM features leading-edge exam prep software with test...
|
3. | By: Victor Isakov; Marilyn Miller-White; J. Steven Jones; Andy Warren Publisher: Sybex Publication Date: 10-JUL-2007 Insert Date: 16-SEP-2011 Slots: 1.0 | This ebook does not provide access to the CD-ROM files.Covering Microsoft's brand-new SQL 2005 administrator exam, this study guide walks you through setting up, maintaining, and troubleshooting database solutions. You'll review key topics such as defining high-availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and designing and executing deployments. Plus, the CD-ROM features leading exam prep software with an assessment test, test engine of case study practice questions, and electronic flashcards....
|
4. | Professional SQL Server™ 2005 Programming By: Robert Vieira Publisher: Wrox Publication Date: 01-DEC-2006 Insert Date: 10-MAR-2011 Slots: 1.0 | Overview: Professional SQL Server™ 2005 Programming
Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the 'meat' of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.
...
|
5. | Professional SQL Server™ 2005 Administration Publisher: Wrox Publication Date: 06-DEC-2006 Insert Date: 09-MAR-2011 Slots: 1.0 | Overview: Professional SQL Server™ 2005 Administration
SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.
Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including...
|
6. | Professional SQL Server™ 2005 Integration Services Publisher: Wrox Publication Date: 31-JAN-2006 Insert Date: 05-MAR-2011 Slots: 1.0 | Overview: Professional SQL Server™ 2005 Integration Services
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.
What you will learn from this book
Ways to quickly move and transform data
How to configure every aspect of SSIS
How to interface SSIS with web services and XML
Techniques to scale the SSIS and make it more...
|
7. | Professional SQL Server® 2005 Performance Tuning Publisher: Wrox Publication Date: 29-JAN-2008 Insert Date: 03-MAR-2011 Slots: 1.0 | Overview: Professional SQL Server® 2005 Performance Tuning
Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you'll then learn how to identify and remove the problems that are causing poor performance. You'll discover preventive measures you can take to try to avoid a performance problem entirely and you'll learn how to achieve better performance.
...
|
8. | Beginning SQL Server™ 2005 Administration By: Dan Wood; Chris Leiter; Paul Turley Publisher: Wrox Publication Date: 29-NOV-2006 Insert Date: 17-FEB-2011 Slots: 1.0 | Overview: Beginning SQL Server™ 2005 Administration
For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.
Beginning with a foundation that features detailed coverage of typical administrative duties, the...
|
9. | By: Tony Northrup; Mike Snell Publisher: Microsoft Press Publication Date: 16-DEC-2010 Insert Date: 01-DEC-2010 Slots: 1.0 | This 2-in-1 TRAINING KIT delivers in-depth preparation plus practice for 70-515, the required exam for the MCTS certification: Web Applications Development with Microsoft .NET Framework 4. Ace your exam prep—and build real-world job skills....
|
10. | Expert SQL Server™ 2005 Integration Services By: Brian Knight; Erik Veerman Publisher: Wrox Publication Date: 29-MAY-2007 Insert Date: 10-MAR-2010 Slots: 1.0 | Overview: Expert SQL Server™ 2005 Integration Services
As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.
...
|
11. | Microsoft® SQL Server™ 2005 – Konfigurierung, Administration, Programmierung: 2. Auflage By: Rupprecht Dröge, Markus Raatz Wiegers Publisher: Microsoft Press Deutschland Publication Date: 12-JAN-2006 Insert Date: 08-SEP-2009 Slots: 1.0 | Overview: Microsoft® SQL Server™ 2005 – Konfigurierung, Administration, Programmierung: 2. Auflage
Die zweite, erweiterte Auflage von "SQL Server 2005 - Konfigurierung, Administration, Programmierung" zeigt in vielen praxisnahen Beispielen, wie SQL Server 2005 in Ihrem Unternehmen produktiv eingesetzt werden kann. Dabei werden grundlegende Prinzipien des Datenbankentwurfes, der Datenbankwartung und des Betriebes vorgestellt und Strategien aufgezeigt, wie diese mit den neuen Möglichkeiten des SQL Server 2005 umzusetzen sind. Neben der Vorstellung der wichtigsten Bestandteile, wie den vollständig neu gestalteten DTS (Data Transformation Services), die nun in den Integration Services...
|
12. | Microsoft SQL Server 2005 – Das Entwicklerbuch By: Urban; Köller; Jungbluth Publisher: Microsoft Press Deutschland Publication Date: 14-FEB-2007 Insert Date: 08-SEP-2009 Slots: 1.0 | Overview: Microsoft SQL Server 2005 – Das Entwicklerbuch
SQL Server 2005 ist mehr als nur die neue Version eines erfolgreichen relationalen Datenbankmanagementsystems. Bei diesem Release handelt es sich um eine umfangreiche Programmierplattform und einen Datenmanagement-Server, der in einer modernen IT-Umgebung über die reine Datenspeicherung hinaus Integrations-, Analyse und Kommunikationsaufgaben übernehmen kann. Für den Entwickler von Anwendungen ergeben sich dadurch viele neue Möglichkeiten, aber auch Herausforderungen. Neben der Integration der Common Language Runtime in den Server, die eine Entwicklung von Datenbankobjekten mit...
|
13. | Microsoft SQL Server 2005 – Das Handbuch By: Whalen; Garcia; Patel; Misner; Isakov Publisher: Microsoft Press Deutschland Publication Date: 26-MAR-2007 Insert Date: 28-AUG-2009 Slots: 1.0 | Overview: Microsoft SQL Server 2005 – Das Handbuch
Dieses Buch hilft Ihnen, mit SQL Server 2005 vertraut zu werden und die Aufgaben eines Datenbankadministrators auszuführen. Es gibt in SQL Server 2005 viele neue Gebiete, die Sie kennen lernen müssen, darunter neue und verbesserte Benutzeroberflächen, neue Analysewerkzeuge für die System- und Datenbankleistung, neue Funktionen für die Leistung, neue Business-Intelligence-Tools usw. Es wird einige Zeit und intensives Lernen erfordern, um mit SQL Server 2005 vertraut zu werden, aber die Mühe lohnt sich. Dieses Buch ist ein guter Ausgangspunkt, wenn Ihnen SQL Server noch fremd ist, und eine...
|
14. | MCTS SQL Server® 2005 Implementation and Maintenance Study Guide (Exam 70-431) By: Tom Carpenter Publisher: McGraw-Hill Osborne Media Publication Date: 30-MAY-2007 Insert Date: 08-AUG-2009 Slots: 1.0 | Overview: MCTS SQL Server® 2005 Implementation and Maintenance Study Guide (Exam 70-431) The Best Fully Integrated Study System Available
With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.
• 100% complete coverage of all official objectives for Exam 70-431
• Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off
• Inside the Exam sections in every chapter highlight key exam topics covered
• Simulated exam questions match the format, tone, topics,...
|
15. | Microsoft SQL Server 2005 Taschenratgeber für Administratoren By: William R. Stanek Publisher: Microsoft Press Deutschland Publication Date: 18-FEB-2006 Insert Date: 03-AUG-2009 Slots: 1.0 | Overview: Microsoft SQL Server 2005 Taschenratgeber für Administratoren
Dieses Buch ist eine prägnante und praktische Referenz, auf die Sie beim täglichen Support von Microsoft SQL Server 2005 nicht mehr verzichten wollen. Das ideale Buch für Ihren Arbeitsplatz oder für die Arbeit unterwegs in Unternehmen mit 50 oder 5000 Mitarbeitern bietet praktische schnelle Antworten und konzentriert sich dabei auf die unverzichtbaren Informationen, die Sie tatsächlich benötigen um Ihre Arbeit zu erledigen. Das Buch enthält eine Vielzahl übersichtlicher Tabellen, Listen und Schritt-für-Schritt Anweisungen und erweist sich so als lesefreundlicher und handlicher Ratgeber,...
|
16. | MCITP SQL Server™ 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441, and 70-442) By: Darril Gibson Publisher: McGraw-Hill Osborne Media Publication Date: 18-MAR-2008 Insert Date: 31-JUL-2009 Slots: 1.0 | Overview: MCITP SQL Server™ 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441, and 70-442) All-in-One is All You Need
Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
• Install and configure SQL Server 2005
•...
|
17. | By: Darril Gibson Publisher: McGraw-Hill Osborne Media Publication Date: 25-SEP-2007 Insert Date: 30-JUL-2009 Slots: 1.0 | All-in-One is All You Need
Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
• Install and configure SQL Server 2005
•...
|
18. | Hands-On Microsoft® SQL Server™ 2005 Integration Services By: Ashwani Nanda Publisher: McGraw-Hill Osborne Media Publication Date: 28-AUG-2006 Insert Date: 29-JUL-2009 Slots: 1.0 | Overview: Hands-On Microsoft® SQL Server™ 2005 Integration Services
In-depth coverage of Microsoft's powerfulnew data integration toolLearn to maximize the features of SQL Server 2005 Integration Services from this essentialguide. Hands-On Microsoft SQL Server 2005 IntegrationServices makes learning SSIS easy through theuse of extensive real-world exercises structuredaround every component within the tool. You willlearn to collect corporate data from various sourcesand transform that data for analysis, mining, andreporting.
...
|
19. | Delivering Business Intelligence with Microsoft® SQL Server™ 2005 By: Brian Larson Publisher: McGraw-Hill Osborne Media Publication Date: 23-JAN-2006 Insert Date: 01-MAY-2009 Slots: 1.0 | Overview: Delivering Business Intelligence with Microsoft® SQL Server™ 2005
Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code...
|
20. | By: Joy Mundy; Warren Thornthwaite; Ralph Kimball Publisher: John Wiley & Sons Publication Date: 13-FEB-2006 Insert Date: 21-APR-2009 Slots: 1.0 |
This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business...
|