What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 /

Mostrar otras versiones (1)

Unleash the new features of SQL Server 2012.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Clements, Rachel
Otros Autores: Reade, Jon
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Pub., 2012.
Ã2012
Colección:Professional expertise distilled.
Temas:
SQL server.
Client/server computing.
Architecture client-serveur (Informatique)
COMPUTERS > Client-Server Computing.
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • Cover; Copyright; Credits; About the Authors; Acknowledgment; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing SQL Server 2012; SQL Server 2012 Editions; Enterprise Edition; Standard Edition; Business Intelligence Edition; Licensing in the Cloud; Developer Edition; Express Edition; Obtaining SQL Server 2012; Evaluation; Retail; Navigating the Installation Process; Summary; Chapter 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 indexRestrictions; 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 roles; SQL Server Audit enhancements; Master Data Services (MDS); Summary; Chapter 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 THROWFileTable 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 Tools; Installing without Visual Studio 2010 pre-installed; Installing with Visual Studio 2010 pre-installed; Creating a new project; Creating database projects; Summary; Chapter 4: Analysis Services; Business Intelligence Semantic Model; The three models; Multidimensional and data mining model
  • Creating a multidimensional model databaseTabular 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 model; Resource usage reporting; Extended Events for Analysis Services; String store constraint; Using scalable string storage; Summary; Chapter 5: Reporting Services; Deprecated features; Power View and SharePoint modes; Minority Reporting Services; Data Alerts; Report Builder 2012
  • Excel Renderer for Excel 2007-2010Word Renderer for Word 2007-2010; Summary; Chapter 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; New functions; Shared connection managers; Adding a connection manager at the package level; Changing the scope of a connection manager; Enhancements to the Flat File Connection Manager; Undo and redo; Deployment models; Validating a project or package; Querying the SSISDB; Comparing and merging packages

Ejemplares similares