Tag feed

#sql-server

766 posts1,269 followers

Trending tags this week

Handling Concurrency using EF Core (optimistic approach)

1d ago · 2 min read · Why does EF Core handle concurrency using the optimistic approach? Browsing through the documentation you will see that handling concurrency conflicts on EF Core is handled by implementing optimistic

Join discussion

RRRino Reji Cheriyanblog.rinoreji.in

0

Fetch the DB Object Backed by an External Database

1d ago · 1 min read · SELECT OBJECT_SCHEMA_NAME(d.referencing_id) AS referencing_schema, OBJECT_NAME(d.referencing_id) AS referencing_object, o.type_desc AS referencing_type,

Join discussion

KPKPI Partnerskpipartners.hashnode.dev

0

SQL Server to Snowflake Migration: Architecture, Challenges, and a Scalable Modernization Approach

Apr 2 · 5 min read · SQL Server has been a cornerstone of enterprise data systems for years. It has powered reporting, analytics, and operational workloads reliably across industries. But modern data demands real-time ana

Join discussion

SKSANDEEP KUMAR RAJU SANGARAJUdatatrail.hashnode.dev

0

Taming the Beast: A DBA's Playbook for Conquering Billion-Row Performance Bottlenecks Between SQL Server and Power BI

Mar 21 · 21 min read · Reading time: ~18 minutes The Problem Nobody Warns You About You've built the perfect dimensional model. Your star schema is textbook. Fact tables are normalized, dimensions are conformed, and the ET

Join discussion

DMDewa Mahendradewa-mahendra.hashnode.dev

0

Building a Native AOT .NET API with Dapper AOT

Mar 16 · 5 min read · Modern backend systems demand fast startup, low memory usage, and container-friendly architectures. One interesting combination in the .NET ecosystem is Native AOT + Dapper.AOT, which allows building

Join discussion

KSKay Sauterkayondata.com

0

Publishing Powershell Azure SQL VM Toolkit

Mar 8 · 6 min read · In 2021, I wrote a PowerShell script to automate most of the steps for deploying a SQL Server VM on Azure, but not everything. Also back then, the whole deployment process with the script took almost

Join discussion

PPPayal Porwalcodeswithpayal.hashnode.dev

0

Master the Top SQL Queries: Clear Explanations + Practical Examples

Feb 24 · 5 min read · 1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u

Join discussion

NVNguyễn Việt Tùngdevpath-traveler.nguyenviettung.id.vn

0

Passwordless: What Worked, What Didn’t, What I’d Change

Feb 19 · 5 min read · When designing a passwordless-first PWA architecture, the diagram looks elegant. In production, elegance collides with: Browser inconsistencies Institutional identity constraints Support tickets Device lifecycle chaos Monitoring blind spots Le...

Join discussion

NVNguyễn Việt Tùngdevpath-traveler.nguyenviettung.id.vn

0

Implementing WebAuthn in Practice

Feb 17 · 7 min read · WebAuthn looks deceptively simple at a high level: Generate challenge Call browser API Verify signature Done In practice, it is not that simple. WebAuthn is cryptographically elegant but operationally unforgiving.Small mistakes create subtle se...

Join discussion

NVNguyễn Việt Tùngdevpath-traveler.nguyenviettung.id.vn

0

Passwordless PWA Flow Architecture Walkthrough

Feb 16 · 6 min read · Modern authentication diagrams are clean. Real systems are not. My architecture intentionally combines: WebAuthn (FIDO2) for phishing-resistant authentication Feide (OIDC) for federated identity, recovery, and bootstrap SQL Server for credential p...

Join discussion

#sql-server

Search Hashnode

#sql-server

Trending tags this week

Handling Concurrency using EF Core (optimistic approach)

Fetch the DB Object Backed by an External Database

SQL Server to Snowflake Migration: Architecture, Challenges, and a Scalable Modernization Approach

Taming the Beast: A DBA's Playbook for Conquering Billion-Row Performance Bottlenecks Between SQL Server and Power BI

Building a Native AOT .NET API with Dapper AOT

Publishing Powershell Azure SQL VM Toolkit

Master the Top SQL Queries: Clear Explanations + Practical Examples

Passwordless: What Worked, What Didn’t, What I’d Change

Implementing WebAuthn in Practice

Passwordless PWA Flow Architecture Walkthrough