---
title: "#sql-server articles | Hashnode"
description: "Explore 848 articles tagged #sql-server on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/sql-server"
---

Tag

# #sql-server

848 posts · 1,269 followers

[Luís Santos](https://hashnode.com/@lmsantos) · [Nov 10](https://hashnode.com/posts/from-oracle-autonomous-database-to-sql-server-exploring-db-link-and-oracle-database-gateway/6af278cc30c462a9cc81da36)

### [From Oracle Autonomous Database to SQL Server: Exploring DB\_LINK and Oracle Database Gateway](https://lslabsessions.hashnode.dev/from-oracle-autonomous-database-to-sql-server-exploring-db-link-and-oracle-database-gateway?utm_source=hashnode&utm_medium=feed)

Testing queries, DML and stored procedure calls from Oracle Autonomous Database to SQL Server using database links and Oracle Database Gateway.

3 min read · [lslabsessions.hashnode.dev](https://lslabsessions.hashnode.dev/from-oracle-autonomous-database-to-sql-server-exploring-db-link-and-oracle-database-gateway?utm_source=hashnode&utm_medium=feed)

[Daniel Davis](https://hashnode.com/@danieldavisdev) · [Nov 9](https://hashnode.com/posts/savechanges-shouldn-t-take-four-seconds-to-insert-100-000-rows/6af248d97b0f24fed3e39763)

### [SaveChanges shouldn't take four seconds to insert 100,000 rows](https://danieldavisdev.hashnode.dev/savechanges-shouldn-t-take-four-seconds-to-insert-100-000-rows?utm_source=hashnode&utm_medium=feed)

Update, 1.0.3: ADO.NET update and delete now take a SqlTransaction, DbSet<T> gets BulkSyncAsync, UpdateOnlyIfChanged skips unchanged rows, the UpdateInsert merge strategy is available, and ADO.NET now

7 min read · [danieldavisdev.hashnode.dev](https://danieldavisdev.hashnode.dev/savechanges-shouldn-t-take-four-seconds-to-insert-100-000-rows?utm_source=hashnode&utm_medium=feed)

[Kausar Raza](https://hashnode.com/@knowledgemarkg) · [Nov 8](https://hashnode.com/posts/tcp-provider-the-wait-operation-timed-out-it-was-the-firewall-not-sql-server/6af00a47081b90e95026e1a5)

### [TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server](https://knowledgemarkg.hashnode.dev/tcp-provider-the-wait-operation-timed-out-it-was-the-firewall-not-sql-server?utm_source=hashnode&utm_medium=feed)

We moved this site's database to a new SQL Server, and the first time I tried to connect from my own PC, sqlcmd sat for a few seconds and then printed this: Sqlcmd: Error: Microsoft ODBC Driver 17 for

9 min read · [knowledgemarkg.hashnode.dev](https://knowledgemarkg.hashnode.dev/tcp-provider-the-wait-operation-timed-out-it-was-the-firewall-not-sql-server?utm_source=hashnode&utm_medium=feed)

[Ravi Sah](https://hashnode.com/@ravisah) · [Nov 5](https://hashnode.com/posts/how-to-stop-deadlocks-in-sql-server-5-production-patterns-and-their-fixes/6aec5ecf437a2bd63b6b5717)

### [How to Stop Deadlocks in SQL Server: 5 Production Patterns and Their Fixes](https://prodsolutions.hashnode.dev/how-to-stop-deadlocks-in-sql-server-5-production-patterns-and-their-fixes?utm_source=hashnode&utm_medium=feed)

How to Stop Deadlocks in SQL Server: 5 Production Patterns and Their Fixes We’ve all been there: a production application suddenly stumbles, errors spike, and your telemetry logs reveal the dreaded Er

6 min read · [prodsolutions.hashnode.dev](https://prodsolutions.hashnode.dev/how-to-stop-deadlocks-in-sql-server-5-production-patterns-and-their-fixes?utm_source=hashnode&utm_medium=feed)

[Kausar Raza](https://hashnode.com/@knowledgemarkg) · [Nov 2](https://hashnode.com/posts/sqlcmd-scripting-variable-not-defined/6ae84437e90ccdf33c30ffd5)

### [sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix It](https://knowledgemarkg.hashnode.dev/sqlcmd-scripting-variable-not-defined?utm_source=hashnode&utm_medium=feed)

Why sqlcmd says 'scripting variable not defined', why the script still runs with exit code 0, how environment variables silently rewrite $( text, and the fixes.

11 min read · [knowledgemarkg.hashnode.dev](https://knowledgemarkg.hashnode.dev/sqlcmd-scripting-variable-not-defined?utm_source=hashnode&utm_medium=feed)

[Alex Morgan](https://hashnode.com/@alexmo) · [Oct 29](https://hashnode.com/posts/how-to-investigate-unexpected-sql-server-data-changes-using-transaction-logs/6ae3147fd990c6f964375642)

### [How to Investigate Unexpected SQL Server Data Changes Using Transaction Logs](https://sql-database-insights.hashnode.dev/how-to-investigate-unexpected-sql-server-data-changes-using-transaction-logs?utm_source=hashnode&utm_medium=feed)

Learn how to investigate SQL Server transaction logs, trace unexpected data changes, preserve evidence, and evaluate recovery options.

8 min read · [sql-database-insights.hashnode.dev](https://sql-database-insights.hashnode.dev/how-to-investigate-unexpected-sql-server-data-changes-using-transaction-logs?utm_source=hashnode&utm_medium=feed)

[Atash Das](https://hashnode.com/@atashdas) · [Oct 15](https://hashnode.com/posts/sap-disaster-recovery-architecture-when-each-tool-earns-its-place/6ad0a17adb151624652751d5)

### [SAP Disaster Recovery Architecture — When Each Tool Earns Its Place](https://atashdas.hashnode.dev/sap-disaster-recovery-architecture-when-each-tool-earns-its-place?utm_source=hashnode&utm_medium=feed)

Whitepaper | SAP | AWS | Cloud Architecture | Disaster Recovery

11 min read · [atashdas.hashnode.dev](https://atashdas.hashnode.dev/sap-disaster-recovery-architecture-when-each-tool-earns-its-place?utm_source=hashnode&utm_medium=feed)

[spipaliya8](https://hashnode.com/@spipaliya) · [Oct 12](https://hashnode.com/posts/ef-core-any-vs-count-which-one-is-better-for-existence-checks/6accd3086f31e7b96fe57492)

### [EF Core Any vs Count: Which One Is Better for Existence Checks?](https://sudhirpipaliya.hashnode.dev/ef-core-any-vs-count-which-one-is-better-for-existence-checks?utm_source=hashnode&utm_medium=feed)

Learn the difference between EF Core AnyAsync() and CountAsync() for existence checks, SQL translation, performance, indexes, and best practices.

6 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/ef-core-any-vs-count-which-one-is-better-for-existence-checks?utm_source=hashnode&utm_medium=feed)

[Nahid Mahmud](https://hashnode.com/@nahidmahmud555) · [Oct 2](https://hashnode.com/posts/my-sql-learning-journey-day-1-day-2-mastering-select-constraints/6abfd323de144e5252f8faa9)

### [My SQL Learning Journey: Day 1 & Day 2 — Mastering SELECT & Constraints](https://nahid-mahmud555.hashnode.dev/my-sql-learning-journey-day-1-day-2-mastering-select-constraints?utm_source=hashnode&utm_medium=feed)

Join my SQL learning journey as I break down the fundamentals of database queries. In Day 1 and Day 2, we explore basic

6 min read · [nahid-mahmud555.hashnode.dev](https://nahid-mahmud555.hashnode.dev/my-sql-learning-journey-day-1-day-2-mastering-select-constraints?utm_source=hashnode&utm_medium=feed)

[Dan Weaver](https://hashnode.com/@disisnoturbusiness) · [Oct 1](https://hashnode.com/posts/hybrid-code-search-on-azure-sql-and-sql-server-2025-end-to-end/6abe61b918246e24ebf783e2)

### [Hybrid code search on Azure SQL and SQL Server 2025, end to end](https://danweaver.hashnode.dev/hybrid-code-search-on-azure-sql-and-sql-server-2025-end-to-end?utm_source=hashnode&utm_medium=feed)

Roslyn chunking, DiskANN, RRF across three retrieval legs and a cross-encoder, on native VECTOR columns. Including the two VECTOR\_SEARCH grammars.

11 min read · [danweaver.hashnode.dev](https://danweaver.hashnode.dev/hybrid-code-search-on-azure-sql-and-sql-server-2025-end-to-end?utm_source=hashnode&utm_medium=feed)
