October 27, 2017 at 11:16 am
Thom A - Friday, October 27, 2017 10:47 AMGrant Fritchey - Friday, October 27, 2017 10:31 AMLynn Pettis - Friday, October 27, 2017 9:52 AMIs there a tool like SSMS that can be run on a Mac or Linux laptop?Run SSMS inside a container?
Unless my understanding of containers is wrong/dated, can't they only be the same as the host OS. Thus Windows can only run Windows Containers, Linux can only run Linux Containers, etc. To run a Windows container on a Docker/Linux host you'd firstly need a Windows VM on the Host, but then you might as well just run SSMS on the VM.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2017 at 11:57 am
Grant Fritchey - Friday, October 27, 2017 11:16 AMYou can actually get around that. I've been running SQL Server on Linux in a container without installing a full-blown Linux VM. Works really well.
On Win 10, there's a Linux Subsystem. I think that's what makes this work. Ubuntu containers are supported. Not sure about RHEL or CentOS. But this is the same reason you can run Bash on Windows.
October 27, 2017 at 1:14 pm
Steve Jones - SSC Editor - Thursday, October 26, 2017 8:02 AMjasona.work - Thursday, October 26, 2017 6:51 AMThe downside to working from home is, if the cats decide it's the season to start throwing up on the carpet, you kind of need to clean it up instead of pretending you don't see it until the wife gets home and notices it...I got to mop up urine yesterday when a dog made a mess between conference calls.
Yeah, but both pale in comparison to baby spit up and other issues. When he wants his diaper changed or decides he's hungry, it doesn't matter how urgent the project I'm working on is or what meeting / conference call I'm online with.
And I've only been back to work two days as of now... Sigh. Parenthood. What a joy. Still, he's very warm and cuddly at this age. I "wore him" to my home office yesterday.
October 27, 2017 at 1:22 pm
Brandie Tarvin - Friday, October 27, 2017 1:14 PMSteve Jones - SSC Editor - Thursday, October 26, 2017 8:02 AMjasona.work - Thursday, October 26, 2017 6:51 AMThe downside to working from home is, if the cats decide it's the season to start throwing up on the carpet, you kind of need to clean it up instead of pretending you don't see it until the wife gets home and notices it...I got to mop up urine yesterday when a dog made a mess between conference calls.
Yeah, but both pale in comparison to baby spit up and other issues. When he wants his diaper changed or decides he's hungry, it doesn't matter how urgent the project I'm working on is or what meeting / conference call I'm online with.
And I've only been back to work two days as of now... Sigh. Parenthood. What a joy. Still, he's very warm and cuddly at this age. I "wore him" to my home office yesterday.
Enjoy it while you can. Next thing you will know they are walking across the stage graduating from High School.
October 28, 2017 at 5:25 pm
This really isn't SQL related (well it isn't at all apart from my attempt to get multiple SQL instances running on a single Linux Machine), but anyone got any experience with Containers on Ubuntu 16.04? I've set one up, but I'd like it to use the DHCP on my home network, not what the host machine assigns it. This means I'd be able to access it by SSH directly, rather than having to SSH to the host, and then SSH to the IP, not the name, of the container (or use lxc exec [ContainerName] bash).
When I successfully set up the container to use the network DHCP, however, the host loses the internet. It's as if I can have the host on the the network, and the containers effectively in a kind of DMZ, or have the containers using the network DHCP and the host is a magical no man's land with no access to anything (including the containers apart from via lxc exec).
Been trying to configure this several times today and I'm at my wits end now. No amount of Googling provides an answer that works (different solutions all seem to give the same result)... I give up. 🙁
If anyone has any insight would be great. Thanks.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2017 at 4:14 am
Lynn Pettis - Friday, October 27, 2017 9:52 AMIs there a tool like SSMS that can be run on a Mac or Linux laptop?
I think I already suggested this before, but this thread is SOOOO LONG!
If you're fine with paying like $20 a month, there is DataGrip from JetBrains. It installs on Windows, Mac, and Linux. It's highly customizable is a GUI for database objects, has code completion, code generation, import/export, etc. The company is pretty flexible too. If you reach out and tell them your needs like only wanting to license DataGrip for X number of employees, they would prob customize an agreement with you, especially if you cite you rather use SSMS as opposed to DataGrip. Right now, the monthly sub is for access with all of their other awesome IDE's including DataGrip.
October 30, 2017 at 9:10 am
Thom A - Saturday, October 28, 2017 5:25 PMThis really isn't SQL related (well it isn't at all apart from my attempt to get multiple SQL instances running on a single Linux Machine), but anyone got any experience with Containers on Ubuntu 16.04? I've set one up, but I'd like it to use the DHCP on my home network, not what the host machine assigns it. This means I'd be able to access it by SSH directly, rather than having to SSH to the host, and then SSH to the IP, not the name, of the container (or use lxc exec [ContainerName] bash).When I successfully set up the container to use the network DHCP, however, the host loses the internet. It's as if I can have the host on the the network, and the containers effectively in a kind of DMZ, or have the containers using the network DHCP and the host is a magical no man's land with no access to anything (including the containers apart from via lxc exec).
Been trying to configure this several times today and I'm at my wits end now. No amount of Googling provides an answer that works (different solutions all seem to give the same result)... I give up. 🙁
If anyone has any insight would be great. Thanks.
Do you need DHCP? I tend to aim for static IPs for my VMs to be sure I know where I'm connecting.
October 30, 2017 at 11:10 am
Jeff, Thom, and Steve (sgmunson),
Thanks for your support. I have no interest in helping he who will not be named after the unprofessional attacks that were perpetuated.
Also, everyone, please do not pile on. It isn't necessary.
October 30, 2017 at 11:15 am
Steve Jones - SSC Editor - Monday, October 30, 2017 9:10 AMThom A - Saturday, October 28, 2017 5:25 PMThis really isn't SQL related (well it isn't at all apart from my attempt to get multiple SQL instances running on a single Linux Machine), but anyone got any experience with Containers on Ubuntu 16.04? I've set one up, but I'd like it to use the DHCP on my home network, not what the host machine assigns it. This means I'd be able to access it by SSH directly, rather than having to SSH to the host, and then SSH to the IP, not the name, of the container (or use lxc exec [ContainerName] bash).When I successfully set up the container to use the network DHCP, however, the host loses the internet. It's as if I can have the host on the the network, and the containers effectively in a kind of DMZ, or have the containers using the network DHCP and the host is a magical no man's land with no access to anything (including the containers apart from via lxc exec).
Been trying to configure this several times today and I'm at my wits end now. No amount of Googling provides an answer that works (different solutions all seem to give the same result)... I give up. 🙁
If anyone has any insight would be great. Thanks.
Do you need DHCP? I tend to aim for static IPs for my VMs to be sure I know where I'm connecting.
Yes, it'll be a static IP, but is not in the same IP range. It's using a bridge with a different subset, that doesn't talk to the outside network and vice versa (apart from the internet).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 30, 2017 at 11:41 am
Lynn Pettis - Monday, October 30, 2017 11:10 AMJeff, Thom, and Steve (sgmunson),Thanks for your support. I have no interest in helping he who will not be named after the unprofessional attacks that were perpetuated.
Also, everyone, please do not pile on. It isn't necessary.
Thanks for posting it here and noted for future reference. BTW, Gail's question still hasn't been answered.
October 30, 2017 at 12:24 pm
Ed Wagner - Monday, October 30, 2017 11:41 AMLynn Pettis - Monday, October 30, 2017 11:10 AMJeff, Thom, and Steve (sgmunson),Thanks for your support. I have no interest in helping he who will not be named after the unprofessional attacks that were perpetuated.
Also, everyone, please do not pile on. It isn't necessary.Thanks for posting it here and noted for future reference. BTW, Gail's question still hasn't been answered.
Maybe he will now attack Celko.
October 30, 2017 at 12:32 pm
Lynn Pettis - Monday, October 30, 2017 12:24 PMEd Wagner - Monday, October 30, 2017 11:41 AMLynn Pettis - Monday, October 30, 2017 11:10 AMJeff, Thom, and Steve (sgmunson),Thanks for your support. I have no interest in helping he who will not be named after the unprofessional attacks that were perpetuated.
Also, everyone, please do not pile on. It isn't necessary.Thanks for posting it here and noted for future reference. BTW, Gail's question still hasn't been answered.
Maybe he will now attack Celko.
/Me grabs a big-ol-bucket of popcorn and settles in to watch the show
October 30, 2017 at 12:43 pm
jasona.work - Monday, October 30, 2017 12:32 PMLynn Pettis - Monday, October 30, 2017 12:24 PMEd Wagner - Monday, October 30, 2017 11:41 AMLynn Pettis - Monday, October 30, 2017 11:10 AMJeff, Thom, and Steve (sgmunson),Thanks for your support. I have no interest in helping he who will not be named after the unprofessional attacks that were perpetuated.
Also, everyone, please do not pile on. It isn't necessary.Thanks for posting it here and noted for future reference. BTW, Gail's question still hasn't been answered.
Maybe he will now attack Celko.
/Me grabs a big-ol-bucket of popcorn and settles in to watch the show
Given the two personalities involved, that would be a fun one to watch, wouldn't it? 😛
October 30, 2017 at 6:52 pm
Anybody on the thread going to be at the summit this year?
Want to get together for a picture?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 31, 2017 at 4:30 pm
WayneS - Monday, October 30, 2017 6:52 PMWed Anybody on the thread going to be at the summit this year?
Want to get together for a picture?
Let's do it. Either Tues or Wed night reception or Fri am.
Viewing 15 posts - 60,226 through 60,240 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply