DEV Community

# sqlserver

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQLite Create Table If Not Exists: Conditional Table Creation

SQLite Create Table If Not Exists: Conditional Table Creation

Comments
2 min read
Quickest way to dump data to the database using .Net

Quickest way to dump data to the database using .Net

1
Comments
2 min read
Create a stored procedure with Sql Server

Create a stored procedure with Sql Server

2
Comments
10 min read
User-Defined Functions in SQL: Expanding Your Database Toolkit

User-Defined Functions in SQL: Expanding Your Database Toolkit

10
Comments
7 min read
Integration Test SQL Server Store (Go)

Integration Test SQL Server Store (Go)

5
Comments 1
11 min read
Getting Started with SQL: A Beginners Hands-On Guide!

Getting Started with SQL: A Beginners Hands-On Guide!

17
Comments
7 min read
Optimiser les opérations SQL avec le traitement par lot

Optimiser les opérations SQL avec le traitement par lot

Comments
3 min read
Integration Test SQL Server with testcontainers-dotnet

Integration Test SQL Server with testcontainers-dotnet

1
Comments
5 min read
Integration Test SQL Server Store

Integration Test SQL Server Store

2
Comments
10 min read
Troubleshooting SQL Server Errors - A Comprehensive Guide

Troubleshooting SQL Server Errors - A Comprehensive Guide

1
Comments 1
6 min read
What Is the N+1 Query Problem and How to Detect It

What Is the N+1 Query Problem and How to Detect It

4
Comments 3
8 min read
Generate Date Series in popular Databases

Generate Date Series in popular Databases

4
Comments
3 min read
Fixing “Login failed for user 'sa'. (Microsoft SQL Server, Error 18456)”

Fixing “Login failed for user 'sa'. (Microsoft SQL Server, Error 18456)”

5
Comments
3 min read
Switching from SQL Server to Azure CosmosDB

Switching from SQL Server to Azure CosmosDB

4
Comments 2
8 min read
Triggers in SQL Server: Unlocking the Power of Automation

Triggers in SQL Server: Unlocking the Power of Automation

Comments
3 min read
Mechanisms and Performance when querying data to SQLServer from C#

Mechanisms and Performance when querying data to SQLServer from C#

10
Comments
13 min read
How to Identify Most Called Stored Procedures in SQL Server

How to Identify Most Called Stored Procedures in SQL Server

Comments
2 min read
PostgreSQL vs SQL Server

PostgreSQL vs SQL Server

3
Comments 1
3 min read
Exploring MS SQL Server Triggers

Exploring MS SQL Server Triggers

1
Comments 1
2 min read
Don't miss out on the new features in SQL Server 16.x

Don't miss out on the new features in SQL Server 16.x

5
Comments 2
2 min read
Choosing the correct datatype for your dates in SQL

Choosing the correct datatype for your dates in SQL

Comments
4 min read
How to Inspect a Lot of Stored Procedures (SP) in MSSQL

How to Inspect a Lot of Stored Procedures (SP) in MSSQL

Comments
2 min read
CTE with Multiple Update Statements

CTE with Multiple Update Statements

Comments
2 min read
Maximizing Performance in SQL Server: Best Practices for avoiding Locking and Blocking

Maximizing Performance in SQL Server: Best Practices for avoiding Locking and Blocking

1
Comments
5 min read
Migrating from ASP.net to PHP Laravel

Migrating from ASP.net to PHP Laravel

1
Comments
2 min read
Sequential GUIDs in Entity Framework Core Might Not Be Sequential

Sequential GUIDs in Entity Framework Core Might Not Be Sequential

9
Comments 8
9 min read
SQL Server conditional temp table definition

SQL Server conditional temp table definition

Comments
2 min read
Project Plan: Blazor WebAPI server, Blazor Web client, MSSQL database - All in Docker

Project Plan: Blazor WebAPI server, Blazor Web client, MSSQL database - All in Docker

2
Comments
3 min read
[extra-basic] How to create a SQL Server instance with docker container (linux based)

