What's New in SQL Server 2012 :: Unleash the New Features of SQL Server 2012 /
Unleash the new features of SQL Server 2012.
Gespeichert in:
1. Verfasser: | |
---|---|
Weitere Verfasser: | |
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Birmingham, UK :
Packt Pub.,
2012.
©2012 |
Schriftenreihe: | Professional expertise distilled.
|
Schlagworte: | |
Online-Zugang: | Volltext |
Zusammenfassung: | Unleash the new features of SQL Server 2012. |
Beschreibung: | 1 online resource (1 volume) : illustrations. |
ISBN: | 9781849687355 1849687358 1283714973 9781283714976 |
Internformat
MARC
LEADER | 00000cam a2200000 a 4500 | ||
---|---|---|---|
001 | ZDB-4-EBA-ocn824752421 | ||
003 | OCoLC | ||
005 | 20241004212047.0 | ||
006 | m o d | ||
007 | cr unu|||||||| | ||
008 | 130122s2012 enka o 000 0 eng d | ||
040 | |a UMI |b eng |e pn |c UMI |d E7B |d OCLCO |d COO |d DEBSZ |d OCLCQ |d DKDLA |d D6H |d HKP |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d OCLCA |d NKT |d OCLCQ |d OCLCO |d COCUF |d CNNOR |d MOR |d N$T |d AGLDB |d IGB |d OCLCQ |d U3W |d STF |d VTS |d CEF |d NRAMU |d CRU |d OCLCQ |d NLE |d INT |d UKMGB |d OCLCQ |d G3B |d TKN |d OCLCQ |d UKAHL |d HS0 |d AJS |d OCLCO |d QGK |d OCLCQ |d OCLCO |d OCLCL |d OCLCQ | ||
016 | 7 | |a 018015172 |2 Uk | |
019 | |a 817542362 |a 820854415 |a 1259277436 | ||
020 | |a 9781849687355 |q (electronic bk.) | ||
020 | |a 1849687358 |q (electronic bk.) | ||
020 | |z 9781849687348 | ||
020 | |z 184968734X | ||
020 | |a 1283714973 | ||
020 | |a 9781283714976 | ||
035 | |a (OCoLC)824752421 |z (OCoLC)817542362 |z (OCoLC)820854415 |z (OCoLC)1259277436 | ||
037 | |a CL0500000184 |b Safari Books Online | ||
050 | 4 | |a QA76.9.C55 |b C536 2012 | |
072 | 7 | |a COM |x 061000 |2 bisacsh | |
082 | 7 | |a 005.7585 |2 23 | |
049 | |a MAIN | ||
100 | 1 | |a Clements, Rachel. | |
245 | 1 | 0 | |a What's New in SQL Server 2012 : |b Unleash the New Features of SQL Server 2012 / |c Rachel Clements, Jon Reade. |
260 | |a Birmingham, UK : |b Packt Pub., |c 2012. | ||
264 | 4 | |c ©2012 | |
300 | |a 1 online resource (1 volume) : |b illustrations. | ||
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 | ||
490 | 1 | |a Professional expertise distilled | |
588 | 0 | |a Online resource; title from PDF title page (EBSCO, viewed July 7, 2017). | |
505 | 0 | |a 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 | |
505 | 8 | |a 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 | |
505 | 8 | |a 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 | |
505 | 8 | |a 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 | |
505 | 8 | |a 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 | |
520 | |a Unleash the new features of SQL Server 2012. | ||
546 | |a English. | ||
630 | 0 | 0 | |a SQL server. |0 http://id.loc.gov/authorities/names/n90684343 |
630 | 0 | 7 | |a SQL server. |2 blmlsh |
630 | 0 | 7 | |a SQL server |2 fast |
650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
650 | 6 | |a Architecture client-serveur (Informatique) | |
650 | 7 | |a COMPUTERS |x Client-Server Computing. |2 bisacsh | |
650 | 7 | |a Client/server computing |2 fast | |
700 | 1 | |a Reade, Jon. | |
776 | 0 | 8 | |i Print version: |a Clements, Rachel. |t What's new in SQL server 2012. |d Birmingham : Packt Pub. Ltd., 2012 |z 9781849687348 |w (OCoLC)821112556 |
830 | 0 | |a Professional expertise distilled. | |
856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=497593 |3 Volltext |
938 | |a Askews and Holts Library Services |b ASKH |n AH26944129 | ||
938 | |a ebrary |b EBRY |n ebr10615177 | ||
938 | |a EBSCOhost |b EBSC |n 497593 | ||
994 | |a 92 |b GEBAY | ||
912 | |a ZDB-4-EBA | ||
049 | |a DE-863 |
Datensatz im Suchindex
DE-BY-FWS_katkey | ZDB-4-EBA-ocn824752421 |
---|---|
_version_ | 1816882220041764864 |
adam_text | |
any_adam_object | |
author | Clements, Rachel |
author2 | Reade, Jon |
author2_role | |
author2_variant | j r jr |
author_facet | Clements, Rachel Reade, Jon |
author_role | |
author_sort | Clements, Rachel |
author_variant | r c rc |
building | Verbundindex |
bvnumber | localFWS |
callnumber-first | Q - Science |
callnumber-label | QA76 |
callnumber-raw | QA76.9.C55 C536 2012 |
callnumber-search | QA76.9.C55 C536 2012 |
callnumber-sort | QA 276.9 C55 C536 42012 |
callnumber-subject | QA - Mathematics |
collection | ZDB-4-EBA |
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 |
ctrlnum | (OCoLC)824752421 |
dewey-full | 005.7585 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.7585 |
dewey-search | 005.7585 |
dewey-sort | 15.7585 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05657cam a2200673 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn824752421</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">130122s2012 enka o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCO</subfield><subfield code="d">COO</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DKDLA</subfield><subfield code="d">D6H</subfield><subfield code="d">HKP</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCA</subfield><subfield code="d">NKT</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">COCUF</subfield><subfield code="d">CNNOR</subfield><subfield code="d">MOR</subfield><subfield code="d">N$T</subfield><subfield code="d">AGLDB</subfield><subfield code="d">IGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">U3W</subfield><subfield code="d">STF</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">NRAMU</subfield><subfield code="d">CRU</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">G3B</subfield><subfield code="d">TKN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">AJS</subfield><subfield code="d">OCLCO</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018015172</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">817542362</subfield><subfield code="a">820854415</subfield><subfield code="a">1259277436</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849687355</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849687358</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849687348</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">184968734X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1283714973</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781283714976</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)824752421</subfield><subfield code="z">(OCoLC)817542362</subfield><subfield code="z">(OCoLC)820854415</subfield><subfield code="z">(OCoLC)1259277436</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000184</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.C55</subfield><subfield code="b">C536 2012</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">061000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7585</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Clements, Rachel.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">What's New in SQL Server 2012 :</subfield><subfield code="b">Unleash the New Features of SQL Server 2012 /</subfield><subfield code="c">Rachel Clements, Jon Reade.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2012.</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2012</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 volume) :</subfield><subfield code="b">illustrations.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Professional expertise distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from PDF title page (EBSCO, viewed July 7, 2017).</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Unleash the new features of SQL Server 2012.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">SQL server.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n90684343</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SQL server.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SQL server</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh93000502</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Client-Server Computing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Client/server computing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Reade, Jon.</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Clements, Rachel.</subfield><subfield code="t">What's new in SQL server 2012.</subfield><subfield code="d">Birmingham : Packt Pub. Ltd., 2012</subfield><subfield code="z">9781849687348</subfield><subfield code="w">(OCoLC)821112556</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional expertise distilled.</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=497593</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26944129</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10615177</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">497593</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
id | ZDB-4-EBA-ocn824752421 |
illustrated | Illustrated |
indexdate | 2024-11-27T13:25:09Z |
institution | BVB |
isbn | 9781849687355 1849687358 1283714973 9781283714976 |
language | English |
oclc_num | 824752421 |
open_access_boolean | |
owner | MAIN DE-863 DE-BY-FWS |
owner_facet | MAIN DE-863 DE-BY-FWS |
physical | 1 online resource (1 volume) : illustrations. |
psigel | ZDB-4-EBA |
publishDate | 2012 |
publishDateSearch | 2012 |
publishDateSort | 2012 |
publisher | Packt Pub., |
record_format | marc |
series | Professional expertise distilled. |
series2 | Professional expertise distilled |
spelling | Clements, Rachel. What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / Rachel Clements, Jon Reade. Birmingham, UK : Packt Pub., 2012. ©2012 1 online resource (1 volume) : illustrations. text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Professional expertise distilled Online resource; title from PDF title page (EBSCO, viewed July 7, 2017). 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 Unleash the new features of SQL Server 2012. English. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Architecture client-serveur (Informatique) COMPUTERS Client-Server Computing. bisacsh Client/server computing fast Reade, Jon. Print version: Clements, Rachel. What's new in SQL server 2012. Birmingham : Packt Pub. Ltd., 2012 9781849687348 (OCoLC)821112556 Professional expertise distilled. FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=497593 Volltext |
spellingShingle | Clements, Rachel What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / Professional expertise distilled. 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 SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Architecture client-serveur (Informatique) COMPUTERS Client-Server Computing. bisacsh Client/server computing fast |
subject_GND | http://id.loc.gov/authorities/names/n90684343 http://id.loc.gov/authorities/subjects/sh93000502 |
title | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / |
title_auth | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / |
title_exact_search | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / |
title_full | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / Rachel Clements, Jon Reade. |
title_fullStr | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / Rachel Clements, Jon Reade. |
title_full_unstemmed | What's New in SQL Server 2012 : Unleash the New Features of SQL Server 2012 / Rachel Clements, Jon Reade. |
title_short | What's New in SQL Server 2012 : |
title_sort | what s new in sql server 2012 unleash the new features of sql server 2012 |
title_sub | Unleash the New Features of SQL Server 2012 / |
topic | SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Architecture client-serveur (Informatique) COMPUTERS Client-Server Computing. bisacsh Client/server computing fast |
topic_facet | SQL server. SQL server Client/server computing. Architecture client-serveur (Informatique) COMPUTERS Client-Server Computing. Client/server computing |
url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=497593 |
work_keys_str_mv | AT clementsrachel whatsnewinsqlserver2012unleashthenewfeaturesofsqlserver2012 AT readejon whatsnewinsqlserver2012unleashthenewfeaturesofsqlserver2012 |