On the battlefield, in the server room, in the developers' halls of cubicles? In the procurement contracts too? More metadata for this info, please :-) Kind...
2716
amitoj singh
amitoj_pb1
Jan 21, 2012 6:28 pm
Dear Members. I need your help because I have stuck between academics and industry. I am doing my research on KM practices in Agile teams, to accomplish this...
2717
Scott Ambler
scottwambler
Jan 25, 2012 12:26 pm
The US Fed govt in general has been moving in this direction for awhile, including the DoD. It's likely a good thing they are trying to reduce waste....
2718
wbrianwhite
Feb 24, 2012 5:11 am
Here is how we solved a similar project at my company. We changed from a single database store to a sharded system, while also changing the data model and the...
2719
ROBERT
bobcorrick...
Feb 24, 2012 2:50 pm
This is a great post. I hope Amanda is still watching! Bob Corrick....
2720
Amanda Varella
amandavarell
Feb 24, 2012 3:53 pm
Yes I am, Thank you for the ideas! Amanda Varella Enviado via iPad ... [Non-text portions of this message have been removed]...
2721
bomasamudram
Apr 29, 2012 6:10 pm
I am currently sandwiched between a rock and a hard place confronting an organizational mandate to create a credible project plan for a complex data...
2722
Pramod Sadalage
psadalage
May 2, 2012 12:45 pm
Boma, To move the date to the left, you will have to identify what are the most important set of reports (all is not he right answer here) that the director...
2723
Shahid Ali
danishmughal
May 2, 2012 2:02 pm
I would recommend to first review the need of the data warehousing. If the company was able to move ahead for 5 years without it then it means it is not...
2724
Markus Gallagher
markus_galla...
May 2, 2012 3:33 pm
and make sure that you ask the WHY question 5 times... this is how you will discover the root cause of a particular subject. [Non-text portions of this message...
2725
Gabriel Tanase
datamodeller
May 2, 2012 6:06 pm
Indeed! Ask 5 times, but not the same person; try asking 5 different people, or maybe less than 5 but ask (some of them) twice, over a period of time. It is...
2726
timander37
Sep 27, 2012 4:07 am
I'm comparing database migration tools. We currently use a home-grown solution that has been described as a poor-man's Rails migration technique, where each...
2727
Alex
tiamot
Sep 27, 2012 4:53 am
I've used Flyway and think it's great! I would strongly suggest you give it a try....
2728
Gabriel Tanase
datamodeller
Sep 27, 2012 8:33 am
Related question: what tools would you recommend to maintain and version data for the following purposes: - reference data in production and non-production...
2729
Dennis Lloyd Jr
dennis_lloyd_jr
Sep 27, 2012 2:45 pm
I'm also using Flyway on a project and think it's fantastic. I like that I can write my scripts as SQL Code (instead of specifying them in XML). Since it keeps...
2730
Pramod Sadalage
psadalage
Sep 27, 2012 2:48 pm
I have used, DbDeploy, Flyway, LiquiBase, DBMaintain, iBatis Migrator, Rails Migrations All of them are good for different reasons. So can you tell us some of...
2731
ayo.akinyemi
Sep 27, 2012 3:18 pm
My team maintains a MySql database that have about 120 tables housed within 1 database. There is an Activity Logs table that records every action all users...
2732
David Poole
thetabetapi...
Sep 27, 2012 3:27 pm
If you send stuff to a separate database then make sure that the database is on a separate physical drive or you won't get the performance boost you expect. It...
2733
Pramod Sadalage
psadalage
Sep 27, 2012 3:34 pm
is the ActivityLog data needed by the application, if its just stored and not used by the application can you write to disk with ASync logging, in java you can...
2734
ayo.akinyemi
Sep 27, 2012 3:55 pm
Yes, the ActivityLog table is being used by the application. We do archive the table, and truncate data that are 3 weeks old. Now, we want to be able to...
2735
timander37
Sep 28, 2012 2:10 am
I'm very interested in this topic too. There seems to be a sub-set of database changes dealing with configuration data that we don't want to treat as...
2736
timander37
Sep 28, 2012 2:11 am
We use Microsoft SQL Server with the jTDS JDBC driver. The important features that I'm looking for are: Schema Versioning Plain SQL migrations Maven Plugin ...
2737
Berke Sokhan
berkesokhan@...
Sep 28, 2012 1:50 pm
Plus, you should consider dividing one big table to seperated tables, that each one is a shadow of the original table with additional column like change action...
2738
alexander_karmanov
alexander_ka...
Sep 28, 2012 1:51 pm
Well, I do it through a custom set of scripts which I built. Flyway seems to be doing something similar to what I do. The idea is simply to have all the...
2739
BW
bretweinraub
Oct 2, 2012 2:31 pm
why not write to a table called activity_log_[week of year] ? like activity_log_2012_23 # the 23rd week of 2012 you can then create a view that joined up the...
2740
deddy205ar
Oct 3, 2012 2:32 am
Gabe - ... Fascinating question. I am only aware of SCM (software configuration management) tools that deal with source code changes. Now that you ask, I have...
2741
Willem Bogaerts
toetah2000
Oct 3, 2012 8:26 am
... I wrote my own experiences with SQL scripts and version control in a howto: http://www.howtoforge.com/node/4833 If focuses on MySQL, but the principle...
2742
Scott Ambler
scottwambler
Oct 4, 2012 2:09 pm
Sounds like a fair bit of continuing maintenance to me. I tend to avoid stuff like that because a few years down the road these sorts of strategies tend to...
2743
bretweinraub
Oct 4, 2012 7:29 pm
Did I miss something? If we are "rotating"; logs, then we are writing to flat files. Last time I checked the amount of maintenance to recreate a view does not...
2744
ayo.akinyemi
Oct 4, 2012 7:29 pm
We are trying to move away from views, the idea of activity_log_[week of year] sounds tempting, but that would just be creating so many activity logs tables in...
