Free Trial

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

Help

Microsoft SQL Server


1. 

Microsoft® SQL Server® 2012 Reporting Services

Microsoft® SQL Server® 2012 Reporting Services

By: 

Publisher: Microsoft Press

Publication Date: 24-APR-2013

Insert Date: 02-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Deliver interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. SQL Server expert Stacia Misner shows you in detail how to design, manage, and access custom reports that capture data from multiple sources....

2. 

Microsoft® SQL Server® 2012 Step by Step

Microsoft® SQL Server® 2012 Step by Step

By: 

Publisher: Microsoft Press

Publication Date: 25-FEB-2013

Insert Date: 19-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems....

3. 

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools

By: Adam Aspin

Publisher: Apress

Publication Date: 16-NOV-2012

Insert Date: 19-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to...

4. 

Microsoft SQL Server 2012 Bible

Microsoft SQL Server 2012 Bible

By: 

Publisher: John Wiley & Sons

Publication Date: 28-AUG-2012

Insert Date: 19-FEB-2013

Slots: 1.0

Table of Contents • Start Reading

Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases...

5. 

Book-and-video package gets novices up to speed on Microsoft SQL Server 2012 If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project. Guides novice database...

6. 

Microsoft® SQL Server® 2008 Internals

Microsoft® SQL Server® 2008 Internals

By: ; ; ;

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 query execution time...

7. 

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

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

By: ; ; ;

Publisher: Microsoft Press

Publication Date: 18-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, update, merge—for...

8. 

Microsoft SQL Server 2012 - Überblick über Konfiguration, Administration, Programmierung

Microsoft SQL Server 2012 - Überblick über Konfiguration, Administration, Programmierung

By: Markus Raatz; Jörg Knuth; Ruprecht Dröge

Publisher: Microsoft Press Deutschland

Publication Date: 09-JAN-2013

Insert Date: 18-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Microsoft SQL Server 2012 ist ein mächtiges Datenbanksystem, das mit vielen anderen Anwendungen in den Bereichen Business Intelligence, Office, Reporting und Cloud-Computing verwoben werden kann. Damit Sie nicht den Überblick verlieren, haben Markus Raatz...

9. 

Introducing Microsoft® SQL Server® 2012

Introducing Microsoft® SQL Server® 2012

By: ;

Publisher: Microsoft Press

Publication Date: 31-MAR-2012

Insert Date: 15-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers....

10. 

Microsoft SQL Server 2012 - Das Handbuch

Microsoft SQL Server 2012 - Das Handbuch

By: Thomas Joos

Publisher: Microsoft Press Deutschland

Publication Date: 17-AUG-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Dieses Buch ist der umfassende Leitfaden zum Arbeiten mit der cloud-fähigen Informationsplattform und Datenbank-Unternehmenslösung von Microsoft....

11. 

Microsoft SQL Server 2012 - Ratgeber für Administratoren

Microsoft SQL Server 2012 - Ratgeber für Administratoren

By: 

Publisher: Microsoft Press Deutschland

Publication Date: 16-JUL-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Der kompakte Ratgeber für die tägliche Arbeit des Datenbankadministrators in Unternehmen jeder Größe. Es unterstützt Sie effizient bei der Verwaltung von Microsoft SQL Server 2012....

12. 

Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2012

Richtig einsteigen: Datenbanken entwickeln mit SQL Server 2012

By: Robert Panther

Publisher: Microsoft Press Deutschland

Publication Date: 27-JUN-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Diese Buch vermittelt sowohl die Datenbankgrundlagen als auch das Programmierwissen, das Sie benötigen, um professionell mit SQL Server 2012 zu arbeiten....

13. 

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

By: ;

Publisher: Microsoft Press

Publication Date: 24-JUL-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications....

14. 

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions

By: 

Publisher: Microsoft Press

Publication Date: 24-APR-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks....

15. 

Microsoft® SQL Server® 2012 Pocket Consultant

Microsoft® SQL Server® 2012 Pocket Consultant

By: 

Publisher: Microsoft Press

Publication Date: 03-FEB-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

This pocket-sized guide delivers ready answers for administering SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists that help you save time and get the job done!...

16. 

Microsoft® SQL Server® 2012 Integration Services

Microsoft® SQL Server® 2012 Integration Services

By: ; ; ; ;

Publisher: Microsoft Press

Publication Date: 10-SEP-2012

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions. Discover how to: Use SSIS to extract, transform, and load data from multiple data sources Apply best practices to optimize package and project...

17. 

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

18. 

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

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

By: ; ; ; ; ;

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 Transact-SQL (T-SQL)—the database programming language built into SQL Server—with this comprehensive, hands-on programming reference....

19. 

Inside Microsoft® SQL Server™ 2005: T-SQL Querying

Inside Microsoft® SQL Server™ 2005: T-SQL Querying

By: ; ;

Publisher: Microsoft Press

Publication Date: 19-APR-2006

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to...

20. 

Microsoft® SQL Server™ 2005 Reporting Services Step by Step

Microsoft® SQL Server™ 2005 Reporting Services Step by Step

By: ;

Publisher: Microsoft Press

Publication Date: 17-MAY-2004

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft’s customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials—how to architect a report, as well as how to install and program Reporting Services—is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and...