DEV Community

# sqlserver

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Collation in Database - What you need to know

Collation in Database - What you need to know

3 min read
Brighter and SQL Server: How to setup and use Brighter with MS SQL

Brighter and SQL Server: How to setup and use Brighter with MS SQL

1
1
3 min read
Integração do Brighter com Microsoft SQL Server

Integração do Brighter com Microsoft SQL Server

3 min read
Cleaning data in PostgreSQL.

Cleaning data in PostgreSQL.

1
7 min read
Filtering and Exporting SQL Stored Procedures with PowerShell

Filtering and Exporting SQL Stored Procedures with PowerShell

4 min read
Troubleshooting tempdb Growth: Identifying Idle Sessions Holding Temporary Resources in SQL Server

Troubleshooting tempdb Growth: Identifying Idle Sessions Holding Temporary Resources in SQL Server

1
2 min read
Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

2
27 min read
How to Install and Use SQLmap on Android Termux

How to Install and Use SQLmap on Android Termux

3
6 min read
𝗘𝗙 𝗖𝗼𝗿𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀 𝘄𝗶𝘁𝗵 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗘𝘅𝗽𝗲𝗻𝘀𝗲𝘀 𝗧𝗮𝗯𝗹𝗲 & 𝗛𝗼𝘄 𝗜 𝗙𝗶𝘅𝗲𝗱 𝗧𝗵𝗲𝗺 🚀

𝗘𝗙 𝗖𝗼𝗿𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀 𝘄𝗶𝘁𝗵 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗘𝘅𝗽𝗲𝗻𝘀𝗲𝘀 𝗧𝗮𝗯𝗹𝗲 & 𝗛𝗼𝘄 𝗜 𝗙𝗶𝘅𝗲𝗱 𝗧𝗵𝗲𝗺 🚀

1 min read
𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

1 min read
✅ 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗕𝘂𝗱𝗴𝗲𝘁 𝗔𝗳𝘁𝗲𝗿 𝗘𝘅𝗽𝗲𝗻𝘀𝗲 𝗘𝗻𝘁𝗿𝘆 𝗨𝘀𝗶𝗻𝗴 𝗘𝗙 𝗖𝗼𝗿𝗲 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀

✅ 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗕𝘂𝗱𝗴𝗲𝘁 𝗔𝗳𝘁𝗲𝗿 𝗘𝘅𝗽𝗲𝗻𝘀𝗲 𝗘𝗻𝘁𝗿𝘆 𝗨𝘀𝗶𝗻𝗴 𝗘𝗙 𝗖𝗼𝗿𝗲 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀

1 min read
Parallel Queries in EF Core with PostgreSQL: Why It Fails and How to Fix It

Parallel Queries in EF Core with PostgreSQL: Why It Fails and How to Fix It

7
2 min read
Connecting an Azure Web App with SQL Server using Private endpoints

Connecting an Azure Web App with SQL Server using Private endpoints

2
4 min read
Optimistic vs. Pessimistic Concurrency in EF Core (with Table Hints)

Optimistic vs. Pessimistic Concurrency in EF Core (with Table Hints)

3
2
3 min read
What Is SQL Server? A Beginner’s Guide to Microsoft’s Database System

What Is SQL Server? A Beginner’s Guide to Microsoft’s Database System

1
4 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

6
7 min read
How to Optimize SQL Queries for Speed and Efficiency

How to Optimize SQL Queries for Speed and Efficiency

3
2
5 min read
Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

7 min read
Paginação, Busca e Ordenação em .NET via Back-end

Paginação, Busca e Ordenação em .NET via Back-end

1 min read
EF Core Doesn't Support Some SQL Server Functions!

EF Core Doesn't Support Some SQL Server Functions!

1
2 min read
UkrGuru.Sql: Additional Features Under the Hood

UkrGuru.Sql: Additional Features Under the Hood

4 min read
🚀 𝗘𝗙 𝗖𝗼𝗿𝗲 𝗦𝘁𝗿𝘂𝗴𝗴𝗹𝗲𝘀 𝘄𝗶𝘁𝗵 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀? 𝗦𝘄𝗶𝘁𝗰𝗵 𝘁𝗼 𝗦𝘁𝗼𝗿𝗲𝗱 𝗣𝗿𝗼𝗰𝗲𝗱𝘂𝗿𝗲𝘀!

🚀 𝗘𝗙 𝗖𝗼𝗿𝗲 𝗦𝘁𝗿𝘂𝗴𝗴𝗹𝗲𝘀 𝘄𝗶𝘁𝗵 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀? 𝗦𝘄𝗶𝘁𝗰𝗵 𝘁𝗼 𝗦𝘁𝗼𝗿𝗲𝗱 𝗣𝗿𝗼𝗰𝗲𝗱𝘂𝗿𝗲𝘀!

1 min read
Aggregate Functions in SQL

Aggregate Functions in SQL

2 min read
Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

3 min read
Best-Practice recommendation scripts

Best-Practice recommendation scripts

1 min read
loading...