DEV Community

# sqlserver

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

3
Comments
6 min read
SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

Comments
3 min read
A Brief Guide to Implementing Pagination in a C# Endpoint

A Brief Guide to Implementing Pagination in a C# Endpoint

Comments
2 min read
Cypress vs Selenium: Which Testing Tool Is Right for You?

Cypress vs Selenium: Which Testing Tool Is Right for You?

Comments
3 min read
Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

Comments
3 min read
From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

Comments
14 min read
What is SQL, and Why is it Essential in Modern Computing?

What is SQL, and Why is it Essential in Modern Computing?

Comments
1 min read
Effective Methods for Troubleshooting Deadlocks in SQL Server

Effective Methods for Troubleshooting Deadlocks in SQL Server

Comments
7 min read
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

9
Comments
9 min read
Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

Comments
3 min read
Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

Comments
7 min read
Boosting SQL Query Flexibility with CROSS APPLY

Boosting SQL Query Flexibility with CROSS APPLY

Comments
2 min read
ROLLUP

ROLLUP

Comments
2 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Comments
3 min read
How to Manage Your SQL Server Database Effectively

How to Manage Your SQL Server Database Effectively

6
Comments 1
3 min read
Understanding SQL Subqueries and Common Table Expressions (CTEs)

Understanding SQL Subqueries and Common Table Expressions (CTEs)

2
Comments
4 min read
SQL Server Execution Plans

SQL Server Execution Plans

2
Comments
5 min read
Find Text in MSSQL Stored Procedures and Functions with a Custom Function

Find Text in MSSQL Stored Procedures and Functions with a Custom Function

Comments
1 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

Comments
3 min read
SQL Indexes

SQL Indexes

Comments
3 min read
MS-SQL, React, Fetch ... Mostrar imagen desde un campo tipo Imagen

MS-SQL, React, Fetch ... Mostrar imagen desde un campo tipo Imagen

Comments
1 min read
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

7
Comments 1
6 min read
Step-by-Step Guide: Easy Reporting đź“‹ with ClosedXML (Excel) and Database Views

Step-by-Step Guide: Easy Reporting đź“‹ with ClosedXML (Excel) and Database Views

7
Comments 1
5 min read
Zendesk Data Integration in ETL Using SSIS: Source, Lookup & Destination Components

Zendesk Data Integration in ETL Using SSIS: Source, Lookup & Destination Components

Comments
2 min read
Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Comments
4 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Comments
3 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

1
Comments
2 min read
Dockerizing SQL Server with Pre-Restored Databases

Dockerizing SQL Server with Pre-Restored Databases

1
Comments 1
5 min read
Understanding SQL Queries: A Beginner’s Guide pt1

Understanding SQL Queries: A Beginner’s Guide pt1

Comments
4 min read
Step-by-Step Guide: Querying From Databases Via a Single Database Helper Using the Strategy Design Pattern

Step-by-Step Guide: Querying From Databases Via a Single Database Helper Using the Strategy Design Pattern

6
Comments
3 min read
COBOL Tutorial Series: DB2 vs SQL Server Architecture Comparison - Session 7

COBOL Tutorial Series: DB2 vs SQL Server Architecture Comparison - Session 7

2
Comments 1
3 min read
SQL Injection (SQLi) Defense Strategies for OpenCart Developers

SQL Injection (SQLi) Defense Strategies for OpenCart Developers

2
Comments 1
2 min read
Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Comments
3 min read
Why does SQLynx perform so well

Why does SQLynx perform so well

Comments
2 min read
How to import excel into sql server only 1 step

How to import excel into sql server only 1 step

Comments
2 min read
Building a Custom Logging Provider in ASP.NET Core

Building a Custom Logging Provider in ASP.NET Core

22
Comments 3
12 min read
SQL in Minutes: Your Ultimate SQL Cheat Sheet

SQL in Minutes: Your Ultimate SQL Cheat Sheet

2
Comments
1 min read
PostgreSQL Insights: Understanding MVCC in Transactions

PostgreSQL Insights: Understanding MVCC in Transactions

Comments
3 min read
Azure SQL to Storage Account Export Tool

Azure SQL to Storage Account Export Tool

1
Comments 1
3 min read
How to Use Unique Key Constraints in Database Tables

How to Use Unique Key Constraints in Database Tables

Comments
2 min read
The Book Nook: A Website Security Crisis

The Book Nook: A Website Security Crisis

13
Comments
3 min read
AS Keyword in SQL Server

AS Keyword in SQL Server

Comments
5 min read
Employee Management System Using SQL

Employee Management System Using SQL

6
Comments
4 min read
Join the Party: A Comprehensive Guide to SQL Joins with Examples

Join the Party: A Comprehensive Guide to SQL Joins with Examples

1
Comments
4 min read
How to Use the SQL Server ANY Keyword for Flexible Querying

How to Use the SQL Server ANY Keyword for Flexible Querying

Comments
5 min read
Difference Between VARCHAR() and NARCHAR()

Difference Between VARCHAR() and NARCHAR()

4
Comments 1
1 min read
SQL(Structured Query Language) Road Map for beginners

SQL(Structured Query Language) Road Map for beginners

6
Comments 2
2 min read
Why I Revisited MS SQL Server Basics: A Deep Dive into String Data Types

Why I Revisited MS SQL Server Basics: A Deep Dive into String Data Types

Comments
3 min read
Migrating from SQLServer to Aurora PostgreSQL

Migrating from SQLServer to Aurora PostgreSQL

4
Comments
6 min read
Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)

Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)

3
Comments
4 min read
.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

1
Comments
4 min read
Concept of Backup and Recovery

Concept of Backup and Recovery

Comments
2 min read
Connecting to SQL Server with C#: Understanding the Need and Benefits

Connecting to SQL Server with C#: Understanding the Need and Benefits

Comments
3 min read
How To Use The SQL Server ALTER Keyword To Modify Database Objects

How To Use The SQL Server ALTER Keyword To Modify Database Objects

Comments
9 min read
LocalDb Dev on Windows11 ARM

LocalDb Dev on Windows11 ARM

Comments
5 min read
5 Essential SQL Skills Learned from a Decade of Experience

5 Essential SQL Skills Learned from a Decade of Experience

50
Comments 28
4 min read
Function/Method to get DataTable from SQL Server Database in c#

Function/Method to get DataTable from SQL Server Database in c#

2
Comments
1 min read
CRUD operations using Blazor Web App, Entity Framework and SQL Server

CRUD operations using Blazor Web App, Entity Framework and SQL Server

19
Comments 1
7 min read
18 Key Points You Must Know When Creating Tables in MySQL

18 Key Points You Must Know When Creating Tables in MySQL

6
Comments
11 min read
Build a Database Schema In 5 Steps

Build a Database Schema In 5 Steps

Comments
26 min read
loading...