Book Image

SQL Server on Linux

Book Image

SQL Server on Linux

Overview of this book

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.
Table of Contents (19 chapters)
Title Page
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

DBeaver – third party tool


Last but not least, DBeaver (http://dbeaver.jkiss.org/) is a very cool multiplatform GUI frontend that can help you with your daily tasks if you are not such a big fan of the command line. Yes, sometimes sqlcmd is necessary and better, but why use it when we have the luxury not to?

So why have we chosen DBeaver? First, it is open source, free, and supports many different SQL and NoSQL databases. SQL Server is just one name on the big list:

  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • IBM DB2
  • Access
  • Sybase
  • Java DB
  • Firebird
  • Derby
  • SQLite
  • Mimer
  • HSQLDB
  • H2
  • IBM Informix
  • Teradata
  • SAP MAX DB
  • Cache
  • Ingres
  • Linter
  • Vertica
  • MongoDB
  • Cassandra

If you're a database professional, or you are intending to be, then there is a big chance that you will have at least two or more different databases installed on your workstation. This might lead you to believe that DBeaver is the right tool for you.

Note

While I am writing this book, SQL Server on Linux is passing from an early development stage to the near final CTP 1.3...