DEV Community

# mssql

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to rotate data using Pivot & Unpivot operators

How to rotate data using Pivot & Unpivot operators

3
Comments 2
3 min read
Triangle Judgement | LeetCode | MSSQL

Triangle Judgement | LeetCode | MSSQL

Comments
2 min read
Customer Placing the Largest Number of Orders | LeetCode | MSSQL

Customer Placing the Largest Number of Orders | LeetCode | MSSQL

Comments
2 min read
Ollivander's Inventory | HackerRank | MSSQL

Ollivander's Inventory | HackerRank | MSSQL

Comments
3 min read
Combine Two Tables | LeetCode | MSSQL

Combine Two Tables | LeetCode | MSSQL

Comments
2 min read
CTE with Multiple Update Statements

CTE with Multiple Update Statements

Comments
2 min read
DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

Comments
2 min read
Sum ActiveStorage::Blob byte_size

Sum ActiveStorage::Blob byte_size

1
Comments
1 min read
How to install MSSQL Server on Ubuntu?

How to install MSSQL Server on Ubuntu?

2
Comments
2 min read
Top Competitors | HackerRank | MSSQL

Top Competitors | HackerRank | MSSQL

6
Comments
2 min read
Temporary tables better than table variables!

Temporary tables better than table variables!

5
Comments
3 min read
How to migrate MSSQL Server DB to PostgreSQL DB?

How to migrate MSSQL Server DB to PostgreSQL DB?

3
Comments
3 min read
Introduction to SQL (Microsoft SQL Server)

Introduction to SQL (Microsoft SQL Server)

8
Comments
27 min read
Quick SQL hint: Use Application Name in connection strings

Quick SQL hint: Use Application Name in connection strings

6
Comments
3 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 #11 - Most intensive queries

SQL-Quick tip #11 - Most intensive queries

10
Comments
2 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
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
SQL-Quick tip #4 - Random Int for each row

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

5
Comments
1 min read
READPAST your problems in SQL

READPAST your problems in SQL

7
Comments
3 min read
SQL date 1900-01-01 appearing out of nowhere

SQL date 1900-01-01 appearing out of nowhere

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

SQL-Quick tip #1 - Range of Int

7
Comments
1 min read
SQL Server Primary Keys

SQL Server Primary Keys

6
Comments
6 min read
VALUES in Microsoft Transact-SQL

VALUES in Microsoft Transact-SQL

5
Comments
2 min read
Calculating length of ntext data type with T-SQL

Calculating length of ntext data type with T-SQL

4
Comments
1 min read
Setup local MS SQL docker container

Setup local MS SQL docker container

6
Comments
5 min read
What is the N prefix in MSSQL all about?

What is the N prefix in MSSQL all about?

5
Comments
3 min read
What is dbo in SQL Server?

What is dbo in SQL Server?

5
Comments
2 min read
Clustered and Nonclustered Indexes

Clustered and Nonclustered Indexes

1
Comments
3 min read
How to prevent duplicate count value for inner join

How to prevent duplicate count value for inner join

5
Comments
1 min read
MS SQL Server and Adminer in Laradock

MS SQL Server and Adminer in Laradock

1
Comments 1
3 min read
Optimizing an SQL Server query

Optimizing an SQL Server query

2
Comments
2 min read
Cara membuat jail fail2ban untuk Microsoft SQL Server (MSSQL)

Cara membuat jail fail2ban untuk Microsoft SQL Server (MSSQL)

6
Comments
2 min read
How to monitor backup and restore progress in SQL Server

How to monitor backup and restore progress in SQL Server

5
Comments
2 min read
Develop, Build, and Deploy Microsoft SQL Databases on macOS

Develop, Build, and Deploy Microsoft SQL Databases on macOS

11
Comments 1
6 min read
Using the Debezium MS SQL connector with ksqlDB embedded Kafka Connect

Using the Debezium MS SQL connector with ksqlDB embedded Kafka Connect

8
Comments
6 min read
Optimizing complex SQL queries and stored procedures

Optimizing complex SQL queries and stored procedures

5
Comments 1
35 min read
MSSQL

MSSQL

4
Comments
1 min read
Microsoft Data Platform Stack Overview

Microsoft Data Platform Stack Overview

13
Comments
8 min read
COVID-19 increased my time for learning

COVID-19 increased my time for learning

5
Comments
3 min read
Reverse Proxy MS SQL with Nginx

Reverse Proxy MS SQL with Nginx

10
Comments 4
1 min read
Entity Framework DotNet Core with GraphQL and SQL Server (using HotChocolate)

Entity Framework DotNet Core with GraphQL and SQL Server (using HotChocolate)

39
Comments 15
5 min read
Querying MySQL from SQL Server using linked server

Querying MySQL from SQL Server using linked server

7
Comments
5 min read
Using data from MSSQL linked server with EF Core

Using data from MSSQL linked server with EF Core

7
Comments
4 min read
Using Common Table Expressions to solve Sudoku in Microsoft SQL Server

Using Common Table Expressions to solve Sudoku in Microsoft SQL Server

6
Comments
5 min read
Building a fully reactive and scalable Spring application with R2DBC and a serverless database

Building a fully reactive and scalable Spring application with R2DBC and a serverless database

54
Comments 1
5 min read
Dotnet Core Webapi With Microsoft SQL Server in Docker - Part 1

Dotnet Core Webapi With Microsoft SQL Server in Docker - Part 1

9
Comments
6 min read
Setting up a Laravel project with SQL Server AND XAMPP / WAMP on Windows

Setting up a Laravel project with SQL Server AND XAMPP / WAMP on Windows

36
Comments 12
3 min read
6 MSSQL Interview Questions for Experienced

6 MSSQL Interview Questions for Experienced

17
Comments
3 min read
Need a little help here.

Need a little help here.

9
Comments 8
1 min read
Monitoring my solar system from the cloud

Monitoring my solar system from the cloud

2
Comments
1 min read
MS SQL Server Backups to S3 – On Linux!

MS SQL Server Backups to S3 – On Linux!

7
Comments
3 min read
loading...