DEV Community

# sqlserver

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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
Understanding SQL Subqueries and Common Table Expressions (CTEs)

Understanding SQL Subqueries and Common Table Expressions (CTEs)

2
Comments
4 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

7
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
Difference Between VARCHAR() and NARCHAR()

Difference Between VARCHAR() and NARCHAR()

4
Comments 1
1 min read
loading...