Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
DEV Community
is a community of 862,249 amazing developers
We're a place where coders share, stay up-to-date and grow their careers.
Create account
Log in
Home
Listings
Podcasts
Videos
Tags
FAQ
Forem Shop
Sponsors
About
Contact
Other
Code of Conduct
Privacy Policy
Terms of use
Twitter
Facebook
Github
Instagram
Twitch
#
mssql
Follow
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
SQL-Quick tip #13 - Index usage
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 17
SQL-Quick tip #13 - Index usage
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #12 - Available disk space
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 10
SQL-Quick tip #12 - Available disk space
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
7
 reactions
Comments
Add Comment
2 min read
Save
Saved
SQL-Quick tip #11 - Most intensive queries
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 3
SQL-Quick tip #11 - Most intensive queries
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
10
 reactions
Comments
Add Comment
2 min read
Save
Saved
SQL-Quick tip #8 - Finding foreign key constraints
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 12
SQL-Quick tip #8 - Finding foreign key constraints
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #7 - Find stored procedures
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 5
SQL-Quick tip #7 - Find stored procedures
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #6 - Find table or column
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 29
SQL-Quick tip #6 - Find table or column
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
5
 reactions
Comments
Add Comment
2 min read
Save
Saved
SQL-Quick tip #9 - Number of rows in all tables
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 19
SQL-Quick tip #9 - Number of rows in all tables
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #5 - Create a sequence of date and time
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 22
SQL-Quick tip #5 - Create a sequence of date and time
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #2 - Randomize rows
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 1
SQL-Quick tip #2 - Randomize rows
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #3 - Prepending zeroes
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 8
SQL-Quick tip #3 - Prepending zeroes
#
tsq
#
sqlserver
#
sql
#
mssql
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #4 - Random Int for each row
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 15
SQL-Quick tip #4 - Random Int for each row
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL-Quick tip #1 - Range of Int
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Feb 25
SQL-Quick tip #1 - Range of Int
#
tsql
#
sqlserver
#
sql
#
mssql
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
READPAST your problems in SQL
Costin Manda
Costin Manda
Costin Manda
Follow
Mar 7
READPAST your problems in SQL
#
programming
#
database
#
mssql
Reactions
7
 reactions
Comments
Add Comment
3 min read
Save
Saved
SQL date 1900-01-01 appearing out of nowhere
Costin Manda
Costin Manda
Costin Manda
Follow
Feb 28
SQL date 1900-01-01 appearing out of nowhere
#
programming
#
mssql
#
database
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL Server Primary Keys
Jin Vincent Necesario
Jin Vincent Necesario
Jin Vincent Necesario
Follow
Jan 22
SQL Server Primary Keys
#
sql
#
tsql
#
primarykey
#
mssql
Reactions
6
 reactions
Comments
Add Comment
6 min read
Save
Saved
VALUES in Microsoft Transact-SQL
Costin Manda
Costin Manda
Costin Manda
Follow
Jan 15
VALUES in Microsoft Transact-SQL
#
programming
#
database
#
mssql
Reactions
5
 reactions
Comments
Add Comment
2 min read
Save
Saved
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
Reactions
5
 reactions
Comments
Add Comment
3 min read
Save
Saved
Calculating length of ntext data type with T-SQL
Ferhat KarataĹź
Ferhat KarataĹź
Ferhat KarataĹź
Follow
Dec 15 '21
Calculating length of ntext data type with T-SQL
#
tsql
#
query
#
mssql
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
Setup local MS SQL docker container
Aleksander Parchomenko
Aleksander Parchomenko
Aleksander Parchomenko
Follow
Dec 13 '21
Setup local MS SQL docker container
#
docker
#
mssql
#
local
#
dev
Reactions
5
 reactions
Comments
Add Comment
5 min read
Save
Saved
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
Reactions
3
 reactions
Comments
Add Comment
2 min read
Save
Saved
How to prevent duplicate count value for inner join
Ferhat KarataĹź
Ferhat KarataĹź
Ferhat KarataĹź
Follow
Oct 28 '21
How to prevent duplicate count value for inner join
#
tsql
#
query
#
mssql
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
MS SQL Server and Adminer in Laradock
Dendi Handian
Dendi Handian
Dendi Handian
Follow
Aug 11 '21
MS SQL Server and Adminer in Laradock
#
mssql
#
docker
#
adminer
#
rdbms
Reactions
2
 reactions
