Kooperativer Bibliotheksverbund

UID:

Format: 1 online resource (238 p.)

Edition: 1st edition

ISBN: 1-283-71497-3 , 1-84968-735-8

Series Statement: Professional expertise distilled.

Content: Unleash the new features of SQL Server 2012

Note: Includes index. , 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 , Color coded and indicator status codes , English

Additional Edition: ISBN 1-84968-734-X

Language: English

Keywords: Electronic books.

URL: Click to View

UID:

Format: X, [2], 211 s. : , il., wykr. ; , 24 cm.

ISBN: 9781906566272

Note: 'Brothers and sisters for a' that' : rediscovering the Polish-Scottish relationship / , Hiding from the dogs : the problem of Polish-Scottish political dialogue / , The reasons for the immigration of Scots to the Polish Commonwealth in the early modern period as outlined in contemporary opinions and historiography / , 'Pardon me my Lord, that I wrytte to your honor in Scottish...' : William Bruce as the first diplomatic agent in the Polish-Lithuanian Commonwealth / , Scots in the Cracow reformed parish in the seventeenth century / , 'Men of noe credit'? Scottish Highlanders in Poland-Lithuania, c. 1500-1800 / , 'The penury of these malignant regions' : comparing the rural economies of the Scottish Highlands and the Polish-Lithuanian Commonwealth in the early modern period / , 'Bonnie fechters' : the Polish army and the defence of Scotland, 1940-1942 / , 'God, honour and fatherland' : the Poles in Scotland, 1940-1950, and the legacy of the Second Republic / , Press reception of Polish migrants in Scotland, 1940-2010 / , Poles in Scotland - before and after 2004 / , The Polish clan - a personal view /

Language: English

UID:

Format: 1 online resource (238 p.)

Edition: 1st edition

ISBN: 1-283-71497-3 , 1-84968-735-8

Series Statement: Professional expertise distilled.

Content: Unleash the new features of SQL Server 2012

Note: Includes index. , 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 , Color coded and indicator status codes , English

Additional Edition: ISBN 1-84968-734-X

Language: English