Questions tagged [sql-server]
SQL Server is a relational database management system from Microsoft.
26
questions with no upvoted or accepted answers
7
votes
5answers
2k views
Write data to SQL Server directly from BizTalk or use external service?
An external source will be sending us XML data that BizTalk will pick up and transform into an internal schema. We need this data to be loaded into a SQL Server database as we're going to expose some ...
4
votes
0answers
2k views
ElasticSearch vs SQL Server full text index for small datasets?
I've got a relatively high-traffic public-facing product-based website backed by SQL Server as the point of authority. It has some search capability on some of the columns of the Items table (year, ...
4
votes
1answer
234 views
How to set up a sql database to cater for user records, group records and default records?
Outline
I have an application that loads data from a database. I'm not talking about client data here though, I'm talking about application configuration. The database will therefore come with some ...
4
votes
1answer
242 views
.NET DataSource binding for legacy SQL Server DB with undefined relationships
I'm designing a utility that will load data into a legacy SQL Server Database.
I've been trying to mock up a simple WinForms utility with C# using the DataSource connectors (Tried a straight ORM ...
3
votes
1answer
282 views
Using Active Directory ObjectSid as Primary Key in SQL Server for Data Access via ASP.NET MVC
I am designing an Intranet employee reward web app using ASP.NET MVC C#/MS SQL Server. This will only be accessed from within the network.
Employees and managers will be able to give a reward to ...
3
votes
0answers
441 views
ODBC 3 Multiple Statements vs Multiple Connections
So right now I have a single thread to handle all the requests for the database. Let's say I have 400 requests per second for logins / logouts / other stuff, and 400 requests per second which are only ...
3
votes
0answers
131 views
Integrate MS Dynamics AX with Play Framework
In my company we use MS Dynamics AX 2009. This is the ERP of the company. We have around 100 users. The servers of MS Dynamics AX are in the headquarters company.
We are developping a new website ...
3
votes
0answers
224 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 ...
2
votes
0answers
287 views
Replication between SQL server and Couchbase Lite
We have a main MS Sql server. This is the main data source that delivers and receives data to and from backend administration and (in development) mobile software. We need to make a connection to ...
2
votes
0answers
117 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
0answers
66 views
SQL - Locating closest value in a set
I have a table that contains the percentiles from a reference data set.
CREATE TABLE [Core].[RiskFactor](
[SpecialtyCode] [char](2) NOT NULL,
[RiskCategoryId] [int] NOT NULL,
[Percentile] [tinyint] ...
1
vote
0answers
27 views
How to create and store many statistics in SQL Server for Reporting Purposes
I have a C# Program that creats PowerPoint reports filled with statistics of a chosen (by the project manager who operates with the tool) company (each one has a companyID).
The statistics are ...
1
vote
0answers
67 views
Disaster Recovery Database Switchover options
Some info on the current setup:
We're currently using database replication - transactional replication, to be specific - between 2 servers. For sake of this post, we are replicating from a PRIMARY to ...
1
vote
0answers
2k views
Entity Framework naming conventions for the same table name across multiple schemas
The DbContext of my application's Entity Framework setup (which I will refer to as ApplicationContext, the name of our derived type) contains classes for all of the tables in our SQL Server database, ...
1
vote
0answers
32 views
Offsetting high usage in a multi-tenant database environment?
I'm writing a research essay over distributed cloud-based systems, and one of the topics that I'm trying to touch on is potential solutions to high database utilization in a single-database multi-...
1
vote
0answers
54 views
Managing shared storage in a high availability environment
I have an application with a custom high availability (HA) feature that provides automatic failover from an active primary server that experiences a failure to a passive backup server. To date, this ...
0
votes
0answers
34 views
Creating webhooks for a third-party application
First post here on Software Engineering, so I hope I don't goof up too much.
I am writing software that integrates with an application written by a company that has a small development team. I have ...
0
votes
0answers
48 views
How to pass data from Java to display in SSRS?
I have a Java application that uses an 3rd party Java library to get data remotely. Specifically, a start date, end date and a few other search parameters can be passed to a library call and it will ...
0
votes
0answers
113 views
Real-time application and RDBMS bottleneck
I'm currently developing a real-time application using .NET Core 2.2. Many IOT devices (could be up to 100) are concurrently sending messages via MQTT. These messages are parsed, elaborated to extract ...
0
votes
0answers
349 views
.NET WPF Best way to store a connection credential
I have an application that connects to SQL Server using windows credentials, which works very well for the domain paradigm. The client is now transitioning away from having a domain server, and is ...
0
votes
0answers
29 views
Source control Sql Server multiple shards with minimal differences
One of the database systems I work with (I'll call it database A) was essentially sharded into 3 schema-identical copies. This was easy to source control, and when a change was made to any of the ...
0
votes
1answer
320 views
Round robin, balanced home/away, multiple locations with multi-team options
This is my first question on this forum, have tried to exhaust every possible research option I could think of or find. Actually this is the first time I've posted for help with this anywhere, so ...
-1
votes
1answer
36 views
MSSQL client server architecture
BASIC QUESTION: We have a small application that uses a MSSQL database to save data. We want to use Windows-Authentification to allow each client (15 in total) to connect to the database to write/read ...
-1
votes
1answer
631 views
ASP.NET - Data Encryption & Decryption framework designs
I have the following app scenario where i would need to implement the cell-level encryption.
Database - MS SQL Server
Web Technology - ASP.net MVC
Existing app scenario:- Currently the web ...
-1
votes
1answer
721 views
Migrating MYSQL functions and stored procedures to SQL Server
The company i'm working for is selling HRIS management software. It was built using ASP and mysql. But one of our client's demand is for it to be based on MS SQL Server. our team is made up mostly of ...
-1
votes
2answers
942 views
Nullable foreign keys and creating join tables
I'm not that experienced in sql modeling and i'm looking for input on this because it's important for me to get it right. I use mssql and entityframework core in an asp.net core web app.
The app ...
