Skip to main content

Questions tagged [development]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
121 views

Is there a version of System.Data.SqlClient that does not support Encryption for Connections?

I am looking at IIS server that hosts tens of applications. Some of them are pretty old. All of them are using connection strings that are stored in machine.config in C:\Windows\Microsoft.NET\...
Aleksey Vitsko's user avatar
0 votes
1 answer
120 views

How route traffic to a Azure SQL server via a jump server to prevent whitelistingof dev machine?

I have to connect to Azure SQL server (e.g. mydatabase.azuredb.windows.net:1433). In order to do so, i have to inform my ADMIN to whitelist my machine's IP, works fine that day. NExt day my machine ...
AsitK's user avatar
  • 101
0 votes
1 answer
71 views

How can I get started with developing on PostgreSQL?

Is there any tutorial on how can we build, debug or add features on PostgreSQL database source code, or even develop and debug extensions? I am interest on adding some features on PostgreSQL database ...
Stavros Koureas's user avatar
1 vote
1 answer
501 views

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 ...
alx9r's user avatar
  • 431
2 votes
2 answers
500 views

Is database development stages the same as software development?

In software development, there are a series of stages that it will goes through - Dev, Test, UAT, Staging, Demo and Production. This is what I feel is correct, after reading/researching through the ...
SunnyBoiz's user avatar
  • 153
-2 votes
1 answer
2k views

Row_number to not increment if values on three columns are the same from the row before

Suppose I have a dataset that looks like the screenshot below and I need to add a count column for the rows based off the orderid, DocumentNo_, and CurrPackageTrackingNo with the following logic: ...
Keith Rivera's user avatar
6 votes
3 answers
469 views

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 ...
liori's user avatar
  • 289
1 vote
1 answer
1k views

How to Set Up a Shadow Production Database for PostgreSQL?

I'm working on a Django project and I'd like to avoid the common pitfall of using SQLite for development and PostgreSQL for production referenced in Two Scoops of Django. I'd like to take this a ...
Scott Skiles's user avatar
5 votes
1 answer
1k views

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 ...
krystah's user avatar
  • 747
4 votes
2 answers
3k views

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: ...
Marcello Miorelli's user avatar
3 votes
1 answer
1k views

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 ...
kovalad's user avatar
  • 51
3 votes
3 answers
149 views

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 ...
Jeff Bauersfeld's user avatar
0 votes
1 answer
1k views

SQL Server - Data Warehouse large log file, how to safely shrink?

My DW database is about 20GB size in data file and nearly 120GB in log file. Data staleness is until midnight (so "yesterday's news") and multiple databases are being replicated daily from ...
AcePL's user avatar
  • 349
2 votes
1 answer
588 views

Split SSIS project in to multiple files to avoid merge hell

Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of ...
Sam Segers's user avatar
1 vote
2 answers
2k views

How to set up development servers SQL Server

My .NET development team has been massively restructured recently, and as a result of the restructure, we now have the ability to do things like set up source control and database backups, and ...
Kristen Hammack's user avatar
2 votes
1 answer
545 views

Logical condition when declaring handler procedure

I have a procedure in MySQL that executes a handler for SQLEXCEPTION to read the errno code and insert it to a table. DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN GET DIAGNOSTICS CONDITION 1 @...
tachomi's user avatar
  • 313
4 votes
1 answer
908 views

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 ...
Stefan Falk's user avatar
2 votes
1 answer
1k views

Laravel MySQL relation difficulties

I have a "users" table: And an organisations table ("orgs"): And this is the pivot table: I have some relations: On the "users" table, I have a function called "orgs()" which is a belongsToMany ...
Eamorr's user avatar
  • 125
3 votes
1 answer
1k views

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, ...
Christopher's user avatar
0 votes
2 answers
72 views

sync 2 tables in a single database in mysql with no duplicacy [closed]

I have 2 tables in a single database of MySQL. The structures are like this: mysql> desc main_tbl; +-----------------+--------------+------+-----+-------------------+----------------+ | Field ...
kumarprd's user avatar
  • 117
0 votes
1 answer
73 views

Who should own the staging database right

At my company we are re-assessing which developers will take on the deployment for xyz ticket. At the moment when a developer is done with his ticket, a deployment ticket is created and another ...
Gabtheviking's user avatar
2 votes
2 answers
5k views

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 ...
Agi Hammerthief's user avatar
2 votes
2 answers
3k views

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 ...
pheidlauf's user avatar
  • 131
1 vote
0 answers
57 views

Help understanding SQL Server Developer License when users test via webserver [duplicate]

I'm trying to understand how many licenses I may need if we decide to pursue a SQL Server Developer license for our Testing environment. We would have 5 actual developer and DBA's physically ...
ProfessionalAmateur's user avatar
0 votes
1 answer
116 views

How to organize a development environment using Oracle XE 11g?

I started developing small applications using Oracle XE 10g/11g using APEX. They are intented to be run on desktop computers that acts as a server in small offices. Oracle XE is well suited for those ...
user34941's user avatar
1 vote
0 answers
1k views

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
Fulproof's user avatar
  • 1,392
1 vote
1 answer
201 views

Remote SSIS development

I'm currently developing SSIS packages which include transferring data between two servers. The servers are in the same local LAN, but I'm remote to them. Is there any way that I can develop the ...
Evan M.'s user avatar
  • 231
0 votes
1 answer
3k views

AdventureWorks2012: "The FILE SIZE property is incorrect" error while trying to attach sample database "Adventure Works for SQL Server 2012"

I am trying to attach the sample databases, for example, AdventureWorks2012_Data.mdf from codeplex "Adventure Works for SQL Server 2012" into a MS SQL Server 2012 (default) instances on a a virtual ...
Fulproof's user avatar
  • 1,392
2 votes
1 answer
79 views

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 ...
Dina's user avatar
  • 1,507
2 votes
2 answers
416 views

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 ...
blachniet's user avatar
  • 121
1 vote
1 answer
1k views

How to sync a table between oracle and sybase

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 ...
AmmarR's user avatar
  • 2,816
1 vote
2 answers
4k views

How to update SQL Server 2012 from Evalutation to Developer edition?

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 ...
Ucodia's user avatar
  • 111
1 vote
2 answers
175 views

Is this an appropriate development environment MySQL backup strategy?

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 ...
msanford's user avatar
  • 164
8 votes
2 answers
1k views

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 ...
Κύριε ἐλέησον's user avatar
14 votes
1 answer
8k views

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 ...
Derek Downey's user avatar
  • 23.5k
2 votes
3 answers
12k views

Easy or Schedulable way to move data from Production to Test

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 ...
Nate's user avatar
  • 1,707
20 votes
7 answers
22k views

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 ...
p mac's user avatar
  • 201