Limit search to available items
Book Cover
E-book
Author Clements, Rachel

Title What's new in SQL Server 2012
Published Birmingham : Packt Pub., 2012

Copies

Description 1 online resource (377 pages)
Contents What's New in SQL Server 2012; What's New in SQL Server 2012; Credits; About the Authors; Acknowledgment; Acknowledgment; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Installing SQL Server 2012; SQL Server 2012 Editions; Enterprise Edition; Standard Edition
Business Intelligence EditionLicensing in the Cloud; Developer Edition; Express Edition; Obtaining SQL Server 2012; Evaluation; Retail; Navigating the Installation Process; Summary; 2. SQL Server Administration; Management Studio keyboard shortcuts; New Dynamic Management Views (DMVs); The new OS Volume Stats DMV; Spatial indexes; Columnstore indexes; Creating a columnstore index; Restrictions; Contained databases; Making an existing database partially contained; Migrating your logins to a contained database; Contained database security; Security management; Default schemas for groups
User defined server rolesSQL Server Audit enhancements; Master Data Services (MDS); Summary; 3. Transact SQL; String functions; CONCAT; FORMAT; Datetime functions; EOMONTH; DATEFROMPARTS; TIMEFROMPARTS; DATETIMEFROMPARTS; DATETIMEOFFSETFROMPARTS; Conversion functions; TRY_PARSE; PARSE; IIF; OFFSET and FETCH; SEQUENCE; WITH RESULT SETS; Error handling with THROW; FileTable table type; New T-SQL analytical functions; FIRST_VALUE; LAST_VALUE; LAG; LEAD; SQL Server Data Tools; Database Projects; Support for SQL Server 2005, 2008 and SQL Azure; IntelliSense and debugging
Installing SQL Server Data ToolsInstalling without Visual Studio 2010 pre-installed; Installing with Visual Studio 2010 pre-installed; Creating a new project; Creating database projects; Summary; 4. Analysis Services; Business Intelligence Semantic Model; The three models; Multidimensional and data mining model; Creating a multidimensional model database; Tabular model; Tabular model database; The xVelocity tabular engine mode; Creating a tabular model database; PowerPivot for the SharePoint model; Installing a model; Multidimensional and Tabular models; PowerPivot for SharePoint
Determining a previously installed modelResource usage reporting; Extended Events for Analysis Services; String store constraint; Using scalable string storage; Summary; 5. Reporting Services; Deprecated features; Power View and SharePoint modes; Minority Reporting Services; Data Alerts; Report Builder 2012; Excel Renderer for Excel 2007-2010; Word Renderer for Word 2007-2010; Summary; 6. Integration Services; SSISDB -- the SSIS Catalog database; Introducing the ssis_admin role; Giving users access to integration services; Fixed database-level roles; Upgrading from SQL Server 2005 and 2008
Summary Unleash the new features of SQL Server 2012
Notes Print version record
SUBJECT SQL server -- Programmed instruction
SQL server fast
Subject Client/server computing -- Design and construction
Genre/Form Programmed instructional materials
Form Electronic book
ISBN 9781849687355
1849687358