What's new in SQL Server 2012.

Unleash the new features of SQL Server 2012.

Saved in:
Bibliographic Details
Main Author: Clements, Rachel
Format: eBook
Language:English
Published: Birmingham : Packt Pub., 2012.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000Mu 4500
001 ocn818118455
003 OCoLC
005 20240809213013.0
006 m o d
007 cr |n|---|||||
008 121101s2012 enk op 000 0 eng d
040 |a MHW  |b eng  |e pn  |c MHW  |d EBLCP  |d OCLCQ  |d MEAUC  |d DEBSZ  |d OCLCQ  |d YDXCP  |d OCLCQ  |d FEM  |d MERUC  |d ZCU  |d ICG  |d OCLCO  |d OCLCF  |d OCLCQ  |d OCLCO  |d DKC  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL  |d OCLCQ 
019 |a 968104655  |a 969037848 
020 |a 9781849687355 
020 |a 1849687358 
035 |a (OCoLC)818118455  |z (OCoLC)968104655  |z (OCoLC)969037848 
037 |a 280485688960649691  |b TotalBoox  |f Ebook only  |n www.totalboox.com 
050 4 |a QA76.9.C55 
049 |a HCDD 
100 1 |a Clements, Rachel. 
245 1 0 |a What's new in SQL Server 2012. 
260 |a Birmingham :  |b Packt Pub.,  |c 2012. 
300 |a 1 online resource (377 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |2 rda 
520 |a Unleash the new features of SQL Server 2012. 
588 0 |a Print version record. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
630 0 0 |a SQL server  |v Programmed instruction. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Client/server computing  |x Design and construction. 
655 7 |a Programmed instructional materials  |2 fast 
776 0 8 |i Print version:  |z 9781849687348 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=1051361  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD