Instant Microsoft SQL server analysis services 2012 dimensions and cube. ([2013])
- Record Type:
- Book
- Title:
- Instant Microsoft SQL server analysis services 2012 dimensions and cube. ([2013])
- Main Title:
- Instant Microsoft SQL server analysis services 2012 dimensions and cube
- Further Information:
- Note: Anurag Acharya.
- Other Names:
- Acharya, Anurag
- Contents:
- Cover; Copyright; Credits; About the Author; About the Reviewer; www.packtpub.com; packtlib.packtpub.com; Table of Contents; Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube; So, what is SSAS 2012 dimension 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 2012What 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; Use 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. ProcessorsSecurity; Connections; Database Settings; Advanced; Permissions; Administrating the user management and server roles; SQL logins; Developing dimensions in a SQL Server scenario; Creating a dimension in a SQL Server development scenario; The attribute relationship; Developing cubes in a SQL ServerCover; Copyright; Credits; About the Author; About the Reviewer; www.packtpub.com; packtlib.packtpub.com; Table of Contents; Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube; So, what is SSAS 2012 dimension 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 2012What 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; Use 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. ProcessorsSecurity; Connections; Database Settings; Advanced; Permissions; Administrating the user management and server roles; SQL logins; 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. … (more)
- Publisher Details:
- Birmingham : Packt Publishing
- Publication Date:
- 2013
- Copyright Date:
- 2013
- Extent:
- 1 online resource (72 pages), illustrations
- Subjects:
- 005.7585
COMPUTERS -- Programming -- Microsoft
Database management
SQL (Computer program language)
Client/server computing
Database management
SQL (Computer program language)
Client/server computing
COMPUTERS -- Programming Languages -- SQL
COMPUTERS -- Databases -- General
COMPUTERS -- Databases -- Data Mining
Electronic books - Languages:
- English
- ISBNs:
- 9781849688734
1849688737
1299832539
9781299832534
1849688729
9781849688727 - Related ISBNs:
- 9781849688727
- Notes:
- Note: Online resource; title from PDF title page (ebrary, viewed September 24, 2013).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.90051
- Ingest File:
- 01_056.xml