Questions tagged [development]
37 questions
20
votes
7 answers
Does a DBA need to know how to program in a system language besides SQL?
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 specific version of the SQL standard is considered for…
p mac
- 201
- 1
- 2
- 3
14
votes
1 answer
How to setup local database development process for small web team?
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 central application that powers client websites…
Derek Downey
- 23,568
- 11
- 79
- 104
8
votes
2 answers
Do agile software development approaches apply to SQL?
I would like to learn if agile software development methods/principles/patterns are valid to SQL programming as well. If yes, where would be a good place to start learning about that? Are there any articles or books targeting agile development in…
Κύριε ἐλέησον
- 165
- 1
- 5
6
votes
3 answers
Recommended SQL Server transaction logs settings for ephemeral databases?
I'm looking for recommendations on how should I set up transaction logs for databases that are used by a development team. These databases are ephemeral in the sense that we never care about data recovery in case of hardware/software failure.…
liori
- 289
- 1
- 9
5
votes
1 answer
How can we manage cross-database dependencies across environments?
I've put off asking this question for some time since it's tricky to
encapsulate our situation and challenges without a wall of text, but the
situation is getting worse so I'll do my best. I'm looking for some assistance in improving the way we…
krystah
- 747
- 9
- 19
4
votes
2 answers
what would be the right permission to allow everything else but overwriting or creating a database?
I have a test environment where the AD group mycompany\developers is currently sysadmin.
Recently I have had some issues, specially regarding to people restoring databases. My concerns are:
sometimes the database is involved in replication
the…
Marcello Miorelli
- 17,274
- 53
- 180
- 320
4
votes
1 answer
How to develop a database (workflow)?
tl;dr: I know a few SQL semantics and I know how databases work (basically) but I never created one that had a considerable size. I lack of knowledge concerning workflow, SQL-code management and very basic SQL programming practices (write by hand or…
Stefan Falk
- 165
- 8
3
votes
1 answer
Migrate small sets of data from production to staging/sandbox
I have a development environment that consists of a production, staging and development servers that host SharePoint 2010 or 2013 as well as SQL Server 2008 R2. These each need to have relevant data, though there is limited bandwidth and hardware…
Christopher
- 31
- 5
3
votes
1 answer
Tool to test RDBMS SQL dialect for ANSI SQL standard compliance
We are developing an interface to our internal data storage and manipulation tool that would allow people to use SQL dialect.
We decided that it would be perfect to make our SQL dialect as close to the standard as possible.
Currently I'm trying to…
kovalad
- 51
- 7
3
votes
3 answers
Who should own application objects?
So I am just started doing stuff resembling full-blown Oracle DBA work recently, so am still learning much of the basics of the administration part of my job. I have been tasked with bringing multiple application databases up to meet a certain set…
Jeff Bauersfeld
- 335
- 5
- 16
2
votes
2 answers
Using MySQL/PHP PDO, is there a 'simulate' or dry run option?
Does MySQL (or, ideally, PHP PDO) have some way of simulating transactions without actually committing them? (Can I get MySQL or PDO to act as if data is inserted/deleted/updated, without actually committing any INSERT, DELETE or UPDATE…
Agi Hammerthief
- 249
- 4
- 13
2
votes
2 answers
Creating a database with only MySQL command line?
The linux server on which I'm attempting to create a MySQL database has many difficult to work with permissions. My supervisor has tried to install MySQL Workbench on the server, but has been unable to "build" the correct install (he knows much more…
pheidlauf
- 131
- 1
- 5
2
votes
1 answer
Preferred Methods of copying a new database from Development to Production
I am wondering what are preferred methods to copy a new (Development) database into a new environment.
The database will be empty, so essentially I am copying only the schema of this database and not the data.
Options include:
1) SSMS…
Dina
- 1,507
- 4
- 27
- 42
2
votes
2 answers
Can I default to T-SQL only view in VS 2012?
When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design view, and probably never will. I just prefer the…
blachniet
- 121
- 3
2
votes
2 answers
Is there a best practice for resolving dependencies of SQL objects for build during development?
I have a greenfield project involving a SQL database that is under development. There is no production data involved yet. There is a rather long list of specifications which I expect can be implemented with a collection of SQL tables, views,…
alx9r
- 449
- 3
- 9