Randolph West

@ElementZero Please let us know how you go with that process.

I'm glad you figured it out. Keep well and have a great weekend.

heh. You've just reminded me I owe someone an email about keyboard shortcuts in sqlops.

sqlops is very nice, and unfortunately I couldn't include a chapter about it in the 2017 book because of NDAs and timelines

you may have switched because of the repeat fee for Parallels

Fusion is good

too many layers

for the demo at my SQLBits session, I'm using SQL Server for Docker (macOS), and Operations Studio. I have Windows for Visual Studio, but I'm slowly migrating to VS Code.

yes, and I pay it every year with a smile

my Windows 10 VM is now stuck in update hell :-)

I'm very happy you've figured it out, but probably not as happy as you are

You may not have to flush DNS on Windows 10, but I do it out of habit

Always blame the network, I guess?

or did you remove it again and flush your DNS?

Is that now because the alias is bypassing all the network resolution stuff and going straight to the container, because of the hosts file?

hahaha, that's a good name for a container. I'd expect you to see a higher ping time at any rate

this virtualization within virtualization is using Hyper-V, that's why specific builds of Windows 10 / 2016 are necessary

I ran into something like that when I was setting up a lab last year

there's something janky in the way Hyper-V networking works though

That's hilarious because it's so silly

You were half right in your supposition about the ports; what was happening is every single command was going out and then back into through your virtual network. That must have been a hellish round trip.

LOL I know what that is

@NReilingh ping

Huh, I'm running a MacBook here myself. How are you virtualizing now? Parallels or other?

I did leave, sorry

docs.docker.com/docker-for-windows/images/settings-cpu-ram.png for example.

No matter which of these you choose, the SQL Server Docker image is running on Ubuntu under the covers, so it amounts to the same thing.

If this were me, I'd either install Docker from their own site, and then install SQL Server for Docker that way, or else spin up a Hyper-V Ubuntu VM and install SQL Server for Linux on there. Either way, there's a lot more control over resource allocation.

I don't have a Windows 10 host that isn't already virtualized that I can use to help you figure this out, otherwise I'd have done that an hour ago already.

Hey

To be perfectly honest, you're probably better off spinning up an Ubuntu Hyper-V VM on your machine, and installing SQL Server for Linux on that.

I did not miss that part. SQL Server uses connection pooling. I get that this is frustrating, but I also want to impress upon you to ensure that the container (or "weird Hyper-V lite VM" in this case) has enough RAM. Your PS script ran "quickly", but minutes to run through ~3000 objects is slow in a machine with enough RAM (i.e. more than 2 GB).

I am sorry, but I don't understand how you can conclude it's the port that's problematic. Check this link: stackoverflow.com/a/44145184/5807980

thanks :-)

I'm bad at SSAS

I have to run

yeah

if I knew the structure better, I might have a better idea, but it's not important for right now

I don't know what was wrong - probably the derived table needed the NOT EXISTS instead

schema, table, column, etc.

I use it for object names specifically

docs.microsoft.com/en-us/sql/t-sql/functions/…

QUOTENAME is a way to enforce the [ and ] automatically

ok so

heh, thanks ... I'm going to clean up the comments on that thread

I do forums for free, though ;-)

$200 CAD per hour, less if it's more than ten hours

bornsql.ca FWIW

I do, but I'm expensive

give that a shot