Getting Started with SQL Server 2014 Administration

Gethyn Ellis

  • 出版商: Packt Publishing
  • 出版日期: 2014-04-28
  • 售價: $1,280
  • 貴賓價: 9.5$1,216
  • 語言: 英文
  • 頁數: 106
  • 裝訂: Paperback
  • ISBN: 1782172416
  • ISBN-13: 9781782172413
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook.

Overview

  • Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology
  • Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases
  • This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples

In Detail

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such as SQL Server 2014 have evolved to allow DBAs to utilize both services to maintain their key service level agreements, ensuring that their important databases are always available. SQL Server 2014 has a strong focus on business intelligence, making it a vital tool if you are looking to improve the performance of your processes as a relational database professional.

Getting Started with SQL Server 2014 Administration will guide you through your first steps of learning SQL Server 2014 by introducing you to its new features and helping you create a hybrid environment, which is both highly available and allows you to get the best performance from your databases. This book is for anyone who wants to boost their database application performance to the next level.

What you will learn from this book

  • Design a SQL Server infrastructure combining on-premise servers and Windows Azure Storage
  • Create a backup strategy that allows you to store your SQL Server backup in the Windows Azure cloud
  • Improve database performance by using the In-Memory OLTP features
  • Implement the delayed durability feature to improve transaction latency
  • Use a cloud-based replica to build an AlwaysOn Availability Group
  • Learn the other enhancements and new features that can help improve database performance

Approach

This is an easy-to-follow handson tutorial that includes real world examples of SQL Server 2014's new features. Each chapter is explained in a stepbystep manner which guides you to implement the new technology.

商品描述(中文翻譯)

優化您的資料庫伺服器,使用 SQL Server 2014 的全新功能,使其達到快速、高效和高度安全的水平。本書和電子書將帶您深入了解 SQL Server 2014 的新功能,並提供實際案例。

概述:
- 通過結合本地和基於 Windows Azure 的技術,設計您的 SQL Server 2014 基礎架構
- 使用新的 In-Memory OLTP 資料庫引擎功能,提升交易資料庫的性能
- 本書提供實用的教學,探索 SQL Server 2014 的新功能,並提供真實世界的案例

詳細內容:
SQL Server 2014 的發布帶來了一些優秀的新功能和增強功能,資料庫管理員可以利用這些功能使其資料庫伺服器更快、高可用性且免於災害。隨著本地和雲端解決方案之間的界線變得更加模糊,企業級資料庫應用程序(如 SQL Server 2014)已經發展出來,使得資料庫管理員可以利用這兩種服務來維護其關鍵服務水平協議,確保其重要資料庫始終可用。SQL Server 2014 在商業智能方面有著強大的重點,這使得它成為關聯式資料庫專業人士提高流程性能的重要工具。

《開始使用 SQL Server 2014 管理》將引導您進入學習 SQL Server 2014 的第一步,介紹其新功能,並幫助您創建一個高可用性的混合環境,以獲得最佳的資料庫性能。本書適用於希望將其資料庫應用程序性能提升到更高水平的任何人。

本書將教您:
- 設計一個結合本地伺服器和 Windows Azure 儲存的 SQL Server 基礎架構
- 創建一個備份策略,使您可以將 SQL Server 備份存儲在 Windows Azure 雲端中
- 通過使用 In-Memory OLTP 功能來提升資料庫性能
- 實施延遲耐久性功能,以提高交易延遲時間
- 使用基於雲端的複本來建立 AlwaysOn 可用性群組
- 學習其他增強功能和新功能,以幫助提高資料庫性能

這是一本易於跟隨的實用教學,其中包含 SQL Server 2014 新功能的真實案例。每個章節都以逐步指南的方式解釋,引導您實施新技術。