Questions tagged [sql-server]
SQL Server is a relational database management system from Microsoft.
360 questions
8
votes
4
answers
2k
views
Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
When using Entity Framework and running the Update-Database command, non-updated applications that rely on the database crash due to database context changes.
Usually teams have a production database ...
- 795
0
votes
1
answer
144
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 ...
- 109
2
votes
2
answers
162
views
Could concurrent user-triggered data fetches and inserts lead to deadlocks in a multi-user ASP.NET Core + MSSQL application?
I'm facing a tricky situation that might result from a not thoroughly thought-out design, and I'm hoping to understand whether a deadlock might be a realistic cause – and if so, how to prevent similar ...
1
vote
1
answer
281
views
Does SQL Server Agent predate Windows Task Scheduler?
An old guru once told me that SQL Server Agent was created because Windows Task Scheduler did not exist at the time. However, all of my research shows that they both released in 1995. For Task ...
- 1,015
0
votes
2
answers
239
views
Testing C# app backed by MSSQL database and Entity Framework - seeking advices for going with "test double" approach
I am new to C#, and Windows (coming from Python, Linux background). I need to add tests
to an existing C# codebase, which relies on a MSSQL database and Entity Framework.
In my old days when testing ...
- 226
1
vote
3
answers
829
views
Creating Unit and Integration Tests with Database elements
This is something that I've heard a number of opinions and theories about, but I'm still torn on how to go forward.
For context, this particular issue deals with the following technologies, in case ...
- 323
2
votes
2
answers
194
views
Do we have 2 logical query processings, one with indexes and one without indexes?
In the book "Inside Microsoft® SQL Server® 2008: T-SQL Programming" the behaviour of a sql query is explained. The following picture is taken from the book. I have some questions about the ...
- 29
0
votes
1
answer
344
views
How to organize "master" data VS "working" data in MS SQL
I have this survey software that I'm writing and I'm wondering what would be the best design for my requirement.
I'm going to simplify it as best as I can.
I have these entities:
class Survey {
...
- 109
0
votes
0
answers
248
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 ...
- 111
-1
votes
1
answer
494
views
PowerApps with SharePoint Versus ASP.NET core with SQL Server
I have around 6 years of experience in SharePoint, ASP.NET MVC, ASP.NET Core MVC & SQL Server. Now when I want to take a decision, if the project should be implemented using SharePoint/PowerApps ...
35
votes
6
answers
10k
views
SQL as a means of avoiding "releases"
The system I'm working on started as a small training project within the company I work for but quickly caught interest from management as a means to help to standardize the existing excel-heavy ...
- 467
0
votes
3
answers
133
views
How to avoid data corruption with dual parent/child foreign keys
Imagine the following:
Persons table: (Id, FirstName, LastName)
PersonEmails table: (Id, PersonId, Address) (to allow a person to have multiple emails)
Contacts table: (Id, PersonId, UnsubscribeAll) (...
- 175
-2
votes
2
answers
246
views
How to filter and concatenate multiple sql files into one database [closed]
I have an issue where I have multiple databases from previous projects that I would like to combine into one large database. These databases are stored in .sql files. The issue is that I only need ...
- 7
-1
votes
1
answer
98
views
multiple products db structure in mssql
I am looking for a better approach to add multiple products to my db.
(things I have tried)
Example 1
[table
Products - ProductId pk(
ProductId,ItemCode,Price,ProductType)..]
[table 2
Frame - ...
- 17
-3
votes
1
answer
151
views
Where should linking tables be stored? [closed]
I have a system where properties can be stored, and linked with multiple other entities (each with their own schema). Let's say that Documents can be linked with Users and Assets. What is the best ...
- 191