Let me present myself for better understanding of my challenge. I love coding, it's been 5 years that I've been in a company as software developer. But for the past 3 years I've been quite pushed into ...
I started to encounter some issues on my production site, when having a web page that needs to load a very big ResultSet (currently coming from relational database, MySQL) it takes forever, and ...
I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source) I cannot truncate and populate the table in Sybase because it is used by an application, I ...
During the installation of a new development infrastructure, I had to install many SQL Server instances on different machines. Some were of course dedicated for production and some other for ...
I'm a web developer and I use primarily my own laptop at work. We use an SVN repository for our project codebases, and deploy our changes to an internal development server for testing. Our system ...
Background I am working on creating a new development process for a small web team of about 4 programmers and 4 designers, with the obvious potential to grow the team in the future. Our product is a ...
What I am looking to do, is schedule a copy of data from my production database to my dev/test database. The dev/test database will be newer than the production database in terms of schema, but the ...
To what extent does a Database Administrator need to know system or application level programming languages (for example .NET or PHP) besides "just SQL"? For the purposes of this question, no ...