Instant Microsoft SQL server analysis services 2012 dimensions and cube. ([2013])

• Record Type: Book
• 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 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.
• 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.