For the longest time I thought SQL Server was a different Operating System intended for special computers. This looks like you're using SQL Server on the same machine that already has Windows installed... and on the same machine where you're using MS Access. Is this correct?
If I have a small office setup with 20 computers attached to a network, I can install SQL Server Express on 1 computer and all other computers on that network can get data from the one I have SQL Server Express installed? For some reason I thought this setup would be more involved.
Do most businesses have a different computer with SQL Server Express installed that is dedicated to database back end? Then I can use SSMS to make changes on from a different computer?
How does this compare to Network Attached Storage (NAS)?
Yes you'd tend to put SSMS on another machine.
Same way an Access FE on a client machine can talk to an Access BE on a server.
It's down to separation of concerns and permissions. You probably wouldn't want your users to be able to get on the server/machine that houses the data as it can be sensitive etc.
But giving them access to a GUI to connect to, you can then control exactly what they can do
I agree - and I'll talk more about this in a video. I'm planning on doing a Q&A-style video as the last lesson in each level. LOTS of questions like this coming in.
Matt Hall
@Reply 35 days ago
I have 4 college aged kids that have all grown up on Apple and Google hardware. These products are handy as they bypass the setup headache of an old XT or AT computer. Without that experience though, it is easy for people to be confused by the various hardware designations like NAS, server, Client, PC, Chromebook, IPad, micro controller, etc. This seems to be analogous to your Vibe-Coding comments, only for hardware.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
