The database-development tag has no wiki summary.
22
votes
8answers
2k views
Are NoSQL databases going to take the place of relational databases? Is SQL going away? [closed]
Does anyone have experience with NoSQL databases (CouchDB, MongoDB, Google's BigTable, Dynamo, Cassandra...)? What was it like? Was it actual production/on the job experience?
What will happen to ...
3
votes
1answer
452 views
Database Application Design Best Practices [duplicate]
Once upon a time it was common practice for both the business logic and database logic to be written in the same language (eg PL/SQL, Transact SQL, etc), more recently the practice is to separate the ...
42
votes
12answers
1k views
What are the arguments against or for putting application logic in the database layer?
Most software developers want to keep application logic in the application layer, and it probably feels natural for us to keep it here. Database developers seem to want to put application logic in the ...
8
votes
2answers
2k views
How can I keep my visualstudio database project in sync with my database?
I'd like to have my database schema synchronized with my Visual Studio .dbproj database project.
Right now, I'm using SSMS for most of my database development work, and I've to manually use the ...
14
votes
5answers
298 views
Should my multi-server RDBMS or my Application handle database Referential Integrity?
Should items like Foreign Keys, Constraints, Default Values, and so on be handled by the database management system (in this case, MS SQL 2005) or the application? I have heard opinions from both ...
8
votes
6answers
8k views
what exactly do database programmers do?
Please take no offense, this is a genuine doubt I have.
Every time I read about Oracle programmers etc, I get this doubt. I am unable to understand what exactly they do. From my understanding, ...
12
votes
2answers
3k views
Best practice/Patterns for two way data synchronisation
Quite often in my work the idea of 2-way data synchronisation between database systems crops up. The classic example is two slightly different CRM systems (say, Raiser's Edge and Salesforce) and the ...
20
votes
8answers
4k views
Create my own database system [closed]
I need to learn how databases work in order to use them more efficiently, and my way of learning is by doing.
I want to create my own database system. I am not referring to creating a pseudo-database ...
9
votes
4answers
478 views
How do I Integrate Production Database Hot Fixes into Shared Database Development model?
We are using SQL Source Control 3, SQL Compare, SQL Data Compare from RedGate, Mercurial repositories, TeamCity and a set of 4 environments including production.
I am working on getting us to a ...
