SQL Server on Linux

Jasmin Azemovic

  • 出版商: Packt Publishing
  • 出版日期: 2017-08-11
  • 售價: $1,770
  • 貴賓價: 9.5$1,682
  • 語言: 英文
  • 頁數: 222
  • 裝訂: Paperback
  • ISBN: 1788291808
  • ISBN-13: 9781788291804
  • 相關分類: LinuxMSSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Key Features

  • Design and administer your SQL Server solution on the open source Linux platform
  • Install, configure, and fine-tune your database application for maximum performance
  • An easy-to-follow guide teaching you how to implement various SQL Server CTP 2.x offerings on Linux—from installation to administration

Book Description

Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.

This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.

By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.

What you will learn

  • Install and set up SQL Server CTP 2.x on Linux
  • Create and work with database objects using SQL Server on Linux
  • Configure and administer SQL Server on Linux-based systems
  • Create and restore database back-ups
  • Protect sensitive data using the built-in cryptographic features
  • Optimize query execution using indexes
  • Improve query execution time by more than 10x using in-memory OLTP
  • Track row-versioning using temporal tables

About the Author

Jasmin Azemović is a university professor active in the database systems, information security, data privacy, forensic analysis, and fraud detection fields. His PhD degree was in modeling design and developing an environment for the preservation of privacy inside database systems. He is the author of many scientific research papers and two books: Writing T-SQL Queries for Beginners Using Microsoft SQL Server 2012 and Securing SQL Server 2012. He has been a Microsoft MVP (Data Platform) for the last 10 years and an information security consultant. He is an active speaker at many IT professional and community conferences.

Table of Contents

  1. Linux distributions
  2. Installation and configuration
  3. SQL Server basics
  4. Database in the sandbox
  5. Sample databases
  6. Crash course in querying
  7. Backup and recovery operations
  8. User management
  9. Implementing Data protection
  10. Indexing
  11. In-memory OLTP
  12. Beyond SQL Server

商品描述(中文翻譯)

主要特點


  • 在開源Linux平台上設計和管理您的SQL Server解決方案

  • 安裝、配置和微調您的數據庫應用程序以獲得最佳性能

  • 一個易於遵循的指南,教您如何在Linux上實施各種SQL Server CTP 2.x的功能,從安裝到管理

書籍描述

微軟在Linux上推出SQL Server使得SQL Server成為一個真正多功能的平台,可以在不同的操作系統和數據類型上運行,無論是在本地還是在雲端。

本書是您在開源Linux平台上設置和實施SQL Server解決方案的便捷指南。您將首先了解如何在支持和不支持的Linux發行版上安裝SQL Server。然後,通過創建和查詢數據庫對象以及實施基本的管理任務來支持業務連續性,包括安全性和性能優化,您將提高SQL Server技能。本書還將帶您深入了解一些高級主題,如內存OLTP和時間表。

通過閱讀本書,您將能夠充分認識並利用在Linux環境中建立高效SQL Server數據庫解決方案的潛力。

您將學到什麼


  • 在Linux上安裝和設置SQL Server CTP 2.x

  • 使用Linux上的SQL Server創建和操作數據庫對象

  • 配置和管理基於Linux的系統上的SQL Server

  • 創建和恢復數據庫備份

  • 使用內置的加密功能保護敏感數據

  • 使用索引優化查詢執行

  • 使用內存OLTP將查詢執行時間提高10倍以上

  • 使用時間表跟踪行版本

關於作者

Jasmin Azemović是一位大學教授,從事數據庫系統、信息安全、數據隱私、法醫分析和欺詐檢測等領域的研究。他的博士學位是在建模設計和開發用於保護數據庫系統內隱私的環境方面。他是許多科學研究論文和兩本書的作者:《使用Microsoft SQL Server 2012編寫T-SQL查詢的初學者指南》和《保護SQL Server 2012》。他是過去10年的Microsoft MVP(數據平台)和信息安全顧問。他是許多IT專業和社區會議的活躍演講者。

目錄


  1. Linux發行版

  2. 安裝和配置

  3. SQL Server基礎知識

  4. 沙盒中的數據庫

  5. 示例數據庫

  6. 查詢速成課程

  7. 備份和恢復操作

  8. 用戶管理

  9. 實施數據保護

  10. 索引

  11. 內存OLTP

  12. 超越SQL Server