Microsoft SQL Server 2014 Unleashed ( Paperback)
暫譯: Microsoft SQL Server 2014 完全解析 (平裝本)

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein

Microsoft SQL Server 2014 Unleashed ( Paperback)
  • 出版商: SAMS
  • 出版日期: 2015-06-22
  • 定價: $2,100
  • 售價: 9.5 折 $1,995
  • 語言: 英文
  • 頁數: 2000
  • 裝訂: Paperback
  • ISBN: 0672337290
  • ISBN-13: 9780672337291
  • 相關分類: MSSQL、SQL

    • 立即出貨(限量) (庫存=2)

買這商品的人也買了...

相關主題

商品描述

The industry’s most complete, useful, and up-to-date guide to SQL Server 2014.


You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the
most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions.


Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server.


Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features.


Detailed information on how to…

  • Understand SQL Server 2014’s new features and each edition’s capabilities and licensing
  • Install, upgrade to, and configure SQL Server 2014 for better performance and easier management
  • Streamline and automate key administration tasks with Smart Admin
  • Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups
  • Strengthen security with new features for enforcing “least privilege”
  • Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements
  • Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures
  • Control workloads and Disk I/O with the Resource Governor
  • Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery
  • Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse

商品描述(中文翻譯)

業界最完整、最實用且最新的 SQL Server 2014 指南。



您將找到 SQL Server 核心資料庫伺服器和管理功能的全面覆蓋：所有您需要的實務資訊、提示、指導方針和範例，以安裝、監控、維護和優化最複雜的資料庫環境。提供的範例和範本程式碼提供了豐富的實作機會，讓您更深入了解 SQL Server 並創建自己的可行解決方案。



四位領先的 SQL Server 專家提供了管理 SQL Server、分析和優化查詢、實施資料倉儲、確保高可用性、調整性能等方面的深入實務見解。您將受益於他們對 SQL Server 的幕後觀察，展示各種精靈和基於 GUI 的工具背後的運作。您將學會如何使用底層的 SQL 命令，充分發揮 SQL Server 的力量和功能。



本書針對所有中級至高級的 SQL Server 專業人士而寫，作者基於豐富的 SQL Server 生產經驗進行撰寫。全書專注於成功應用 SQL Server 2014 最強大的功能及其最新的工具和特性。



有關如何……的詳細資訊



  • 了解 SQL Server 2014 的新功能以及每個版本的能力和授權



  • 安裝、升級並配置 SQL Server 2014，以獲得更好的性能和更簡單的管理



  • 使用 Smart Admin 簡化和自動化關鍵管理任務



  • 利用強大的新備份/還原選項：靈活的 URL 備份、Managed Backup to Windows Azure 和加密備份



  • 通過新功能加強安全性，以強制執行「最小特權」



  • 通過可更新的列存儲索引、延遲持久性和其他增強功能來改善性能



  • 使用記憶體優化表、緩衝池擴展和本地編譯的儲存過程更有效地執行查詢和業務邏輯



  • 使用資源管理器控制工作負載和磁碟 I/O



  • 部署 AlwaysOn 可用性群組和故障轉移叢集實例，以實現企業級可用性和災難恢復



  • 在主數據服務、數據質量和並行數據倉儲中應用新的商業智慧改進


類似商品