DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
The Latest "Software Integration: The Intersection of APIs, Microservices, and Cloud-Based Systems" Trend Report
Get the report
  1. DZone
  2. Data Engineering
  3. Databases
  4. SQL Server on Linux: Boring (And Why That's Great)

SQL Server on Linux: Boring (And Why That's Great)

MS SQL Server for Linux is available as an early community preview, and it's already boring. Find out why that's a good thing in this post.

Grant Fritchey user avatar by
Grant Fritchey
·
Nov. 26, 16 · Opinion
Like (6)
Save
Tweet
Share
7.43K Views

Join the DZone community and get the full member experience.

Join For Free

as a concept, sql server on linux is thrilling. due to this, the os doesn’t stand in the way of taking advantage of everything that sql server offers. because we have linux, we have the opportunity for all sorts of new fun.

i first saw sql server running on linux about six months ago. the install was shockingly easy. i saw a few command line commands run and it all looked good. i didn’t have the opportunity to set up my own full blown install then, but i do now.

my installation

today i did all the work necessary to get this thing running. i got a copy of ubuntu desktop and put it on vmware workstation in a virtual machine. that was a painless process. side note: it was a painless process because vmware recognized the os i was installing, therefore, was able to help me set it up. full props to vmware.

the sql server install from the terminal went very well. after a few typos on my part, done. i got the ip address of the machine, swapped back over to a vm running windows that had ssms installed. then, i connected up and it all just…. worked…

redgate sql compare connected to linux

suddenly, though, it was boring. i tested a few redgate tools (sql compare is right there above, connected to linux) to be sure they worked. no major issues encountered. great. however, now, it’s just another instance of sql server.

i guess i could start complaining that sql agent isn’t there… except i’m not that big a fan of sql agent, and i can schedule all sorts of stuff to run in linux using the sqlcmd command line tool.

i find it actually thrilling and exciting that sql server on linux is boring. sql server on linux is an early community preview and it’s already dull. consequently, the boredom, dullness, just the plain old ordinariness of it, means that microsoft has done a good job.

sql Linux (operating system)

Published at DZone with permission of Grant Fritchey, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Distributed Tracing: A Full Guide
  • Configure Kubernetes Health Checks
  • Host Hack Attempt Detection Using ELK
  • Introduction Garbage Collection Java

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: