Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
Forem
Close
#
sqlserver
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
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
2
 reactions
Comments
Add Comment
5 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
5
 reactions
Comments
1
 comment
6 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
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
5
 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
8
 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
8
 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
1
 reaction
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
8
 reactions
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
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
17
 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
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
3
 reactions
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
14
 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
16
 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
4
 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
4
 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 #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 #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
5
 reactions
Comments
Add Comment
2 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 #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
10
 reactions
Comments
Add Comment
1 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
19
 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
14
 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
Get rid of an MS SQL Server database in SingleUserMode
taijidude
taijidude
taijidude
Follow
Feb 23 '22
Get rid of an MS SQL Server database in SingleUserMode
#
sqlserver
#
sql
#
sledgehammersolution
6
 reactions
Comments
Add Comment
1 min read
How to generate Permutations in SQL?
rajanand ilangovan
rajanand ilangovan
rajanand ilangovan
Follow
Feb 14 '22
How to generate Permutations in SQL?
#
sql
#
sqlserver
#
interview
5
 reactions
Comments
Add Comment
2 min read
#008 How to Enable Dark Theme in SQL SERVER Management Studio 18 in 6 quick steps
Kemal Cholovich
Kemal Cholovich
Kemal Cholovich
Follow
Feb 11 '22
#008 How to Enable Dark Theme in SQL SERVER Management Studio 18 in 6 quick steps
#
ssms
#
sqlserver
#
darktheme
4
 reactions
Comments
Add Comment
1 min read
What is the N prefix in MSSQL all about?
Retiago Drago
Retiago Drago
Retiago Drago
Follow
Dec 7 '21
What is the N prefix in MSSQL all about?
#
sql
#
beginners
#
mssql
#
sqlserver
5
 reactions
Comments
Add Comment
3 min read
What is dbo in SQL Server?
Retiago Drago
Retiago Drago
Retiago Drago
Follow
Nov 18 '21
What is dbo in SQL Server?
#
sql
#
beginners
#
mssql
#
sqlserver
9
 reactions
Comments
Add Comment
2 min read
Clustered and Nonclustered Indexes
Retiago Drago
Retiago Drago
Retiago Drago
Follow
Nov 10 '21
Clustered and Nonclustered Indexes
#
sql
#
beginners
#
sqlserver
#
mssql
1
 reaction
Comments
Add Comment
3 min read
🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)
Satish Yadav
Satish Yadav
Satish Yadav
Follow
Nov 5 '21
🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)
#
sql
#
sqlserver
#
sqlserver2022
#
database
5
 reactions
Comments
Add Comment
3 min read
loading...
We're a blogging-forward open source social network where we learn from one another
Log in
Create account