Questions tagged [sql-server]
SQL Server is a relational database management system from Microsoft.
33 questions with no upvoted or accepted answers
4
votes
1
answer
325
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
0
answers
556
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
0
answers
169
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 ...
2
votes
0
answers
131
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 ...
2
votes
0
answers
4k
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, ...
2
votes
0
answers
156
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
0
answers
98
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] ...
2
votes
0
answers
299
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 ...
1
vote
0
answers
2k
views
The most "correct" way of detecting changes to a database
We have a few 100's lines of code, that according to some complex logic decides if certain columns of certain entities should be updated from some legacy system.
Those columns don't necessarily get ...
1
vote
0
answers
58
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
0
answers
413
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 ...
1
vote
0
answers
41
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
0
answers
74
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
1
answer
186
views
How to test load balanced ASP Core based website?
I have a simple ASP Core based website that is connected to my local SQL Server Express, some of the third party plugins used, do have reliance on other products i.e. scheduling timers.
I would like ...
0
votes
0
answers
279
views
SQL Database design for reusable components and classes
I am working on a small suite of enterprise applications, and I am trying to determine the best way to make them more consistent and maintainable across the board. The applications are .Net Blazer ...