By Jasmin Azemovic
- 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
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
- Linux distributions
- Installation and configuration
- SQL Server basics
- Database within the sandbox
- Sample databases
- Crash path in querying
- Backup and restoration operations
- User management
- Implementing information protection
- In-memory OLTP
- Beyond SQL Server
Read Online or Download SQL Server on Linux PDF
Best information technology books
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.
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.
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?
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.
- Managing Risk and Security in Outsourcing IT Services: Onshore, Offshore and the Cloud (Auerbach Book)
- Building Machine Learning Systems with Python
- Implementing Information Security in Healthcare: Building a Security Program
- Blender 2.49 Scripting
- Securing Cloud and Mobility: A Practitioner's Guide
Additional resources for SQL Server on Linux