I am a 100% self taught MS Access programmer (main part of my job is programming), I am now building larger databases; still using MS Access as the UI but SQL Server to store all data and do more of the 'work'.
In essence my question is; what subject matters do I need to know for SQL Server that I probably didn't learn or need when using Access?
Not looking for you to tell me how to do anything, more what you think are the most important things I should go an research - there's a lot of subjects and a hell of a lot of detail, don't want to find myself a long way down a less valuable path...
- Maintenance: what are the most important (check database, reduce database, update statistics, rebuild etc)
- Indexes - I don't know as much as I should, is there a good book/ blog etc that can teach me the basics upwards?
- Anything else I have missed (there's probably lots, as I said I am new to SQL Server...)
If it helps I work for a mid sized retailer and the databases I predominantly work on cover such things as
- Reporting platform (summarises sales/ receipts/ inventory etc from main system and provides fast reporting)
- A reconciling tool between a third part and what our stores put through registers (imports data from third party and cross references the transaction logs)
- Stores all data to do with our promotions; product, prices, projections, actual results etc