Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Microsoft SQL Server 2005


1. 

Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

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

Table of Contents • Start Reading

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. 

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. 

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

Professional SQL Server™ 2005 Programming

By: 

Publisher: Wrox

Publication Date: 01-DEC-2006

Insert Date: 10-MAR-2011

Slots: 1.0

Table of Contents • Start Reading

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. 

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. 

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. 

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

Beginning SQL Server™ 2005 Administration

By: 

Publisher: Wrox

Publication Date: 29-NOV-2006

Insert Date: 17-FEB-2011

Slots: 1.0

Table of Contents • Start Reading

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. 

MCTS Self-Paced Training Kit (Exam 70-515): Web Applications Development with Microsoft® .NET Framework 4

MCTS Self-Paced Training Kit (Exam 70-515): Web Applications Development with Microsoft® .NET Framework 4

By: ;

Publisher: Microsoft Press

Publication Date: 16-DEC-2010

Insert Date: 01-DEC-2010

Slots: 1.0

Table of Contents • Start Reading

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

Expert SQL Server™ 2005 Integration Services

By: 

Publisher: Wrox

Publication Date: 29-MAY-2007

Insert Date: 10-MAR-2010

Slots: 1.0

Table of Contents • Start Reading

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

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

Table of Contents • Start Reading

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

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

Table of Contents • Start Reading

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

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

Table of Contents • Start Reading

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)

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

Table of Contents • Start Reading

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

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

Table of Contents • Start Reading

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)

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

Table of Contents • Start Reading

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. 

MCITP SQL Server™ 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, and 70-444)

MCITP SQL Server™ 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, and 70-444)

By: Darril Gibson

Publisher: McGraw-Hill Osborne Media

Publication Date: 25-SEP-2007

Insert Date: 30-JUL-2009

Slots: 1.0

Table of Contents • Start Reading

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

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

Table of Contents • Start Reading

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

Delivering Business Intelligence with Microsoft® SQL Server™ 2005

By: 

Publisher: McGraw-Hill Osborne Media

Publication Date: 23-JAN-2006

Insert Date: 01-MAY-2009

Slots: 1.0

Table of Contents • Start Reading

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. 

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...