Microsoft SQL Server 2012 Bible / Bible (ePub)
(Sprache: Englisch)
Harness the powerful new SQL Server 2012
Microsoft SQL Server 2012 is the most significant update to this
product since 2005, and it may change how database administrators
and developers perform many aspects of their jobs. If you're a
database...
Microsoft SQL Server 2012 is the most significant update to this
product since 2005, and it may change how database administrators
and developers perform many aspects of their jobs. If you're a
database...
sofort als Download lieferbar
eBook (ePub)
38.99 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenloser tolino webreader
Produktdetails
Produktinformationen zu „Microsoft SQL Server 2012 Bible / Bible (ePub)“
Harness the powerful new SQL Server 2012
Microsoft SQL Server 2012 is the most significant update to this
product since 2005, and it may change how database administrators
and developers perform many aspects of their jobs. If you're a
database administrator or developer, Microsoft SQL Server 2012
Bible teaches you everything you need to take full advantage of
this major release. This detailed guide not only covers all the new
features of SQL Server 2012, it also shows you step by step how to
develop top-notch SQL Server databases and new data connections and
keep your databases performing at peak.
The book is crammed with specific examples, sample code, and a
host of tips, workarounds, and best practices. In addition,
downloadable code is available from the book's companion web site,
which you can use to jumpstart your own projects.
* Serves as an authoritative guide to Microsoft's SQL Server 2012
for database administrators and developers
* Covers all the software's new features and capabilities,
including SQL Azure for cloud computing, enhancements to client
connectivity, and new functionality that ensures high-availability
of mission-critical applications
* Explains major new changes to the SQL Server Business
Intelligence tools, such as Integration, Reporting, and Analysis
Services
* Demonstrates tasks both graphically and in SQL code to enhance
your learning
* Provides source code from the companion web site, which you can
use as a basis for your own projects
* Explores tips, smart workarounds, and best practices to help
you on the job
Get thoroughly up to speed on SQL Server 2012 with Microsoft
SQL Server 2012 Bible.
Microsoft SQL Server 2012 is the most significant update to this
product since 2005, and it may change how database administrators
and developers perform many aspects of their jobs. If you're a
database administrator or developer, Microsoft SQL Server 2012
Bible teaches you everything you need to take full advantage of
this major release. This detailed guide not only covers all the new
features of SQL Server 2012, it also shows you step by step how to
develop top-notch SQL Server databases and new data connections and
keep your databases performing at peak.
The book is crammed with specific examples, sample code, and a
host of tips, workarounds, and best practices. In addition,
downloadable code is available from the book's companion web site,
which you can use to jumpstart your own projects.
* Serves as an authoritative guide to Microsoft's SQL Server 2012
for database administrators and developers
* Covers all the software's new features and capabilities,
including SQL Azure for cloud computing, enhancements to client
connectivity, and new functionality that ensures high-availability
of mission-critical applications
* Explains major new changes to the SQL Server Business
Intelligence tools, such as Integration, Reporting, and Analysis
Services
* Demonstrates tasks both graphically and in SQL code to enhance
your learning
* Provides source code from the companion web site, which you can
use as a basis for your own projects
* Explores tips, smart workarounds, and best practices to help
you on the job
Get thoroughly up to speed on SQL Server 2012 with Microsoft
SQL Server 2012 Bible.
Inhaltsverzeichnis zu „Microsoft SQL Server 2012 Bible / Bible (ePub)“
I Laying the Foundations 1 The World of SQL Server 2 Data Architecture 3 Installing SQL Server 4 Client Connectivity 5 SQL Server Management and Development Tools II Building Databases and Working with Data 6 Introducing Basic Query Flow 7 Relational Database Design and Creating the Physical Database Schema 8 Data Types, Expressions, and Scalar Functions 9 Merging Data with Joins, Subqueries, and CTE's 10 Aggregating, Windowing and Ranking Data 11 Projecting Data Through Views 12 Modifying Data in SQL Server III Advanced T-SQL Data Types and Querying Techniques 13 Working with Hierarchies 14 Using XML Data 15 Executing Distributed Queries IV Programming with T-SQL 16 Programming with T-SQL 17 Developing Stored Procedures 18 Building User-Defined Functions V Enterprise Data Management 19 Configuring SQL Server 20 Policy Based Management 21 Backup and Recovery Planning 22 Maintaining the Database 23 Transferring Databases 24 Database Snapshots 25 Asynchronous Messaging with Service Broker 26 Log Shipping 27 Database Mirroring 28 Replicating Data 29 Clustering 30 Configuring and Managing SQL Server with PowerShell 31 Managing Data in SQL Server Azure VI Securing Your SQL Server 32 Authentication Types in SQL Server 33 Authorizing Securables 34 Data Encryption 35 Row Level Security VII Monitoring and Auditing 36 Creating Triggers 37 Performance Monitor and PAL 38 Using Profiler and SQL Trace 39 Wait States 40 Extended Events 41 Data Change Tracking and Capture 42 SQL Audit 43 Management Data Warehouse VIII Performance Tuning and Optimization 44 Interpreting Query Execution Plans 45 Indexing Strategies 46 Maximizing Query Plan Reuse 47 Managing Transactions, Locking, and Blocking 48 Data Compression 49 Partitioning 50 Resource Governor IX Business Intelligence 51 Business Intelligence Database Design 52 Building, Deploying and Managing ETL Workflows in Integration Services 53 Building MultiDimensional Cubes in Analysis Services with MDX 54 Configuring and Administering
... mehr
Analysis Services 55 Authoring Reports in Reporting Services 56 Configuring and Administering Reporting Services 57 Data Mining with Analysis Services 58 Creating and Deploying BI Semantic Models 59 Creating and Deploying Power View Reports
... weniger
Autoren-Porträt von Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Adam Jorgensen is the President of Pragmatic WorksConsulting, a Director for the Professional Association of SQL
Server (PASS), a SQL Server MVP, and a well-known speaker, author,
and executive mentor. His focus is on helping companies realize
their full potential using their data in ways they have not
previously imagined. Adam is very involved in the community,
delivering more than 75 community sessions per year. Based in
Jacksonville, FL, Adam has written and contributed to five previous
books on SQL Server, analytics, and SharePoint. Coauthors Jorge
Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are
well-known experts on SQL Server and Business Intelligence.
Bibliographische Angaben
- Autoren: Adam Jorgensen , Jorge Segarra , Patrick LeBlanc , Jose Chinchilla , Aaron Nelson
- 2012, 1. Auflage, 1416 Seiten, Englisch
- Verlag: John Wiley & Sons
- ISBN-10: 1118282175
- ISBN-13: 9781118282175
- Erscheinungsdatum: 06.08.2012
Abhängig von Bildschirmgröße und eingestellter Schriftgröße kann die Seitenzahl auf Ihrem Lesegerät variieren.
eBook Informationen
- Dateiformat: ePub
- Größe: 52 MB
- Mit Kopierschutz
Sprache:
Englisch
Kopierschutz
Dieses eBook können Sie uneingeschränkt auf allen Geräten der tolino Familie lesen. Zum Lesen auf sonstigen eReadern und am PC benötigen Sie eine Adobe ID.
Kommentar zu "Microsoft SQL Server 2012 Bible / Bible"
Schreiben Sie einen Kommentar zu "Microsoft SQL Server 2012 Bible / Bible".
Kommentar verfassen