--- title: "#sqlserver articles | Hashnode" description: "Explore 23 articles tagged #sqlserver on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/sqlserver" --- Tag # #sqlserver 23 posts · 1 followers [Raul Naupari](https://hashnode.com/@raulnq) · [Sep 25](https://hashnode.com/posts/migrating-sql-server-to-postgresql-with-aws-dms-a-hands-on-guide-for-c-developers/6ab6e3ba67f59ce0367a4897) ### [Migrating SQL Server to PostgreSQL with AWS DMS: A Hands-On Guide for C# Developers](https://blog.raulnq.com/migrating-sql-server-to-postgresql-with-aws-dms-a-hands-on-guide-for-c-developers?utm_source=hashnode&utm_medium=feed) Introduction The problem Moving a production database from one engine to another looks simple on a whiteboard: read every row from the old database and write it to the new one. In practice, a naive ap 44 min read · [blog.raulnq.com](https://blog.raulnq.com/migrating-sql-server-to-postgresql-with-aws-dms-a-hands-on-guide-for-c-developers?utm_source=hashnode&utm_medium=feed) [qodors](https://hashnode.com/@qodors) · [Sep 9](https://hashnode.com/posts/still-writing-slow-sql-queries-10-ways-to-improve-performance/6aa157436330131f69d3c0d8) ### [Still Writing Slow SQL Queries? 10 Ways to Improve Performance](https://qodors.hashnode.dev/still-writing-slow-sql-queries-10-ways-to-improve-performance?utm_source=hashnode&utm_medium=feed) A SQL query can be correct and still be inefficient. Learn how to identify unnecessary database work and improve query performance. 7 min read · [qodors.hashnode.dev](https://qodors.hashnode.dev/still-writing-slow-sql-queries-10-ways-to-improve-performance?utm_source=hashnode&utm_medium=feed) [Tech Vidya](https://hashnode.com/@techvidya0726) · [Aug 28](https://hashnode.com/posts/sql-server-performance-tuning/6a91b84bec3883583130cd26) ### [Sql Server Performance Tuning](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) SQL Server is slow. What do you check FIRST? 2 min read · [techvidyaaim.hashnode.dev](https://techvidyaaim.hashnode.dev/sql-server-performance-tuning?utm_source=hashnode&utm_medium=feed) [spipaliya8](https://hashnode.com/@spipaliya) · [Jul 21](https://hashnode.com/posts/the-hidden-danger-of-max-1-logic-in-enterprise-applications/6a5f4c51f0109ef7c0190471) ### [The Hidden Danger of MAX()+1 Logic in Enterprise Applications](https://sudhirpipaliya.hashnode.dev/the-hidden-danger-of-max-1-logic-in-enterprise-applications?utm_source=hashnode&utm_medium=feed) MAX()+1 looks simple but can create race conditions and duplicate records. Learn safer approaches for reliable database design. 6 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/the-hidden-danger-of-max-1-logic-in-enterprise-applications?utm_source=hashnode&utm_medium=feed) [spipaliya8](https://hashnode.com/@spipaliya) · [Jul 16](https://hashnode.com/posts/why-asnotracking-can-improve-ef-core-performance/6a58c493f1ffe15d726955ec) ### [Why AsNoTracking Can Improve EF Core Performance](https://sudhirpipaliya.hashnode.dev/why-asnotracking-can-improve-ef-core-performance?utm_source=hashnode&utm_medium=feed) Learn how AsNoTracking improves EF Core performance by reducing memory usage and speeding up read-only queries. 4 min read · [sudhirpipaliya.hashnode.dev](https://sudhirpipaliya.hashnode.dev/why-asnotracking-can-improve-ef-core-performance?utm_source=hashnode&utm_medium=feed) [Ian Santillan](https://hashnode.com/@ievsantillan) · [Jul 14](https://hashnode.com/posts/sql-server-2016-has-reached-end-of-support-now-what/6a56b72a7b5d548fcff8b981) ### [SQL Server 2016 Has Reached End of Support. Now What?](https://ievsantillan.hashnode.dev/sql-server-2016-has-reached-end-of-support-now-what?utm_source=hashnode&utm_medium=feed) What Should Organizations Do Next? 5 min read · [ievsantillan.hashnode.dev](https://ievsantillan.hashnode.dev/sql-server-2016-has-reached-end-of-support-now-what?utm_source=hashnode&utm_medium=feed) [Abinash Behera](https://hashnode.com/@abinashbehera) · [Jul 13](https://hashnode.com/posts/reusable-datatable-aspnet-mvc/6a54b366a7901bade53ae614) ### [🚀 Building a Reusable DataTable Framework in ASP.NET MVC](https://abinashbehera.hashnode.dev/reusable-datatable-aspnet-mvc?utm_source=hashnode&utm_medium=feed) How I reduced duplicate CRUD code by building a reusable DataTable manager with dynamic columns, export, column visibility, resize, reorder, and responsive support. 2 min read · [abinashbehera.hashnode.dev](https://abinashbehera.hashnode.dev/reusable-datatable-aspnet-mvc?utm_source=hashnode&utm_medium=feed) [Coding Droplets](https://hashnode.com/@codingdroplets) · [May 26](https://hashnode.com/posts/sql-server-vs-postgresql-aspnet-core-dotnet-2026/6a15a141500e9ab05bf705fc) ### [SQL Server vs PostgreSQL for .NET Teams: Which Database Should You Use in 2026?](https://codingdroplets.com/sql-server-vs-postgresql-aspnet-core-dotnet-2026?utm_source=hashnode&utm_medium=feed) SQL Server vs PostgreSQL for .NET teams: EF Core compatibility, licensing, performance, and cloud fit — find out which database wins in 2026. 12 min read · [codingdroplets.com](https://codingdroplets.com/sql-server-vs-postgresql-aspnet-core-dotnet-2026?utm_source=hashnode&utm_medium=feed) [Kay Sauter](https://hashnode.com/@kaysauter) · [Mar 8](https://hashnode.com/posts/publishing-powershell-azure-sql-vm-toolkit/69adddd386766ac3a656d085) ### [Publishing Powershell Azure SQL VM Toolkit](https://kayondata.com/publishing-powershell-azure-sql-vm-toolkit?utm_source=hashnode&utm_medium=feed) A PowerShell toolkit for preparing Azure SQL Server VMS 6 min read · [kayondata.com](https://kayondata.com/publishing-powershell-azure-sql-vm-toolkit?utm_source=hashnode&utm_medium=feed) [Ashifur Rahaman](https://hashnode.com/@ashif-arsb) · [Dec 8, 2025](https://hashnode.com/posts/database-design-guidelines-naming-and-data-types/6936ba13a6035d13acaaf453) ### [Database Design Guidelines: Naming & Data Types](https://sqlinsights.hashnode.dev/database-design-guidelines-naming-and-data-types?utm_source=hashnode&utm_medium=feed) Introduction The quality of a database is determined by two pillars: clarity (how easy it is to read) and efficiency (how well it performs). Naming Conventions ensure that the database is not a "black box" but a readable map for developers. Data Ty... 4 min read · [sqlinsights.hashnode.dev](https://sqlinsights.hashnode.dev/database-design-guidelines-naming-and-data-types?utm_source=hashnode&utm_medium=feed)