useEffectEvent
: Goodbye to stale closure headachesDiscover why the useEffectEvent Hook is important, how to use it effectively, and how it compares to useRef.
Shadcn CLI 3.0 takes component management to a new level. With namespaced registries, private access, and AI-powered discovery, it’s now faster and smarter to build React UIs.
Zod’s flexibility comes at a cost. This article breaks down why Zod is slower than AOT-compiled validators like Typia, and how to fix it with a build-time optimization that brings production-grade performance.
Discover what’s new in The Replay, LogRocket’s newsletter for dev and engineering leaders, in the October 15th issue.
Would you be interested in joining LogRocket's developer community?
Join LogRocket’s Content Advisory Board. You’ll help inform the type of content we create and get access to exclusive meetups, social accreditation, and swag.
Sign up now
8 Replies to "How to run SQL Server in a Docker container"
SA_PASSWORD: “change_this_password” as shown on the docker-compose.yml file did not work for me and container logs had the following message:
2019-07-17 14:19:20.63 spid31s ERROR: Unable to set system administrator password: Password validation failed. The password does not meet SQL Server password policy requirements because it is not complex enough. The password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols..
2019-07-17 14:19:20.63 spid31s An error occurred during server setup. See previous errors for more information.
It seems that you need to change your password with something complex that fulfills the given criteria. “AEdCC.b9” should work I guess.
You will have to do as the password says “Change it” to something a bit more secure.
How can I the mentioned .sql file via docker-compose?
Can you tell me which npm package you are using and what version? I tried `npm i -g mssql` but that will not take the arguments you describe, it says no such file -u.
where does the Data and log files stored? If it is inside the container by default, how can we map to the host MacOs volume?
How do we backup the database to outside of the container?
good question, did you find it out?
Just add a volume:
“`
volumes:
– ~/apps/mssql/data:/var/lib/mssqlql/data
“`