SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Monday Coffee: SQL Services in Containers

I had an interesting question on twitter last week when I published my post on Running Linux Container on Windows: –

“Does that container support Microsoft ML yet?”

I have absolutely no experience with Machine Learning so really had no clue. But as I had the container up and running I thought I’d give it a quick test by seeing if I could run a Python script. However I didn’t get far: –

The required services are not installed in the container so no luck. It’s the same with the SQL Agent service, you can enable it and create jobs but when you try and run them: –

The SQL Agent service is there in windows containers but if you try and start it up you’ll get a whole bunch of errors.

So it seems, for now, that it really is just the Database Engine that’s available in containers. That’s really useful on its own but there are a lot of people out there who require the other components of SQL Server. If Microsoft want to see people running SQL in Containers become widespread, then more functionality really needs to be available.

I actually have high hopes for this, especially with the announcement of the Agent running on Linux. Hopefully we’ll see this in containers soon.

Hmm, could try to build a custom image with the Agent…

Have a good week!


The DBA Who Came In From The Cold

I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and administration.

The online SQL Server community has helped me out immensely throughout my career, whether from providing reference material in blog posts, or answering my (sometimes obscure) questions on forums. So, to try and say thank you, I would like to contribute my own experiences in the hope that they could benefit someone out there.

So here’s my general ramblings and thoughts about working as a SQL Server DBA.

You can find me on twitter @DBAFromTheCold

If you have any feedback on my blog please send me an email to dbafromthecold@gmail.com.

Comments

Leave a comment on the original post [dbafromthecold.com, opens in a new window]

Loading comments...