Free Trial

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

Help

Microsoft SQL Server 2008


1. 

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit

By: Mark Horninger

Publisher: Syngress

Publication Date: 12-APR-2009

Insert Date: 26-APR-2014

Slots: 1.0

Table of Contents • Start Reading

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005. SQL Server 2008 is a much more significant update than SQL Server 2005, because it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization. The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit...

2. 

Microsoft® SQL Server® 2008 Internals

Microsoft® SQL Server® 2008 Internals

By: Kalen Delaney, Paul Randal, Kimberly Tripp, and Conor Cunningham

Publisher: Microsoft Press

Publication Date: 11-MAR-2009

Insert Date: 19-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your...

3. 

Inside Microsoft® SQL Server® 2008: T-SQL Querying

Inside Microsoft® SQL Server® 2008: T-SQL Querying

By: Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, and Steve Kass

Publisher: Microsoft Press

Publication Date: 25-MAR-2009

Insert Date: 19-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification—insert, delete,...

4. 

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

By: 

Publisher: Microsoft Press

Publication Date: 13-APR-2010

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

The fast-answers, daily administration guide to SQL Server® 2008 (updated for R2). This pocket-sized guide from award-winning author William Stanek features concise tables, listings, and step-by-step instructions for fast, accurate answers on the spot....

5. 

Inside Microsoft® SQL Server® 2008: T-SQL Programming

Inside Microsoft® SQL Server® 2008: T-SQL Programming

By: Itzik Ben-Gan, Dejan Sarka, Greg Low, Roger Wolter, Ed Katibah, and Isaac Kunen

Publisher: Microsoft Press

Publication Date: 23-SEP-2009

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. Handle transactions, concurrency, and error handling. Efficiently use temporary objects, including temporary tables, table variables, and table expressions. Evaluate when to use...

6. 

MCTS Self-Paced Training Kit (Exams 70-648 & 70-649): Transitioning Your MCSA/MCSE to Windows Server® 2008

MCTS Self-Paced Training Kit (Exams 70-648 & 70-649): Transitioning Your MCSA/MCSE to Windows Server® 2008

By: ;

Publisher: Microsoft Press

Publication Date: 11-MAR-2009

Insert Date: 20-JUL-2012

Slots: 1.0

Table of Contents • Start Reading

This 2-in-1 TRAINING KIT prepares you for the 70-648 and 70-649 upgrade exams for the new MCTS: Windows Server 2008 Administrator certifications. Ace your exam prep—and build real-world job skills—with lessons, labs, practice tests, and more....

7. 

Microsoft SQL Server 2008 R2 – Das Entwicklerbuch

Microsoft SQL Server 2008 R2 - Das Entwicklerbuch

By: Georg Urban; Jörg Neumann; ; Alexander Köller

Publisher: Microsoft Press Deutschland

Publication Date: 24-NOV-2010

Insert Date: 02-MAR-2012

Slots: 1.0

Table of Contents • Start Reading

Das umfassende Arbeitsbuch zu SQL Server 2008 R2: Wenn Sie professionell mit dem SQL Server zu tun haben, dann ist dies Ihr Buch! SQL Server 2008 R2 ist nicht einfach nur ein relationales DBMS, sondern eine komplexe Entwicklungsumgebung mit vielfältigen Angeboten und Herausforderungen für Entwickler. Die Spannbreite reicht von »klassischer« T-SQL-Programmierung über .NET-Programmierung in C# bis hin zur Geodatenverarbeitung und Complex Event Processing. Anhand eines durchgängigen Beispielszenarios werden diese Konzepte nicht nur theoretisch, sondern mit viel Praxisbezug vorgestellt: Über...

8. 

Microsoft SQL Server 2008 R2 Reporting Services – Das Praxisbuch

Microsoft SQL Server 2008 R2 Reporting Services - Das Praxisbuch

By: Sven Bayer; Jörg Knuth; Martin B. Schultz

Publisher: Microsoft Press Deutschland

