Microsoft SQL Server 2012 Bible

Name: Microsoft SQL Server 2012 Bible
Author: Adam Jorgensen

The Comprehensive, Tutorial Resource

Paperback Engels 2012 1e druk 9781118106877

Dit product is niet leverbaar

Samenvatting

Something for you on every page

If you're a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more.

- Thoroughly explore all new features in SQL Server 2012
- Understand advanced T-SQL data types and querying techniques
- Ensure high availability for mission-critical applications
- Start using SQL Azure for cloud computing
- Master new security and compliance settings
- Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions
- Get up to speed on the latest enhancements to the BI toolset

Specificaties

ISBN13:9781118106877

Taal:Engels

Bindwijze:paperback

Aantal pagina's:1384

Uitgever:Wiley Computing

Druk:1

Verschijningsdatum:1-9-2012

Hoofdrubriek:IT-management / ICT

Serie:Bible (Hungry Minds)

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Over Jorge Segarra

Jorge Segarra is a database and system administrator for University Community Hospital in Tampa, Florida. He has been administrating SQL Server over 5 years and holds certifications for MCP, and MCTS. Jorge is very active in the online community and can be found on Twitter under the handle SQLChicken and at his blog Sqlchicken.com. He is also a founding member (or hypervisor) for the PASS Virtualization Virtual Chapter and a general volunteer for PASS. On the local level he is a member of the Tampa SQL Server User Group as well as the Tampa Bay SQL Server Business Intelligence User Group. Jorge also enjoys travelling around to various local user groups and events to present on all things SQL Server.

Andere boeken door Jorge Segarra

Bekijk alle boeken

Inhoudsopgave

Introduction

Part 1: 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

Part 2: 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 CTEs
10. Aggregating, Windowing, and Ranking Data
11. Projecting Data Through Views
12. Modifying Data In SQL Server

Part 3: Advanced T-SQL Data Types and Querying Techniques
13. Working with Hierarchies
14. Using XML Data
15. Executing Distributed Queries

Part 4: Programming with T-SQL
16. Programming with T-SQL
17. Developing Stored Procedures
18. Building User-Defined Functions

Part 5: 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 Windows Azure SQL Database

Part 6: Securing Your SQL Server
32. Authentication Types in SQL Server
33. Authorizing Securables
34. Data Encryption
35. Row-Level Security

Part 7: 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

Part 8: 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

Part 9: 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

Index