Do We Need to Learn Linux?

Question

Do We Need to Learn Linux?

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 10, 2021 at 12:00 am

#3905902

Comments posted to this topic are about the item Do We Need to Learn Linux?

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 1

Windocks has built a good business serving Windows SQL Server container support, which is unaffected by Microsoft's discontinuation of their official Windows SQL Server containers. Novartis, American Family Insurance, John Hancock, and scores of others rely on Windocks for SQL Server containers with database virtualization. Database virtualization or cloning delivers multi-database and multi-terabyte environments in seconds (similar to Red Gate DB cloning), to containers, Kubernetes, and conventional instances. I invite anyone to visit Windocks and give our software a free, supported trial. Over 90% of people who evaluate Windocks elect to become customers, so you're likely to be pleased with what you find.

This coming Monday (July 12th) we release Linux based database virtualization. Linux support combines database virtualization for Oracle, Postgres, and MySQL, and NoSQL data, for delivery to Docker containers, Kubernetes, and conventional instances . . . just as we do for Windows. The two systems share a management plane and API service, creating a distributed cross platform, versioned, DevOps data repo.

Paul Stanton

CarlDemelo Newbie Points: 1 More actions · Answer 2

Thanks for the clarification Paul. I did have some confusion over the announcement and how it relates to windocks containers. Glad to hear that the technology is not affected and we can continue building/running sql instance containers on windows OS using windocks.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Heh... "Do We Need to Learn Linux?"

I guess the obvious joke here would be "GOOD SIR!!! CONTAIN YOURSELF!!!"

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

I neglected to add a note about Windocks, but I've added one in the post. They do support Windows containers. However, not having Microsoft do so for SQL Server is disappointing.

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 5

pauls 72822

Ten Centuries

Points: 1049

July 11, 2021 at 12:56 am

#3906588

Thanks Steve, much appreciated!

Pablo Echeverria Right there with Babe Points: 729 More actions · Answer 6

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

Rod at work SSC-Dedicated Points: 34007 More actions · Answer 7

I'm surprised to see that Microsoft has stopped development of containers for SQL Server on Windows. I'm not clear if it's because it's too complicated of a task or they've felt it isn't worth the effort.

And I'm also confused by what you said about the Developer Edition of SQL Server. Are you saying Microsoft is going to discontinue that as well?

Kindest Regards, Rod Connect with me on LinkedIn.

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 8

Rod, Microsoft has discontinued all Windows SQL Server containers, including Dev/express editions. The reasons for discontinuation are several, and certainly subject to varied opinions, but seem to center on basic limitations on features and functionality.

sean redmond SSCertifiable Points: 5824 More actions · Answer 9

Does anyone have a good book/website to recommend learning Linux as a beginner? If so, what is it?

Kenneth Igiri SSCertifiable Points: 5001 More actions · Answer 10

I know a former colleague and Linux lover who will laugh me to scorn if he sees this article. 🙂

Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

A couple Linux resources for you.

http://linuxcommand.org/tlcl.php (used in the video series mentioned in the editorial)
https://www.edx.org/course/introduction-to-linux
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/how-to-linux-for-sql-server-dbas-part-1/

you can add WSL to your Windows 10 install, use a Docker container (log in with -it) or set up a VM. All good experiences and fairly easy.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 12

Rod at work wrote:

I'm surprised to see that Microsoft has stopped development of containers for SQL Server on Windows. I'm not clear if it's because it's too complicated of a task or they've felt it isn't worth the effort.
And I'm also confused by what you said about the Developer Edition of SQL Server. Are you saying Microsoft is going to discontinue that as well?

As noted, this is SQL Server on Windows Containers. Windows Containers still have a roadmap, and I don't think they are going away.

My suspicion here, and I have no knowledge, is that a) Windows is more expensive than Linux for a host, b) people looking at containers were more interested in Linux/K8s/Big Data Clusters, and C) the team finds it easier and wants to focus there.

That being said, they need to ensure feature parity, or at least a few more things and better HA support. I 'd want to see Linked Server support elsewhere, CLR, backup to URL, a CMD for SQL Agent, a few more.

Rod at work SSC-Dedicated Points: 34007 More actions · Answer 13

pauls 72822 wrote:

Rod, Microsoft has discontinued all Windows SQL Server containers, including Dev/express editions. The reasons for discontinuation are several, and certainly subject to varied opinions, but seem to center on basic limitations on features and functionality.

Thank you for letting me know.

Kindest Regards, Rod Connect with me on LinkedIn.

Rod at work SSC-Dedicated Points: 34007 More actions · Answer 14

Steve Jones - SSC Editor wrote:

Rod at work wrote:
I'm surprised to see that Microsoft has stopped development of containers for SQL Server on Windows. I'm not clear if it's because it's too complicated of a task or they've felt it isn't worth the effort.
And I'm also confused by what you said about the Developer Edition of SQL Server. Are you saying Microsoft is going to discontinue that as well?
As noted, this is SQL Server on Windows Containers. Windows Containers still have a roadmap, and I don't think they are going away.
My suspicion here, and I have no knowledge, is that a) Windows is more expensive than Linux for a host, b) people looking at containers were more interested in Linux/K8s/Big Data Clusters, and C) the team finds it easier and wants to focus there.
That being said, they need to ensure feature parity, or at least a few more things and better HA support. I 'd want to see Linked Server support elsewhere, CLR, backup to URL, a CMD for SQL Agent, a few more.

Thank you for clarifying, Steve.

Kindest Regards, Rod Connect with me on LinkedIn.