Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube [Instant]


This title is available as an eBook only
Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube [Instant]
eBook: $14.99
Formats: PDF, PacktLib, ePub and Mobi formats
$12.75
save 15%!
Print & eBook also available on:
Learn in an Instant - Short, Fast, Focused
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
eBook : 72 pages
Release Date : August 2013
ISBN : 1849688729
ISBN 13 : 9781849688727
Author(s) : Anurag Acharya
Topics and Technologies : All Books, Big Data and Business Intelligence, Enterprise, Microsoft

Table of Contents

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
  • Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
    • So, what are SSAS 2012 dimensions and cube?
      • What is SSAS?
      • Why do we need SSAS?
      • SSAS 2012 architecture
        • The tabular model
        • The multidimensional model
      • The future of Analysis Services
      • What's new in SSAS 2012?
        • Ease of use
        • Compatibility with PowerPivot
        • Processing performance characteristics
      • What is SSAS dimension?
      • What is SSAS cube?
    • Installation
      • Step 1 – designing the installation
      • Step 2 – deploying SQL Server 2012
        • What do we need?
        • Deployment of SQL Server 2012
      • Step 3 – confirming the security considerations before a SQL Server deployment
        • Firewalls
        • Enlarging physical security
        • Running individual services
        • Disabling the NetBIOS and SMB
        • Using NTFS for a secure filesystem
      • Step 4 – checking security considerations during or after deployment of SQL Server
    • Quick start – getting started with the peripherals of SSAS 2012
      • SQL Server 2012 supplementary peripherals
        • Analysis Services
        • Reporting Services
      • Administrating and creating a SQL Server instance
        • General
        • Memory
        • Processors
        • Security
        • Connections
        • Database Settings
        • Advanced
        • Permissions
      • Administrating user management and server roles
        • SQL login
      • Developing dimensions in a SQL Server scenario
        • Creating a dimension in a SQL Server development scenario
        • The attribute relationship
      • Developing cubes in a SQL Server scenario
        • Creating a cube in a SQL Server development scenario
        • Cube attribute properties
    • Top 5 features you need to know about
      • Always-on availability group
      • Column index store
      • Big data support
      • Contained databases
      • Power View
    • People and places you should get to know
      • Official sites
      • Articles and tutorials
      • Community

Anurag Acharya

Anurag Acharya is an information security researcher, a consultant, and an expert in networks and server security. He has eight years' practical experience with different vendor technologies, such as Cisco, HP, IBM, Avaya, Red Hat, Microsoft Servers, and network security software such as Panda Firewall. He has a keen interest in working with different technologies. He started his career as a hardware and network engineer, and later he worked as a corporate trainer. He trained hundreds of students, engineers, and government employees in Microsoft Servers (Exchange, Threat Management, Voice, and SQL). As his latest Network profile, he managed some datacenter production servers at a reputed company. He also has experience with Active Directory, DHCP, DNS servers, web servers, application servers, Exchange Servers, SharePoint Servers, database servers, and so on with their administration, monitoring, and security. He has a few international credentials including MCSE, MCSA Security, MCSA Exchange, MCITP Enterprise, MCSA on Core Server, CCNA, CCNA Security, CCNP, CCNP Security, CEH, and ACSE (IT security and ethical hacking). Currently, he is working as a freelance ethical hacking trainer and penetration tester with several institutes. He also provides private training online as well as offline. Soon, he will launch a website, www.mrintruder.com, through which he hopes to help students and professionals to explore their knowledge in different technologies. He is also in the process of writing two books on Microsoft technologies: Windows Server 2012 and Exchange Server 2013. These books help the server administrators to manage, administrate, and upgrade servers on Windows Server 2012 and Exchange Server 2013.
Sorry, we don't have any reviews for this title yet.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sorry, there are currently no downloads available for this title.

Frequently bought together

Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube [Instant] +    Nginx HTTP Server - Second Edition =
50% Off
the second eBook
Price for both: $30.45

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • What’s new In SQL Server 2012
  • Evaluation of SQL Server development environment requirements
  • How to design the SQL Server installation
  • Components of the development environment
  • Installation of essential services with SQL Server 2012
  • Administration of user management and server roles
  • Build and create dimensions and cubes in a development environment

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 SQL Server cube development. You will start by learning how to install SQL Server 2012 and create a development environment. You will then finish by diving into the development and design of dimension and cubes in SQL Server.

This book starts by jumping into the new and important features of Microsoft SQL Server 2012. Afterwards we will run through the installation of SQL Server then how to check the validation of SQL Server and security consideration during and after installation.

After you have SQL Server running, you will get started with SQL Server cube development, first by creating a development environment, then by developing and designing dimensions and cubes in SQL Server.

Moving on to administration and user management of SQL Server 2012 you will then build your own SQL Server development environment and create your own dimensions and cubes. You will then finish with a journey through further tutorials and guidance on continuing and progressing with SSAS cube development.

Approach

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. Written in a practical, friendly manner this book will take you through the journey from installing SQL Server to developing your first cubes.

Who this book is for

"Microsoft SQL Server Analysis Service 2012 Dimensions" and Cube Starter is targeted at anyone who wants to get started with cube development in Microsoft SQL Server Analysis Services. Regardless of whether you are a SQL Server developer who knows nothing about cube development or SSAS or even OLAP, you will be able to pick up this title and quickly start developing cubes.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software