Comments
Add Comment
3 min read
Save
Saved
Alter SQL Server Temporal Table
Joe Enos
Joe Enos
Joe Enos
Follow
Jun 30 '21
Alter SQL Server Temporal Table
#
sqlserver
#
mssql
#
dba
#
sql
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
SQL Server Temporal Tables
Joe Enos
Joe Enos
Joe Enos
Follow
Jun 22 '21
SQL Server Temporal Tables
#
sqlserver
#
sql
#
mssql
#
temporal
Reactions
6
 reactions
Comments
Add Comment
1 min read
Save
Saved
Case Senstive Columns in SQL Server
Joe Enos
Joe Enos
Joe Enos
Follow
Jun 6 '21
Case Senstive Columns in SQL Server
#
sqlserver
#
mssql
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
GUID Primary Keys
Joe Enos
Joe Enos
Joe Enos
Follow
Jun 1 '21
GUID Primary Keys
#
sqlserver
#
mssql
#
guid
#
indexes
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
Base64 Conversions in SQL Server
Joe Enos
Joe Enos
Joe Enos
Follow
May 29 '21
Base64 Conversions in SQL Server
#
sqlserver
#
mssql
#
base64
#
sql
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
Optimizing an SQL Server query
Costin Manda
Costin Manda
Costin Manda
Follow
Apr 18 '21
Optimizing an SQL Server query
#
mssql
#
database
#
programming
Reactions
2
 reactions
Comments
Add Comment
2 min read
Save
Saved
Cara membuat jail fail2ban untuk Microsoft SQL Server (MSSQL)
Erol Joudy
Erol Joudy
Erol Joudy
Follow
Mar 9 '21
Cara membuat jail fail2ban untuk Microsoft SQL Server (MSSQL)
#
linux
#
mssql
#
indonesia
Reactions
6
 reactions
Comments
Add Comment
2 min read
Save
Saved
How to monitor backup and restore progress in SQL Server
Alexey Ryazhskikh
Alexey Ryazhskikh
Alexey Ryazhskikh
Follow
Feb 19 '21
How to monitor backup and restore progress in SQL Server
#
sql
#
mssql
#
database
#
tsql
Reactions
4
 reactions
Comments
Add Comment
2 min read
Save
Saved
Develop, Build, and Deploy Microsoft SQL Databases on macOS
Denny Christochowitz
Denny Christochowitz
Denny Christochowitz
Follow
Dec 9 '20
Develop, Build, and Deploy Microsoft SQL Databases on macOS
#
mssql
#
dacpac
#
docker
#
macos
Reactions
11
 reactions
Comments
1
 comment
6 min read
Save
Saved
Using the Debezium MS SQL connector with ksqlDB embedded Kafka Connect
Robin Moffatt
Robin Moffatt
Robin Moffatt
Follow
Sep 18 '20
Using the Debezium MS SQL connector with ksqlDB embedded Kafka Connect
#
apachekafka
#
mssql
#
debezium
#
ksqldb
Reactions
7
 reactions
Comments
Add Comment
6 min read
Save
Saved
Optimizing complex SQL queries and stored procedures
Costin Manda
Costin Manda
Costin Manda
Follow
Aug 8 '20
Optimizing complex SQL queries and stored procedures
#
programming
#
database
#
mssql
Reactions
5
 reactions
Comments
1
 comment
35 min read
Save
Saved
Cheatsheet for MSSQL
Steve Mak
Steve Mak
Steve Mak
Follow
May 18 '20
Cheatsheet for MSSQL
#
mssql
#
cheatsheet
Reactions
4
 reactions
Comments
Add Comment
1 min read
Save
Saved
Microsoft Data Platform Stack Overview
Kay Sauter
Kay Sauter
Kay Sauter
Follow
Apr 12 '20
Microsoft Data Platform Stack Overview
#
azure
#
database
#
mssql
#
architecture
Reactions
13
 reactions
Comments
Add Comment
8 min read
Save
Saved
COVID-19 increased my time for learning
Dave
Dave
Dave
Follow
Mar 29 '20
COVID-19 increased my time for learning
#
covid19
#
mssql
#
scripting
#
writing
Reactions
5
 reactions
Comments
Add Comment
3 min read
Save
Saved
Reverse Proxy MS SQL with Nginx
Jordon Replogle
Jordon Replogle
Jordon Replogle
Follow
Mar 28 '20
Reverse Proxy MS SQL with Nginx
#
mssql
#
nginx
#
linux
Reactions
9
 reactions
Comments
3
 comments
1 min read
Save
Saved
Entity Framework DotNet Core with GraphQL and SQL Server (using HotChocolate)
mnsr
mnsr
mnsr
Follow
Mar 6 '20
Entity Framework DotNet Core with GraphQL and SQL Server (using HotChocolate)
#
dotnet
#
graphql
#
efcore
#
mssql
Reactions
39
 reactions
Comments
15
 comments
5 min read
Save
Saved
Querying MySQL from SQL Server using linked server
Gunnar Peipman
Gunnar Peipman
Gunnar Peipman
Follow
Mar 3 '20
Querying MySQL from SQL Server using linked server
#
mssql
#
sqlserver
#
mysql
Reactions
7
 reactions
Comments
Add Comment
5 min read
Save
Saved
Using data from MSSQL linked server with EF Core
Gunnar Peipman
Gunnar Peipman
Gunnar Peipman
Follow
Mar 3 '20
Using data from MSSQL linked server with EF Core
#
efcore
#
sqlserver
#
mssql
#
mysql
Reactions
7
 reactions
Comments
Add Comment
4 min read
Save
Saved
Using Common Table Expressions to solve Sudoku in Microsoft SQL Server
Costin Manda
Costin Manda
Costin Manda
Follow
Feb 22 '20
Using Common Table Expressions to solve Sudoku in Microsoft SQL Server
#
programming
#
database
#
mssql
#
picture
Reactions
6
 reactions
Comments
Add Comment
5 min read
Save
Saved
Check if type exists in MSSQL
Adam K Dean
Adam K Dean
Adam K Dean
Follow
Mar 27 '14
Check if type exists in MSSQL
#
sql
#
mssql
#
snippet
Reactions
5
 reactions
Comments
Add Comment
1 min read
Save
Saved
Building a fully reactive and scalable Spring application with R2DBC and a serverless database
Julien Dubois
Julien Dubois
Julien Dubois
Follow
for
Microsoft Azure
Aug 29 '19
Building a fully reactive and scalable Spring application with R2DBC and a serverless database
#
spring
#
azure
#
java
#
mssql
Reactions
54
 reactions
Comments
1
 comment
5 min read
Save
Saved
Dotnet Core Webapi With Microsoft SQL Server in Docker - Part 1
Rafael
Rafael
Rafael
Follow
Aug 25 '19
Dotnet Core Webapi With Microsoft SQL Server in Docker - Part 1
#
dotnetcore
#
webapi
#
mssql
#
docker
Reactions
9
 reactions
Comments
Add Comment
6 min read
Save
Saved
Setting up a Laravel project with SQL Server AND XAMPP / WAMP on Windows
Odunayo Ogungbure
Odunayo Ogungbure
Odunayo Ogungbure
Follow
Aug 16 '19
Setting up a Laravel project with SQL Server AND XAMPP / WAMP on Windows
#
laravel
#
mssql
#
windows
Reactions
35
 reactions
Comments
12
 comments
3 min read
Save
Saved
6 MSSQL Interview Questions for Experienced
Sharad
Sharad
Sharad
Follow
Oct 25 '18
6 MSSQL Interview Questions for Experienced
#
mssql
#
interview
#
questions
Reactions
17
 reactions
Comments
Add Comment
3 min read
Save
Saved
Need a little help here.
Squiff88
Squiff88
Squiff88
Follow
Oct 1 '18
Need a little help here.
#
help
#
node
#
mssql
#
beginners
Reactions
9
 reactions
Comments
8
 comments
1 min read
Save
Saved
Monitoring my solar system from the cloud
Casey Mullineaux
Casey Mullineaux
Casey Mullineaux
Follow
Dec 17 '19
Monitoring my solar system from the cloud
#
solar
#
c
#
mssql
Reactions
2
 reactions
Comments
Add Comment
1 min read
Save
Saved
MS SQL Server Backups to S3 – On Linux!
Luke Bearl
Luke Bearl
Luke Bearl
Follow
Dec 6 '17
MS SQL Server Backups to S3 – On Linux!
#
mssql
#
linux
#
sqlserver
#
s3
Reactions
7
 reactions
Comments
Add Comment
3 min read
Save
Saved
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account