Free Trial

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

Help

Microsoft SQL Server


1. 

Expert Cube Development with SSAS Multidimensional Models

Expert Cube Development with SSAS Multidimensional Models

By: Chris Webb; Alberto Ferrari; Marco Russo

Publisher: Packt Publishing

Publication Date: 24-FEB-2014

Insert Date: 26-FEB-2014

Slots: 1.0

Table of Contents • Start Reading

Expert tips and tricks for designing Analysis Services Multidimensional Models Design SQL Server Analysis Services cubes, dimensions, and calculations from the experts! Add calculations to the cube, including implementing currency conversion and a date tool dimension Use security to control access to data in your cube In Detail Microsoft's SQL Server Analysis Services 2012 Multidimensional is an OLAP server that allows end users to analyze large amounts of business data quickly and easily, using a variety of tools including Excel, and to create their own reports without...

2. 

Microsoft SQL Server 2012 Reporting Services - Das Praxisbuch

Microsoft SQL Server 2012 Reporting Services - Das Praxisbuch

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

Publisher: Microsoft Press Deutschland

Publication Date: 20-FEB-2014

Insert Date: 25-FEB-2014

Slots: 1.0

Table of Contents • Start Reading

Dieses Buch zeigt Ihnen leicht verständlich die Reporting Services-Technologien in SQL Server 2012 und bleibt dabei nah an der Praxis....

3. 

Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

By: Ray Rankins; Paul T. Bertucci; Chris Gallelli; Alex T. Silverstein

Publisher: Sams

Publication Date: 03-DEC-2013

Insert Date: 09-JAN-2014

Slots: 1.0

Table of Contents • Start Reading

Buy the print version of Microsoft SQL Server 2012 Unleashed and get the eBook version for free! See inside the book for access code and details. With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012. You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services,...

4. 

Microsoft SQL Server 2012 Internals

Microsoft SQL Server 2012 Internals

By: ; Bob Beauchemin; ; Jonathan Kehayias; Paul S. Randal

Publisher: Microsoft Press

Publication Date: 26-NOV-2013

Insert Date: 22-NOV-2013

Slots: 1.0

Table of Contents • Start Reading

Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator....

5. 

SQL Server 2012 Reporting Services Blueprints

SQL Server 2012 Reporting Services Blueprints

By: Marlon Ribunal; Mickey Stuewe

Publisher: Packt Publishing

Publication Date: 25-OCT-2013

Insert Date: 30-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Use real-world situations to develop real-world solutions Detailed coverage of the various reporting options available Build end-to-end report solutions based on SSRS Learn from realistic situations to offer outstanding solutions In Detail SQL Server 2012 accounts for a huge share of the database market, and more and more companies are implementing SSRS as part of their BI implementation. Its Reporting Services offers a comprehensive, highly scalable solution that enables real-time decision making. SQL Server 2012 Reporting Services Blueprints is intended to be just...

6. 

Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication

By: Sebastian Meine

Publisher: Red Gate Books

Publication Date: 27-AUG-2013

Insert Date: 11-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. All hands-on exercises are designed with security best practices in mind. When you're finished working through the exercises, you will be able to implement your own multi-server replication setup while following the principle of least privilege. ...

7. 

Getting Started with SQL Server 2012 Cube Development

Getting Started with SQL Server 2012 Cube Development

By: Simon Lidberg;

Publisher: Packt Publishing

Publication Date: 13-SEP-2013

Insert Date: 15-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach Learn how to develop a complete business intelligence solution using SQL Server 2012 Understand the difference between tabular in-memory models and OLAP cubes, and which to use where and when Add advanced features such as key performance indicators (KPIs) and calculated measures to your business intelligence model Understand the use of cubes in a modern business intelligence solution Go from a complete beginner to a developer who can build real-world projects through...

8. 

Instant MDX Queries for SQL Server 2012

Instant MDX Queries for SQL Server 2012

By: Nicholas Emond;

Publisher: Packt Publishing

Publication Date: 26-AUG-2013

Insert Date: 07-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Learn how to write MDX queries from SQL Server Analysis Services 2012 cubes quickly and easily Learn something new in an Instant! A short, fast, focused guide delivering immediate results Write queries, use functions, and utilize what you write in cubes and reports Write Calculated Members and Named Sets Use SSAS DMVs to document your cube In Detail MDX is a query language that is used to retrieve data inside Microsoft SQL Server Analysis Services cubes. With MDX, you can display the elements of your cube like attributes and hierarchies from your dimensions, measures...

9. 

Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

By: Debarchan Sarkar;

Publisher: Packt Publishing

Publication Date: 26-AUG-2013

Insert Date: 28-AUG-2013

Slots: 1.0

Table of Contents • Start Reading

Integrate data between Apache Hadoop and SQL Server 2012 and provide business intelligence on the heterogeneous data Integrate data from unstructured (Hadoop) and structured (SQL Server 2012) sources Configure and install connectors for a bi-directional transfer of data Full of illustrations, diagrams, and tips with clear, step-by-step instructions and practical examples In Detail With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file...

10. 

Instant SQL Server Analysis Services 2012 Cube Security

Instant SQL Server Analysis Services 2012 Cube Security

By: Satya SK Jayanty;

Publisher: Packt Publishing

Publication Date: 26-JUL-2013

Insert Date: 31-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Analyze and secure cubes in the SQL Server 2012 development environment in no time using this hands-on guide Learn something new in an Instant! A short, fast, focused guide delivering immediate results Get to know what’s new in BI space Learn about tools & tricks to secure the data layers Implement best practices for Security administration In Detail SQL Server 2012 includes BI-specific features such as cube analytics, reporting-related features, multidimensional BI semantic models, and many more. This is a new addition that is of great use to Business Analysts, who...

11. 

Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

By: Jayaram Krishnaswamy;

Publisher: Packt Publishing

Publication Date: 24-JUN-2013

Insert Date: 26-JUN-2013

Slots: 1.0

Table of Contents • Start Reading

Get the most out of SQL Server Reporting Services 2012, both Native and SharePoint Integrated modes Build applications using the latest Microsoft technologies: SSIS 2012, SSDT, WPF, and SharePoint 2010 Reach out to the cloud and master Windows Azure Reporting Services Learn the ins and outs of SQL Server Reporting Services 2012 for Native and SharePoint Integrated modes Step-by-step learning, guided by a large number of screenshots in every chapter makes it a simple In Detail In the present day information-centric world we live in, the success of an enterprise depends...

12. 

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

13. 

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

14. 

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

15. 

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

16. 

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

17. 

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

18. 

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

19. 

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

20. 

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