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. 

SQL Server Analysis Services 2012 Cube Development Cookbook

SQL Server Analysis Services 2012 Cube Development Cookbook

By: Baya Dewald; Paul Turley; Steve Hughes

Publisher: Packt Publishing

Publication Date: 26-DEC-2013

Insert Date: 29-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

More than 100 recipes to develop Business Intelligence solutions using Analysis Services Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions In Detail Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to...

5. 

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

6. 

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

7. 

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

8. 

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

9. 

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

10. 

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube

By: Anurag Acharya;

Publisher: Packt Publishing

Publication Date: 26-AUG-2013

Insert Date: 06-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Learn how to build dimensions and cubes in the SQL Server 2012 development environment Learn something new in an Instant! A short, fast, focused guide delivering immediate results. Create your own SQL Server development environment Full of practical tutorials on cube design and development Learn how to efficiently administrate and manage your SQL Server instance In Detail Microsoft SQL Server Analytical Services, or SSAS, is an analytical processing OLAP tool which allows users to analyze business data quickly and easily. In this book you will get started with...

11. 

Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how...

12. 

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

13. 

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

14. 

SQL Server Backup and Restore

SQL Server Backup and Restore

By: Shawn McGehee

Publisher: Red Gate Books

Publication Date: 14-MAY-2012

Insert Date: 06-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

In this book, you'll discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building your own automated...

15. 

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

16. 

Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

By: ; ;

Publisher: Microsoft Press Deutschland

Publication Date: 21-MAY-2013

Insert Date: 23-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Erlernen Sie das Administrieren von Microsoft SQL Server 2012-Datenbanken und bereiten Sie sich gleichzeitig effizient auf das Examen 70-461 vor. ...

17. 

SQL Server Concurrency: Locking, Blocking and Row Versioning

SQL Server Concurrency: Locking, Blocking and Row Versioning

By: Kalen Delaney

Publisher: Red Gate Books

Publication Date: 11-SEP-2012

Insert Date: 21-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance, in order that in order that all can succeed, without destroying data integrity. Your application can have world-class indexes and queries, but they won't help you if you can't get your data, because another application has it locked. That's why...

18. 

The Art of SQL Server FILESTREAM

The Art of SQL Server FILESTREAM

By: Jacob Sebastian; Sven Aelterman

Publisher: Red Gate Books

Publication Date: 31-AUG-2012

Insert Date: 21-MAY-2013

Slots: 1.0

Table of Contents • Start Reading

Storing large object data in the database offers a number of benefits, but introduces performance challenges. Conversely, storing large object data in the file system has overriding performance advantages, but fails to offer some of the basic data integrity, security and manageability features that are required for business data, and which SQL Server provides. Up to now, most people have adopted file system storage by necessity, and often struggled to overcome the associated shortcomings. This is exactly where SQL Server's new FILESTREAM feature fits in. We hope this book will get you...

19. 

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

20. 

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