All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
2answers
80 views

Downloading and appending data from AWS S3 whilst avoiding clashes

I have to upload a TSV file to an S3 bucket, the content is form submission data. Another service will consume and do things with this data as soon as possible. The service would like one large file ...
1
vote
1answer
80 views

How to work with multiple databases efficiently (Development, Testing & Production)

Brief background I'm currently designing a COM DLL in .NET for use in MS Access by a few other developers. The Access application is hooked up to a SQL-Server & is supposed to just act as a front-...
0
votes
3answers
355 views

How can I interpret a SQL Check Constraint inside my C# .NET class libary?

I was given a more or less complex task. The goal is to interpret a SQL Check Constraint inside my C# .NET libary. In our case we have a simple UI that displays what is inside the database. We do not ...
3
votes
1answer
115 views

Regulations about collecting data from software running at clients hardware (apps 'phoning home') [closed]

We develop an application which has now been installed on a few thousand customers sites. Unfortunately, we have no customer data collection built into the software. This is something we want to ...
0
votes
1answer
57 views

Store nested object from .net to a SQL Server

I build an object in vb.net where I store data from JSON file that I get from a RESTApi. The object is nested and looks like this: Public Class FullData Public Property userID As ULong Public ...
-1
votes
1answer
83 views

.NET Sort concurrent requests into a queue

I asked this at Stack Overflow but seeing as it wasn't so much a programming issue as a theory issue it wasn't well received. I have a program that issues a unique ascending code every time one is ...
1
vote
1answer
97 views

Sql server to PHP (api vs library)

Our agency is currently using and maintaining the CMS we have developed in .net MVC on SQL server. Since the cms is highly optimized and uses various cache tables to run very fast even with thousand ...
0
votes
1answer
66 views

What is the best way to store author of change and display changes of every column in temporal table in SQL Server?

I would like to store history of changes in table and also remember author of change. I created temporal table. This table contains ChangeAuthorId column which value I update every time when table is ...
0
votes
3answers
576 views

Excute Procedure in Parallel or Async

I have inherited an application which performs approximately 100,000 executions in a C# for-loop against SQL Server. for (int i=0; i<100000; i++) { //Execution can take 0.250 to 5 seconds to ...
2
votes
0answers
115 views

Better dynamic user permissions

I support an Internal ERP system and an external Reporting/Dashboard that our customers use that both use the same database. Internal normal application users can control what customers can access ...
2
votes
2answers
2k views

can a single SQL Server connection be shared among tasks executed in parallel

Can a single SQL Server connection be shared among tasks executing in parallel? Each task would dequeue an item from a ParallelQueue, instantiate a SqlClient command, and insert a row into the table. ...
2
votes
1answer
592 views

SQL - Designing a Threshold value table

I need to design an SQL table to be used for "threshold" or special values, which in general would have the following properties: - key - value - comparer (less than and greater than as a start, ...
3
votes
1answer
2k views

Is there a better way to update NoSQL records in bulk?

When we started our application we had the choice of going with the traditional MS-SQL normalized database or with a NoSQL database (RavenDB is what we tried out). Here is a simplified version of our ...
2
votes
0answers
220 views

Software License for project using .NET and Sql Server Express

I considering making my application open source on github. I don't intend to sell it (neither in binary form nor source code form). It probably isn't even useful to a lot of people except maybe for ...
6
votes
1answer
3k views

Is Entity Framework 6 agnostic enough different sql server and OS platforms?

It's my first time using sql server, I usually go with MySQL, so I'm unsure how to do this. The project I'm assigned will be deployed to multiple platforms particularly PC's with different SQL server ...
1
vote
1answer
217 views

Design: Mixed XML / Relational or Pure Relational?

Is it acceptable to model a very complex object graph using XML in the database, but leave the rest of a system in relational tables? I'd like to gauge opinion on this as I've hit a bit of a ...
3
votes
2answers
3k views

Data Transfer Best Practices

At my company we have some vendors that we transfer data to and from. Sometimes the data is pulled into our local SQL database for business reporting. Other times we pull data from one vendor, ...
1
vote
4answers
2k views

How to factor out data layer in nopCommerce and replace MS SQL with RavenDB?

I am new to nopCommerce and ecommerce in general but I am involved in an ecommerce project. Now from my past experiences with RavenDB (which mostly were absolutely pleasant) and based on the needs of ...
-1
votes
2answers
2k views

SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
0
votes
2answers
238 views

Should I retrieve one large set of data to filter or smaller individual sets of data?

I have a company intranet that utilizes a similar set of data across many different pages and many different methods. Speaking in generalities, is it closer to "best practice" to retrieve a large ...
4
votes
3answers
1k views

Why should I add CHECK CONSTRAINT?

Following is a table creating script created by Entity Framework using the model shown in https://codereview.stackexchange.com/questions/14077/is-it-proper-tpt-inheritance. In this script, there are ...
4
votes
5answers
4k views

I feel unprepared to start my first job out of college… how can I improve? [closed]

I just graduated from university with a degree in Computer Science/Engineering and was fortunate enough to land a job working in the pharmaceutical industry as a developer. My title is System ...
3
votes
6answers
2k views

How to include database changes during application publish

I am maintaining a WinForms application, which talks to a SQL Server database. Sometimes I have to change database schema (for example to alter a sql procedure or add new one). For this purpose I have ...
0
votes
1answer
138 views

migration and interoperability

A large system has already been done in visual fox pro. They want to add more requirements to a module and make some changes to the system.At the same time they are thinking about migration to .net. ...
6
votes
3answers
3k views

Is the Entity Framework appropriate when all you do is insert records in bulk?

My department develops software to migrate databases for our customers from their old CRM software to ours. In this process we could be inserting up do millions of rows, processed one at a time as we ...
0
votes
4answers
1k views

Comparing Visual Foxpro with .NET

I used Foxpro 2.6 a decade ago. In my present company, few new projects are being developed in Visual Foxpro 9.0 and few projects are on .NET platform. From time-to-time I notice how Visual Foxpro is ...
3
votes
2answers
566 views

Pros/Cons for a Data Structure covering multiple databases?

I'm about to extend a system containing two separate systems. Or domains, if we see the system as a domain level. Today One domain is used internally. The other is public, which means it is more ...
2
votes
1answer
124 views

How to find a scaling expert?

The web application is in ASP.NET and Sql Server and is growing much faster than anticipated. Where can I find an expert who has previously had experience of going from a small website to solution ...