[extra-basic] How to create a SQL Server instance with docker container (linux based)

2
Comments
1 min read
Administración de bases de datos con SQL Server

Administración de bases de datos con SQL Server

1
Comments
7 min read
Azure Networking Recipes: Connect Azure Database and an Azure App Service using Virtual Network.

Azure Networking Recipes: Connect Azure Database and an Azure App Service using Virtual Network.

2
Comments
5 min read
Forget Azure SQL Edge on a M1 Mac—Run full-blown SQL Server Linux instead (a how-to)

Forget Azure SQL Edge on a M1 Mac—Run full-blown SQL Server Linux instead (a how-to)

6
Comments 2
4 min read
4 Step Strategy to Migrate SQL Server to Azure Cloud

4 Step Strategy to Migrate SQL Server to Azure Cloud

2
Comments
1 min read
Geo Location Search with SQL Server

Geo Location Search with SQL Server

2
Comments 1
2 min read
Consumir datos de SQL Server en Python

Consumir datos de SQL Server en Python

3
Comments
2 min read
Checking out dbForge’s SQL Complete for SQL Server (Part 3)

Checking out dbForge’s SQL Complete for SQL Server (Part 3)

6
Comments
6 min read
Checking out dbForge’s SQL Complete for SQL Server (Part 1)

Checking out dbForge’s SQL Complete for SQL Server (Part 1)

3
Comments
5 min read
SQL Server Database Partitioning

SQL Server Database Partitioning

10
Comments
4 min read
SQL-Quick tip #15 - Random dates

SQL-Quick tip #15 - Random dates

7
Comments
2 min read
SQL-Quick tip #13 - Index usage

SQL-Quick tip #13 - Index usage

5
Comments
1 min read
SQL-Quick tip #14 - Server information

SQL-Quick tip #14 - Server information

9
Comments
1 min read
SQL-Quick tip #12 - Available disk space

SQL-Quick tip #12 - Available disk space

7
Comments
2 min read
SQL-Quick tip #8 - Finding foreign key constraints

SQL-Quick tip #8 - Finding foreign key constraints

6
Comments
1 min read
SQL-Quick tip #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

6
Comments
1 min read
SQL-Quick tip #10 - Select table definition

SQL-Quick tip #10 - Select table definition

7
Comments
1 min read
SQL-Quick tip #11 - Most intensive queries

SQL-Quick tip #11 - Most intensive queries

10
Comments
2 min read
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

6
Comments
4 min read
Install SQL Server command-line tools

Install SQL Server command-line tools

6
Comments
1 min read
Install SQL Server in Ubuntu

Install SQL Server in Ubuntu

9
Comments
1 min read
SQL-Quick tip #9 - Number of rows in all tables

SQL-Quick tip #9 - Number of rows in all tables

6
Comments
1 min read
What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.

What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.

6
Comments 5
5 min read
How to calculate total travel hours between city x and y and vice versa

How to calculate total travel hours between city x and y and vice versa

2
Comments
2 min read
Difference of the handling the spaces between Oracle and SQL Server

Difference of the handling the spaces between Oracle and SQL Server

5
Comments
2 min read
SQL-Quick tip #6 - Find table or column

SQL-Quick tip #6 - Find table or column

6
Comments
2 min read
SQL-Quick tip #5 - Create a sequence of date and time

SQL-Quick tip #5 - Create a sequence of date and time

5
Comments
1 min read
SQL-Quick tip #2 - Randomize rows

SQL-Quick tip #2 - Randomize rows

5
Comments
1 min read
SQL-Quick tip #3 - Prepending zeroes

SQL-Quick tip #3 - Prepending zeroes

6
Comments
1 min read
A way to translate sql scripts to a different dialect

A way to translate sql scripts to a different dialect

2
Comments
1 min read
SQL-Quick tip #4 - Random Int for each row

SQL-Quick tip #4 - Random Int for each row

5
Comments
1 min read
SQL-Quick tip #1 - Range of Int

SQL-Quick tip #1 - Range of Int

7
Comments
1 min read
loading...