SQL Server on Linux by Jasmin Azemovic

By Jasmin Azemovic

Key Features

  • Design and administer your SQL Server resolution at the open resource Linux platform
  • Install, configure, and fine-tune your database software for max performance
  • An easy-to-follow advisor educating you ways to enforce a variety of SQL Server CTP 2.x choices on Linux—from deploy to administration

Book Description

Microsoft's release of SQL Server on Linux has made SQL Server a really flexible platform throughout varied working platforms and data-types, either on-premise and on-cloud.

This publication is your convenient consultant to developing and enforcing your SQL Server answer at the open resource Linux platform. you'll commence by means of realizing how SQL Server will be put in on supported and unsupported Linux distributions. then you definately will brush up your SQL Server talents via growing and querying database items and imposing easy management projects to aid enterprise continuity, together with protection and function optimization. This booklet also will take you past the fundamentals and spotlight a few complex subject matters akin to in-memory OLTP and temporal tables.

By the top of this ebook, it is possible for you to to acknowledge and make the most of the complete capability of constructing an effective SQL Server database answer on your Linux environment.

What you are going to learn

  • Install and arrange SQL Server CTP 2.x on Linux
  • Create and paintings with database gadgets utilizing SQL Server on Linux
  • Configure and administer SQL Server on Linux-based systems
  • Create and fix database back-ups
  • Protect delicate facts utilizing the integrated cryptographic features
  • Optimize question execution utilizing indexes
  • Improve question execution time by way of greater than 10x utilizing in-memory OLTP
  • Track row-versioning utilizing temporal tables

About the Author

Jasmin Azemovic is a school professor lively within the database platforms, info defense, facts privateness, forensic research, and fraud detection fields. His PhD measure was once in modeling layout and constructing an atmosphere for the maintenance of privateness inside of database platforms. he's the writer of many medical study papers and books: Writing T-SQL Queries for novices utilizing Microsoft SQL Server 2012 and Securing SQL Server 2012. He has been a Microsoft MVP (Data Platform) for the final 10 years and a data protection advisor. he's an energetic speaker at many IT expert and neighborhood conferences.

Table of Contents

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

Show description

Read Online or Download SQL Server on Linux PDF

Best information technology books

Hacker's Guide to Project Management (Computer Weekly Professional)

Handling a software program improvement venture is a posh technique. there are various deliverables to supply, criteria and systems to watch, plans and budgets to fulfill, and varied humans to regulate. undertaking administration does not simply begin and finish with designing and development the approach. as soon as you have got special, designed and equipped (or obtained) the process it nonetheless should be effectively established, documented and settled into the stay surroundings.

Microsoft Project 2010 Inside Out

Triumph over Microsoft undertaking 2010—from the interior out! you are past the fundamentals, so dive correct in and very positioned your venture administration talents to paintings! This supremely geared up reference packs 1000's of timesaving options, troubleshooting information, and workarounds. it is all muscle and no fluff. notice how the specialists take on venture 2010—and problem your self to new degrees of mastery.

Network Culture: Politics For the Information Age

In an age of e mail lists and chat groups, e-zines and weblogs, bringing jointly clients, shoppers, staff and activists from worldwide, what forms of political subjectivity are rising? What forms of politics develop into attainable in a time of knowledge overload and media saturation? What constructions of strength and keep an eye on function over a self-organising approach just like the web?

Digital India: Understanding Information, Communication and Social Change

India's tryst with the electronic is an in depth undertaking and whereas a lot media realization is given to flagship tasks, the tale can be of marginalised peoples, in towns, appropriating electronic leaks, utilizing the electronic and thereby contributing to the electronic economic climate. it really is this conflict among enclosing the electronic and lengthening entry to it that makes the tale of the electronic in India a thrilling one.

Additional resources for SQL Server on Linux

Example text

Download PDF sample

Rated 4.18 of 5 – based on 12 votes