| Description |
1 online resource (1 volume) : illustrations. |
|
text file |
| Series |
Professional expertise distilled |
|
Professional expertise distilled.
|
| Contents |
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 |
| Summary |
Unleash the new features of SQL Server 2012. |
| Language |
English. |
| Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Client/server computing.
|
|
Architecture client-serveur (Informatique) |
|
Client/server computing |
| Added Author |
Reade, Jon.
|
| Other Form: |
Print version: Clements, Rachel. What's new in SQL server 2012. Birmingham : Packt Pub. Ltd., 2012 9781849687348 (OCoLC)821112556 |
| ISBN |
9781849687355 (electronic bk.) |
|
1849687358 (electronic bk.) |
|
1283714973 |
|
9781283714976 |
|
More Resources