Tag
6 articles
'X' scripting variable not defined - what sqlcmd is doing with $( in your strings, what I tested (the script keeps running with exit code 0, and environment variables rewrite your data silently), and when to use -x, CHAR(36) or single quotes.
'UPDATE failed because the following SET options have incorrect settings: QUOTED_IDENTIFIER' - why the same statement works from your app and fails from sqlcmd, what I tested on SQL Server 2022, and the one-line fixes for scripts, sqlcmd and stored procedures.
Three different SQL Server errors, one root cause: your migration files and the __EFMigrationsHistory table disagree about what has been applied. Here is the query that shows you the disagreement, and the fix for each of the three ways it happens.
An index is how reads survive scale; idempotency is how writes survive retries. What each one fixes, why composite column order decides everything, why an idempotency key needs a UNIQUE constraint, and the migration-history failure where both ideas meet.
EF Core projections, tagged output caching and batched writes - the seven changes that made a real Web API fast on a slow database link.
ASP.NET Core runs on Linux, and so does SQL Server. Here is how to tell which .NET you are on, and how much RAM and storage each option really needs.
