Comments | luvcraft: databasin' like a mamma jamma

luvcraft

databasin' like a mamma jamma

Aug 20, 2009 12:02

so guys, my department chair wants me to build a gigantic database of all of our department's employees, and associated facilities' employees, current, former, and known-future, including everything from where they went to school to their salaries to the ages and names of their children. This database also needs to be able to be used to generate ( Read more... )

Comments 15

callmesteam August 20 2009, 18:42:02 UTC

NotePad FTW.

elegantelbow August 20 2009, 19:49:11 UTC

Bah.

Everybody knows you keep a database in WordPerfect 5.1 for DOS.

elegantelbow August 20 2009, 19:48:50 UTC

I would strongly object to being in said database. WTF do they want to spend money doing this?

luvcraft August 20 2009, 20:24:02 UTC

so that they will know EVERYTHING

luvcraft August 20 2009, 20:36:13 UTC

We like to push, file, stamp, index, brief, debrief, and number our employees. :)

_wirehead_ August 20 2009, 23:01:49 UTC

yeah, glad i'm not the only one who got a little creeped out reading that.

coffegrl August 20 2009, 21:00:26 UTC

what version of MS Sql do you have access to? If you've got access to SQL 2008 there is change data capture functionality built in that can be use to do just what you are looking for.
One caveat: CDC is only available in the Enterprise version of MS SQL.
If you want more info I can send you a link to the msdn articles on it.

coffegrl August 20 2009, 21:01:38 UTC

oh, one plus to using MS SQL is that you can run SSRS and have your reports generated and emailed to subscribers or just there waiting to be run on request

antje23 August 20 2009, 23:36:52 UTC

Also, this, because apparently I can't read.

Also, Depending on the size of your database, the SSAS built into 2008 is pretty awesome as well.

luvcraft August 20 2009, 21:02:26 UTC

will it just date stamp it on the date it's changed, or can I go in and edit it and specify a date for each entry?

Thread 6

kdd1d August 20 2009, 21:48:31 UTC

Wow, he's still pushing that database, huh? Good luck and while you're at it, why don't you hit up the Operations Manager for some help. You know she claims to be an expert at crap like this.

_wirehead_ August 20 2009, 23:04:24 UTC

oh, i think you'll need a custom database-backed application (think Django or Ruby on Rails) to do it most easily. though you could probably hack something with Access, it'll be a PITA. a quick Google suggests that Django at least will talk to MS SQL, though i've never tried it.