Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying SQL Server on Linux
  • Table Of Contents Toc
SQL Server on Linux

SQL Server on Linux

1 (1)
close
close
SQL Server on Linux

SQL Server on Linux

1 (1)

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 (13 chapters)
close
close

AdventureWorks database

From SQL Server 2005 until 2016, this has been the new example. We can see it as like Northwind on steroids. In the last official version, AdventureWorks database included 71 user tables, which is more than five times larger than Northwind. Don't panic, it is just a good old customer-sales system but with more detail. Northwind deals with seafood, while AdventureWorks is about selling bicycles.

One of the biggest complaints about the previous examples is that they are not complex enough to present adequate real-life database system environments. If we just look at the partial list of tables we will get a picture:

Name                         
-----------------------------
Address
AddressType
AWBuildVersion
BillOfMaterials
BusinessEntity BusinessEntityAddress BusinessEntityContact ContactType CountryRegion CountryRegionCurrency CreditCard Culture Currency...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
SQL Server on Linux
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon