Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
#
sqlserver
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
SQLite Create Table If Not Exists: Conditional Table Creation
SQL Docs
SQL Docs
SQL Docs
Follow
Oct 11 '23
SQLite Create Table If Not Exists: Conditional Table Creation
#
sql
#
sqlserver
#
database
Comments
Add Comment
2 min read
Quickest way to dump data to the database using .Net
Swapnil Takalkar
Swapnil Takalkar
Swapnil Takalkar
Follow
Oct 8 '23
Quickest way to dump data to the database using .Net
#
sqlserver
#
sql
#
dotnet
#
dotnetcore
1
reaction
Comments
Add Comment
2 min read
Create a stored procedure with Sql Server
Maurizio8788
Maurizio8788
Maurizio8788
Follow
Oct 7 '23
Create a stored procedure with Sql Server
#
sql
#
sqlserver
#
database
#
backend
2
reactions
Comments
Add Comment
10 min read
User-Defined Functions in SQL: Expanding Your Database Toolkit
Dare Johnson
Dare Johnson
Dare Johnson
Follow
Oct 6 '23
User-Defined Functions in SQL: Expanding Your Database Toolkit
#
sqlserver
#
rdbms
#
datascience
#
sql
10
reactions
Comments
Add Comment
7 min read
Integration Test SQL Server Store (Go)
Kashif Soofi
Kashif Soofi
Kashif Soofi
Follow
Oct 5 '23
Integration Test SQL Server Store (Go)
#
testing
#
sqlserver
#
githubactions
#
go
5
reactions
Comments
1
comment
11 min read
Getting Started with SQL: A Beginners Hands-On Guide!
Pavan Belagatti
Pavan Belagatti
Pavan Belagatti
Follow
Sep 21 '23
Getting Started with SQL: A Beginners Hands-On Guide!
#
sql
#
sqlserver
#
beginners
#
tutorial
17
reactions
Comments
Add Comment
7 min read
Optimiser les opérations SQL avec le traitement par lot
Anthony Ryckembusch
Anthony Ryckembusch
Anthony Ryckembusch
Follow
Sep 3 '23
Optimiser les opérations SQL avec le traitement par lot
#
sql
#
sqlserver
Comments
Add Comment
3 min read
Integration Test SQL Server with testcontainers-dotnet
Kashif Soofi
Kashif Soofi
Kashif Soofi
Follow
Sep 1 '23
Integration Test SQL Server with testcontainers-dotnet
#
testing
#
sqlserver
#
githubactions
1
reaction
Comments
Add Comment
5 min read
Integration Test SQL Server Store
Kashif Soofi
Kashif Soofi
Kashif Soofi
Follow
Aug 25 '23
Integration Test SQL Server Store
#
testing
#
sqlserver
#
githubactions
2
reactions
Comments
Add Comment
10 min read
Troubleshooting SQL Server Errors - A Comprehensive Guide
Emediong Harrison
Emediong Harrison
Emediong Harrison
Follow
Aug 25 '23
Troubleshooting SQL Server Errors - A Comprehensive Guide
#
sqlserver
#
mssql
#
datascience
#
sqlerrors
1
reaction
Comments
1
comment
6 min read
What Is the N+1 Query Problem and How to Detect It
LeeLussh
LeeLussh
LeeLussh
Follow
Aug 23 '23
What Is the N+1 Query Problem and How to Detect It
#
java
#
observability
#
sqlserver
#
orm
4
reactions
Comments
3
comments
8 min read
Generate Date Series in popular Databases
Slava Rozhnev
Slava Rozhnev
Slava Rozhnev
Follow
Aug 23 '23
Generate Date Series in popular Databases
#
sql
#
postgres
#
oracle
#
sqlserver
4
reactions
Comments
Add Comment
3 min read
Fixing “Login failed for user 'sa'. (Microsoft SQL Server, Error 18456)”
Shekhar Tarare
Shekhar Tarare
Shekhar Tarare
Follow
Aug 6 '23
Fixing “Login failed for user 'sa'. (Microsoft SQL Server, Error 18456)”
#
tutorial
#
sqlserver
#
authentication
#
database
5
reactions
Comments
Add Comment
3 min read
Switching from SQL Server to Azure CosmosDB
Peter Davis
Peter Davis
Peter Davis
Follow
Aug 4 '23
Switching from SQL Server to Azure CosmosDB
#
cosmosdb
#
sqlserver
#
azure
#
dotnet
4
reactions
Comments
2
comments
8 min read
Triggers in SQL Server: Unlocking the Power of Automation
Ronal Niraula
Ronal Niraula
Ronal Niraula
Follow
Jul 4 '23
Triggers in SQL Server: Unlocking the Power of Automation
#
sqlserver
#
database
#
trigger
#
sql
Comments
Add Comment
3 min read
Mechanisms and Performance when querying data to SQLServer from C#
Xavier Abelaira Rueda
Xavier Abelaira Rueda
Xavier Abelaira Rueda
Follow
Jul 29 '23
Mechanisms and Performance when querying data to SQLServer from C#
#
dotnet
#
csharp
#
sqlserver
10
reactions
Comments
Add Comment
13 min read
How to Identify Most Called Stored Procedures in SQL Server
Frederik Van Lierde
Frederik Van Lierde
Frederik Van Lierde
Follow
Jul 20 '23
How to Identify Most Called Stored Procedures in SQL Server
#
sqlserver
Comments
Add Comment
2 min read
PostgreSQL vs SQL Server
Maimoona Abid
Maimoona Abid
Maimoona Abid
Follow
Jul 19 '23
PostgreSQL vs SQL Server
#
apacheage
#
psql
#
sqlserver
3
reactions
Comments
1
comment
3 min read
Exploring MS SQL Server Triggers
Zanyar Jalal
Zanyar Jalal
Zanyar Jalal
Follow
Jul 12 '23
Exploring MS SQL Server Triggers
#
sql
#
sqlserver
#
database
1
reaction
Comments
1
comment
2 min read
Don't miss out on the new features in SQL Server 16.x
Olesia Dudareva
Olesia Dudareva
Olesia Dudareva
Follow
May 28 '23
Don't miss out on the new features in SQL Server 16.x
#
sql
#
database
#
datascience
#
sqlserver
5
reactions
Comments
2
comments
2 min read
Choosing the correct datatype for your dates in SQL
Der Sascha
Der Sascha
Der Sascha
Follow
Apr 16 '23
Choosing the correct datatype for your dates in SQL
#
sqlserver
#
bestpractise
Comments
Add Comment
4 min read
How to Inspect a Lot of Stored Procedures (SP) in MSSQL
Retiago Drago
Retiago Drago
Retiago Drago
Follow
May 7 '23
How to Inspect a Lot of Stored Procedures (SP) in MSSQL
#
sql
#
beginners
#
tutorial
#
sqlserver
Comments
Add Comment
2 min read
CTE with Multiple Update Statements
Retiago Drago
Retiago Drago
Retiago Drago
Follow
May 5 '23
CTE with Multiple Update Statements
#
sql
#
mssql
#
beginners
#
sqlserver
Comments
Add Comment
2 min read
Maximizing Performance in SQL Server: Best Practices for avoiding Locking and Blocking
Der Sascha
Der Sascha
Der Sascha
Follow
Apr 23 '23
Maximizing Performance in SQL Server: Best Practices for avoiding Locking and Blocking
#
sqlserver
#
performance
1
reaction
Comments
Add Comment
5 min read
Migrating from ASP.net to PHP Laravel
Ken Ng
Ken Ng
Ken Ng
Follow
Mar 6 '23
Migrating from ASP.net to PHP Laravel
#
laravel
#
aspdotnet
#
sqlserver
1
reaction
Comments
Add Comment
2 min read
Sequential GUIDs in Entity Framework Core Might Not Be Sequential
Conner Phillis
Conner Phillis
Conner Phillis
Follow
Mar 24 '23
Sequential GUIDs in Entity Framework Core Might Not Be Sequential
#
dotnet
#
sqlserver
#
entityframeworkcore
#
programming
9
reactions
Comments
8
comments
9 min read
SQL Server conditional temp table definition
theBridge2
theBridge2
theBridge2
Follow
Mar 6 '23
SQL Server conditional temp table definition
#
sqlserver
Comments
Add Comment
2 min read
Project Plan: Blazor WebAPI server, Blazor Web client, MSSQL database - All in Docker
Aaron Prill
Aaron Prill
Aaron Prill
Follow
Mar 2 '23
Project Plan: Blazor WebAPI server, Blazor Web client, MSSQL database - All in Docker
#
docker
#
dotnetcore
#
microservices
#
sqlserver
2
reactions
Comments
Add Comment
3 min read
[extra-basic] How to create a SQL Server instance with docker container (linux based)
Henrique Holtz
Henrique Holtz
Henrique Holtz
Follow
Feb 18 '23
[extra-basic] How to create a SQL Server instance with docker container (linux based)
#
docker
#
sqlserver
2
reactions
Comments
Add Comment
1 min read
Administración de bases de datos con SQL Server
Beatriz Martínez Pérez
Beatriz Martínez Pérez
Beatriz Martínez Pérez
Follow
Jan 23 '23
Administración de bases de datos con SQL Server
#
sql
#
sqlserver
#
beginners
#
database
1
reaction
Comments
Add Comment
7 min read
Azure Networking Recipes: Connect Azure Database and an Azure App Service using Virtual Network.
Ghassan Karwchan
Ghassan Karwchan
Ghassan Karwchan
Follow
Jan 26 '23
Azure Networking Recipes: Connect Azure Database and an Azure App Service using Virtual Network.
#
azure
#
sqlserver
#
azuresqldb
#
azureappservices
2
reactions
Comments
Add Comment
5 min read
Forget Azure SQL Edge on a M1 Mac—Run full-blown SQL Server Linux instead (a how-to)
Shane Burnham
Shane Burnham
Shane Burnham
Follow
Jan 12 '23
Forget Azure SQL Edge on a M1 Mac—Run full-blown SQL Server Linux instead (a how-to)
#
sqlserver
#
applesilicon
#
m1chip
#
localdev
6
reactions
Comments
2
comments
4 min read
4 Step Strategy to Migrate SQL Server to Azure Cloud
Mark B
Mark B
Mark B
Follow
Oct 19 '22
4 Step Strategy to Migrate SQL Server to Azure Cloud
#
sql
#
azure
#
cloud
#
sqlserver
2
reactions
Comments
Add Comment
1 min read
Geo Location Search with SQL Server
Frederik Van Lierde
Frederik Van Lierde
Frederik Van Lierde
Follow
Oct 29 '22
Geo Location Search with SQL Server
#
sql
#
sqlserver
2
reactions
Comments
1
comment
2 min read
Consumir datos de SQL Server en Python
Eduardo Santos
Eduardo Santos
Eduardo Santos
Follow
Oct 18 '22
Consumir datos de SQL Server en Python
#
pyhton
#
sqlalchemy
#
sqlserver
3
reactions
Comments
Add Comment
2 min read
Checking out dbForge’s SQL Complete for SQL Server (Part 3)
Alejandro Cobar
Alejandro Cobar
Alejandro Cobar
Follow
Jul 6 '22
Checking out dbForge’s SQL Complete for SQL Server (Part 3)
#
devart
#
sqlserver
#
dbdevelopment
#
database
6
reactions
Comments
Add Comment
6 min read
Checking out dbForge’s SQL Complete for SQL Server (Part 1)
Alejandro Cobar
Alejandro Cobar
Alejandro Cobar
Follow
Jun 30 '22
Checking out dbForge’s SQL Complete for SQL Server (Part 1)
#
devart
#
sqlserver
#
dbdevelopment
3
reactions
Comments
Add Comment
5 min read
SQL Server Database Partitioning
jeevan wijerathna
jeevan wijerathna
jeevan wijerathna
Follow
Jun 13 '22
SQL Server Database Partitioning
#
sql
#
sqlserver
10
reactions
Comments
Add Comment
4 min read
SQL-Quick tip #15 - Random dates
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 31 '22
SQL-Quick tip #15 - Random dates
#
tsql
#
sqlserver
#
sql
#
mssql
7
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #13 - Index usage
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 17 '22
SQL-Quick tip #13 - Index usage
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #14 - Server information
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 24 '22
SQL-Quick tip #14 - Server information
#
tsql
#
sqlserver
#
sql
#
mssql
9
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #12 - Available disk space
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 10 '22
SQL-Quick tip #12 - Available disk space
#
tsql
#
sqlserver
#
sql
#
mssql
7
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #8 - Finding foreign key constraints
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 12 '22
SQL-Quick tip #8 - Finding foreign key constraints
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #7 - Find stored procedures
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 5 '22
SQL-Quick tip #7 - Find stored procedures
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #10 - Select table definition
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 26 '22
SQL-Quick tip #10 - Select table definition
#
tsql
#
sqlserver
#
sql
#
mssq
7
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #11 - Most intensive queries
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 3 '22
SQL-Quick tip #11 - Most intensive queries
#
tsql
#
sqlserver
#
sql
#
mssql
10
reactions
Comments
Add Comment
2 min read
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)
em8215
em8215
em8215
Follow
Apr 11 '22
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)
#
sql
#
oracle
#
sqlserver
6
reactions
Comments
Add Comment
4 min read
Install SQL Server command-line tools
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Follow
Apr 26 '22
Install SQL Server command-line tools
#
sql
#
ubuntu
#
sqlserver
#
installation
6
reactions
Comments
Add Comment
1 min read
Install SQL Server in Ubuntu
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Follow
Apr 26 '22
Install SQL Server in Ubuntu
#
ubuntu
#
sql
#
installation
#
sqlserver
9
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #9 - Number of rows in all tables
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 19 '22
SQL-Quick tip #9 - Number of rows in all tables
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
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.
kakisoft
kakisoft
kakisoft
Follow
Apr 14 '22
What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.
#
rdb
#
mysql
#
postgres
#
sqlserver
6
reactions
Comments
5
comments
5 min read
How to calculate total travel hours between city x and y and vice versa
rajanand ilangovan
rajanand ilangovan
rajanand ilangovan
Follow
Mar 5 '22
How to calculate total travel hours between city x and y and vice versa
#
sqlserver
#
interview
#
questions
2
reactions
Comments
Add Comment
2 min read
Difference of the handling the spaces between Oracle and SQL Server
em8215
em8215
em8215
Follow
Apr 5 '22
Difference of the handling the spaces between Oracle and SQL Server
#
sql
#
oracle
#
sqlserver
5
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #6 - Find table or column
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 29 '22
SQL-Quick tip #6 - Find table or column
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #5 - Create a sequence of date and time
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 22 '22
SQL-Quick tip #5 - Create a sequence of date and time
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #2 - Randomize rows
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 1 '22
SQL-Quick tip #2 - Randomize rows
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #3 - Prepending zeroes
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 8 '22
SQL-Quick tip #3 - Prepending zeroes
#
tsq
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
A way to translate sql scripts to a different dialect
taijidude
taijidude
taijidude
Follow
Mar 18 '22
A way to translate sql scripts to a different dialect
#
sql
#
sqlserver
#
hsqldb
#
jooq
2
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #4 - Random Int for each row
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 15 '22
SQL-Quick tip #4 - Random Int for each row
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #1 - Range of Int
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Feb 25 '22
SQL-Quick tip #1 - Range of Int
#
tsql
#
sqlserver
#
sql
#
mssql
7
reactions
Comments
Add Comment
1 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account