Publication Date: 14-SEP-2011

Insert Date: 01-MAR-2012

Slots: 1.0

Table of Contents • Start Reading

Microsoft SQL Server Reporting Services sind als Bestandteil von SQL Server 2008 R2 ohne weitere Lizenzkosten nutzbar. Als Bestandteil des Microsoft Business Intelligence-Frameworks stellen sie eine serverbasierte Lösung zum Entwickeln, Verwalten und Verteilen von Berichten zur Verfügung. Ziel dieses Buchs ist es, Ihnen diese Technologien verständlich zu machen und dabei nah an der Praxis zu bleiben. Das heißt konkret: Die Autoren erläutern Ihnen anhand von Szenarien die Praxisrelevanz der jeweiligen Features und vertiefen wichtige Themen mit Schritt-für-Schritt-Anleitungen. Das Buch ist so...

9. 

Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2008 (R2) Express

Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2008 (R2) Express

By: Robert Panther

Publisher: Microsoft Press Deutschland

Publication Date: 01-JUN-2012

Insert Date: 27-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

SQL Server 2008 R2 Express als kostenloser und leistungsfähiger Datenbankserver ist ideal, um in die professionelle Datenbankentwicklung einzusteigen. Mit dieser Version von SQL Server ist es möglich, auch komplexe Datenbankprojekte zu verwirklichen, die die Funktionalität einer Desktop-Datenbank wie Microsoft Access übersteigen. Wenn Sie in die Datenbankentwicklung mit einem professionellen Datenbankserver einsteigen wollen, ist dieses Buch genau das Richtige für Sie. Es vermittelt sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um die umfangreichen...

10. 

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

By: Guy Fouché; Lynn Langit

Publisher: Apress

Publication Date: 01-APR-2011

Insert Date: 16-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

Foundations of SQL Server 2008 R2 Business Intelligence introduces the exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at the core, and surrounding the database are tools for data mining, modeling, reporting, analyzing, charting, and integration with other, enterprise-level software packages. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what...

11. 

Microsoft® SQL Server® 2008 R2 Master Data Services: Implementation & Administration

Microsoft® SQL Server® 2008 R2 Master Data Services: Implementation & Administration

By: Tyler Graham; Suzanne Selhorn

Publisher: McGraw-Hill

Publication Date: 24-FEB-2011

Insert Date: 09-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

Best Practices for Deploying and Managing Master Data Services (MDS)Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material...

12. 

SQL Server 2008 R2 - Der schnelle Einstieg, 4th Edition

SQL Server 2008 R2 - Der schnelle Einstieg, 4th Edition

By: Klemens Konopasek

Publisher: Addison-Wesley Verlag

Publication Date: 01-APR-2012

Insert Date: 02-FEB-2012

Slots: 1.0

Table of Contents • Start Reading

Dieses Buch bietet Ihnen einen leichten und schnellen Einstieg in Einsatz, Verwaltung und Entwicklung einer Datenbank mit dem SQL Server 2008 und SQL Server 2008 R2 . Sie erhalten eine Einführung in die neuen Features beider Versionen, in Installation und Konfiguration des SQL Servers und lernen die grafischen Oberflächen, allen voran das SQL Server Management Studio , kennen. Ein Schwerpunkt liegt auf der Lösungsentwicklung mit Transact-SQL, wobei auch die Common Language Runtime-Integration mit .NET berücksichtigt wird. An DBAs richten sich die Kapitel zur Benutzerverwaltung und ...

13. 

MCTS 70-642 Cert Guide: Windows Server® 2008 Network Infrastructure, Configuring

MCTS 70-642 Cert Guide: Windows Server® 2008 Network Infrastructure, Configuring

By: Don Poulton

Publisher: Pearson Certification

Publication Date: 17-FEB-2012

Insert Date: 09-DEC-2011

Slots: 1.0

Table of Contents • Start Reading

Learn, prepare, and practice for Microsoft MCTS 70-642 exam success with this MCTS 70-642: Windows Server 2008 Network Infrastructure, Configuring Cert Guide from Pearson IT Certification, a leader in IT Certification learning. The companion CD features two complete practice exams. Master Microsoft’s MCTS 70-642 exam topics Assess your knowledge with chapter-ending quizzes Review key concepts with exam preparation tasks Practice with realistic exam questions on the CD MCTS 70-642: Windows Server 2008 Network Infrastructure, Configuring Cert Guide is a best-of-breed...

14. 

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty;

Publisher: Packt Publishing

Publication Date: 24-MAY-2011

Insert Date: 30-SEP-2011

Slots: 1.0

Table of Contents • Start Reading

Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook Covers the essential Manageability, Programmability, and Security features Emphasizes important High Availability features and implementation Explains how to maintain and manage the SQL Server data platform effectively In Detail Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large....

15. 

SQL Server® 2008 Administration

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

By: 

Publisher: Sybex

Publication Date: 17-MAY-2010

Insert Date: 23-SEP-2011

Slots: 1.0

Table of Contents • Start Reading

The ideal on-the-job reference guide for SQL Server 2008 database administratorsIf you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.And, if you're preparing for MCTS or MCITP certification in SQL Server 2008...

16. 

Mastering SQL Server® 2008

Mastering SQL Server® 2008

By: 

Publisher: Sybex

Publication Date: 20-JAN-2009

Insert Date: 16-SEP-2011

Slots: 1.0

Table of Contents • Start Reading

As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection....

17. 

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook

By: Tomislav Piasevoli;

Publisher: Packt Publishing

Publication Date: 09-AUG-2011

Insert Date: 16-AUG-2011

Slots: 1.0

Table of Contents • Start Reading

More than 80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries in this book and eBook Enrich your BI solutions by implementing best practice MDX calculations Master a wide range of time-related, context-aware, and business-related calculations Enhance your solutions by combining MDX with utility dimensions Become skilled in making reports concise Learn how to optimize, dissect, and debug your MDX calculations Maximize your learning with detailed explanations following each solution Packed with...

18. 

Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

By: Jeremy Kashel; Tim Kent; Martyn Bullerwell

Publisher: Packt Publishing

Publication Date: 19-JUL-2011

Insert Date: 25-JUL-2011

Slots: 1.0

Table of Contents • Start Reading

Manage and maintain your organization's master data effectively with Microsoft SQL Server 2008 R2 Master Data Services Gain a comprehensive guide to Microsoft SQL Server R2 Master Data Services (MDS) with this book and eBook Explains the background to the practice of Master Data Management and how it can help organizations Introduces Master Data Services, and provides a step-by-step installation guide Covers all features of Master Data Services, including hierarchy management, importing/exporting data, the MDS API, and business rules Includes practical examples that guide the...

19. 

Beginning Microsoft® SQL Server® 2008 Programming

Beginning Microsoft® SQL Server® 2008 Programming

By: 

Publisher: Wrox

Publication Date: 09-JAN-2009

Insert Date: 04-JUL-2011

Slots: 1.0

Table of Contents • Start Reading

This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more Features updated and new material, including new examples using Microsoft's AdventureWorks sample...

20. 

Practical DMX Queries for Microsoft® SQL Server® Analysis Services 2008

Practical DMX Queries for Microsoft® SQL Server® Analysis Services 2008

By: Art Tennick

Publisher: McGraw-Hill

Publication Date: 17-SEP-2010

Insert Date: 25-JUN-2011

Slots: 1.0

Table of Contents • Start Reading

250+ Ready-to-Use, Powerful DMX Queries Transform data mining model information into actionable business intelligence using the Data Mining Extensions (DMX) language. Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 contains more than 250 downloadable DMX queries you can use to extract and visualize data. The application, syntax, and results of each query are described in detail. The book emphasizes DMX for use in SSMS against SSAS, but the queries also apply to SSRS, SSIS, DMX in SQL, WinForms, WebForms, and many other applications. Techniques for generating DMX syntax...