• Adam Thurgar

Docker update - Linux good


After touching base with a few contacts at Microsoft, I tried a number of suggestions to get the Windows container working with SQL Server 2016 Developer Edition. No success, same error as before.

So I tried the Linux container with SQL Server 2017, easy to install and worked like a dream. Connected from SSMS 2017.

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker

Now that I know that Docker containers work, I just wish that the error with Windows container could be fixed so I can run different containers for different versions of SQL Server.


3 views0 comments

Recent Posts

See All

Autoclose and autoshrink - set them to off

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose and/or autoshrink. If so, you should change these settings as p

Hypothetical indexes

We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where hypothetical indexes and statistics that had been created by the Database

How one small change caused the CPU to go crazy

Finding the cause of very high CPU usage on your SQL Server may not be as easy as running scripts against a few DMV's, looking at perfmon or the activity on your server. We found this out recently whe