Microsoft SQL Server 2012 Bible (eBook)
1416 Seiten
John Wiley & Sons (Verlag)
978-1-118-28217-5 (ISBN)
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.
Adam Jorgensen is the President of Pragmatic Works Consulting, 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.
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 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
Erscheint lt. Verlag | 6.8.2012 |
---|---|
Reihe/Serie | Bible | Bible |
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► SQL Server |
Mathematik / Informatik ► Informatik ► Netzwerke | |
Schlagworte | Computer Science • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • Informatik • SQL Server |
ISBN-10 | 1-118-28217-5 / 1118282175 |
ISBN-13 | 978-1-118-28217-5 / 9781118282175 |
Haben Sie eine Frage zum Produkt? |
![EPUB](/img/icon_epub_big.jpg)
Größe: 53,4 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belletristik und Sachbüchern. Der Fließtext wird dynamisch an die Display- und Schriftgröße angepasst. Auch für mobile Lesegeräte ist EPUB daher gut geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich