Microsoft SQL Server 2012 Bible (eBook)

Jose Chinchilla, Adam Jorgensen, Patrick LeBlanc, Aaron Nelson, Jorge Segarra (Autoren)

eBook Download: EPUB

2012 | 1. Auflage
1416 Seiten
Wiley (Verlag)
978-1-118-28217-5 (ISBN)

Infos

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.

Autor

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.

Inhalt

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

Produkt-Details

• Erscheint lt. Verlag: 6.8.2012
• Reihe/Serie: Bible
• Reihe/Serie: Bible
• Sprache: englisch
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Themenwelt: 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