Free Trial

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

Help

Databases


81. 

Agile Data Warehousing Project Management

Agile Data Warehousing Project Management

By: Ralph Ralph Hughes

Publisher: Morgan Kaufmann

Publication Date: 28-DEC-2012

Insert Date: 22-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

You have to make sense of enormous amounts of data, and while the notion of “agile data warehousing? might sound tricky, it can yield as much as a 3-to-1 speed advantage while cutting project costs in half. Bring this highly effective technique to your organization with the wisdom of agile data warehousing expert Ralph Hughes. Agile Data Warehousing Project Management will give you a thorough introduction to the method as you would practice it in the project room to build a serious “data mart.? Regardless of where you are today, this step-by-step implementation guide will prepare you...

82. 

Business Intelligence, 2nd Edition

Business Intelligence, 2nd Edition

By: David David Loshin

Publisher: Morgan Kaufmann

Publication Date: 27-NOV-2012

Insert Date: 22-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Following the footsteps of the first edition, the second edition of Business Intelligence is a full overview of what comprises business intelligence. It is intended to provide an introduction to the concepts to uncomplicate the learning process when implementing a business intelligence program. Over a relatively long lifetime (7 years), the current edition of book has received numerous accolades from across the industry for its straightforward introduction to both business and technical aspects of business intelligence. As an author, David Loshin has a distinct ability to...

83. 

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

84. 

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

85. 

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

86. 

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

87. 

Decision Support, Analytics, and Business Intelligence, Second Edition

Decision Support, Analytics, and Business Intelligence, Second Edition

By: Daniel Power

Publisher: Business Expert Press

Publication Date: 11-JAN-2013

Insert Date: 15-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

Competition is becoming more intense and decision makers are encountering increasing complexity, rapid change, and higher levels of risk. In many situations, the solution is more and better computerized decision support, especially analytics and business intelligence. Today managers need to learn about and understand computerized decision support. If a business is to succeed, managers must know much more about information technology solutions. This second edition of a powerful introductory book is targeted at busy managers and MBA students who need to grasp the basics of computerized decision...

88. 

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

89. 

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

90. 

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

91. 

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

92. 

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

93. 

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

94. 

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

95. 

Microsoft® Access® 2010 Plain & Simple

Microsoft® Access® 2010 Plain & Simple

By: 

Publisher: Microsoft Press

Publication Date: 03-JUN-2010

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

With this full color, no-nonsense guide, you'll learn the quickest ways to solve a problem or learn a skill with Microsoft Access 2010. Easy-to-follow steps and concise, straightforward language make learning plain and simple!...

96. 

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

97. 

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

98. 

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

99. 

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

100. 

Microsoft® SQL Server™ 2005: Database Essentials Step by Step

Microsoft® SQL Server™ 2005: Database Essentials Step by Step

By: 

Publisher: Microsoft Press

Publication Date: 06-SEP-2006

Insert Date: 14-JAN-2013

Slots: 1.0

Table of Contents • Start Reading

SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers enhanced scalability, availability, and security features to enterprise data and analytical applications while making them easier to create, deploy, and manage. Now you can teach yourself how to design, build, test, deploy, and maintain SQL Server databases—one step at a time. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Instead of merely focusing on describing new features, this book shows new database programmers and administrators how to use...