LLuís Santos·Nov 10From Oracle Autonomous Database to SQL Server: Exploring DB_LINK and Oracle Database GatewayTesting 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
DDaniel Davis·Nov 9SaveChanges shouldn't take four seconds to insert 100,000 rowsUpdate, 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 now7 min read·danieldavisdev.hashnode.dev
KKausar Raza·Nov 8TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL ServerWe 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 for9 min read·knowledgemarkg.hashnode.dev
RRavi Sah·Nov 5How to Stop Deadlocks in SQL Server: 5 Production Patterns and Their FixesHow 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 Er6 min read·prodsolutions.hashnode.dev
KKausar Raza·Nov 2sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix ItWhy 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
AAlex Morgan·Oct 29How to Investigate Unexpected SQL Server Data Changes Using Transaction LogsLearn 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
AAtash Das·Oct 15SAP Disaster Recovery Architecture — When Each Tool Earns Its PlaceWhitepaper | SAP | AWS | Cloud Architecture | Disaster Recovery11 min read·atashdas.hashnode.dev
Sspipaliya8·Oct 12EF Core Any vs Count: Which One Is Better for Existence Checks?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
NNahid Mahmud·Oct 2My SQL Learning Journey: Day 1 & Day 2 — Mastering SELECT & ConstraintsJoin my SQL learning journey as I break down the fundamentals of database queries. In Day 1 and Day 2, we explore basic6 min read·nahid-mahmud555.hashnode.dev1
DDan Weaver·Oct 1Hybrid code search on Azure SQL and SQL Server 2025, end to endRoslyn 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