Posted: 5/3/2017 8:47:15 PM EDT
|
Any recommendations for a book or online resource to get me up to speed on sql express?
Assume I know just enough to be dangerous but have the sense to look before I leap. I have two different software packages that are using databases on a virtual machine. On older versions of the software, I knew my way around enough to insert and modify data successfully. In one case, paradox .db files I could query and mod using linked tables in access, and the other case an access database where I needed to retrieve data for others, but not modify it. Ideally, I'd like to do something similar to what I set up in access. There, I created several front ends with a switchboard to display the report each user needed specifically. Db admin is not my day job. Deploying the equipment that comes with these db is my day job. I just need to fill a couple gaps to make the transition smooth. |
|
Quoted:
There really isn't much to learn. Just install it and point your software to it. If you are going to write your own programs and queries then you can simply google how to write the query or stored procedure you want. So far my googling has turned up tutorials and references for managing the databases; installing and managing security and users, etc. My IT department is good at that. What I know is which tables have my data; what my IT department can't provide is somebody who can write queries and respond to manufacturing in hours instead of weeks. How about something more specific. refer to this: https://www.microsoft.com/en-us/sql-server/developer-tools I have downloaded SQL Server management studio. I can connect and poke around in the tables which mostly seem familiar to the old system. Is visual studio going to be a better environment to quickly develop a couple of tools: 1. find all part numbers where [Technology] is "SMT" and [Insert Class] is Null; then update [Insert Class] to "SMT" (the software's native method steps manually through potentially hundreds of part numbers; the programmers simply don't want to do it) 2. find all records for an arbitrary s/n a. compare operator responses to a table of correct responses and return True/False (basically the operator is running a machine that inspects a product with injected faults, the operator is expected to classify the defects correctly to be certified to operate the machine). b. return the classification for a feature (after the operator is certified, if a defect escapes we want to know if the machine missed the defect, or if the operator mis-classified it) (I think my description of each task is longer than the actual SQL statements) ETA: I don't need a hand hold through that TL;DR stuff. Just head me off before I head down too many blind alleys. 
|