We have a group of practitioners in our company who rely on Excel way too much, both for data that's too large and data that's too complex for it. At the same time we roll out SQL training to the practitioners, we wanted to explain the value and capabilities of database work to senior management so we could set the right tone. Any suggestions for online training, a set of articles or other resources that don't dive into SQL coding, but for which the attendees will still get the right message?
After a crazy Kickstarter adventure, I suddenly find myself with ~65 products to create, 2000 customers to send them to, and loads of information (names, email addresses, shipping details, order selections, order fulfillment status, funds donated) from 4 different sources (Kickstarter surveys, Surveymonkey.com, paypal.com, private emails). I need some way to keep track of all of it, so that I can easily find and export information (Who ordered product X? Who ordered product Y and hasn't yet had that order fulfilled), easily change entries (Customer B: Can I switch from product X to Y?) and easily add entries (New customer C). What's my best bet?
We have four departments and each has their own way of managing their student lists, I'd like to find one solution to rule them all. [more inside]
I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
Software for keeping lists of terms and definitions organized? Help me tame the glossary monster. [more inside]
What are good programs for sharing contact and calendar information in a small office? The most attractive piece of software I've found so far is "ACT!" [more inside]
Any good tips on managing approved software applications within an enterprise? [more inside]
I have a rather picky online photo album management question. [more inside]