DEV Community

# sqlserver

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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 #8 - Finding foreign key constraints

SQL-Quick tip #8 - Finding foreign key constraints

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

SQL-Quick tip #12 - Available disk space

5
Comments
2 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 #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

10
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

18
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

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

SQL-Quick tip #1 - Range of Int

7
Comments
1 min read
Get rid of an MS SQL Server database in SingleUserMode

Get rid of an MS SQL Server database in SingleUserMode

6
Comments
1 min read
How to generate Permutations in SQL?

How to generate Permutations in SQL?

5
Comments
2 min read
#008 How to Enable Dark Theme in SQL SERVER Management Studio 18 in 6 quick steps

#008 How to Enable Dark Theme in SQL SERVER Management Studio 18 in 6 quick steps

4
Comments
1 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?

8
Comments
2 min read
Clustered and Nonclustered Indexes

Clustered and Nonclustered Indexes

1
Comments
3 min read
🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

5
Comments
3 min read
Connect to Local SQL Server from Docker container

Connect to Local SQL Server from Docker container

7
Comments
3 min read
How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭

How to Create Reports from SQL Server Databases with List & Label to Have More Time for ...hm, Let's Say, Sweets 🍭

7
Comments
2 min read
DEVELOPING HOTEL MANAGEMENT APP WITH RADZEN BLAZOR WEB ASSEMBLY (LESSON FIVE) CUSTOM SECURITY PART 1

DEVELOPING HOTEL MANAGEMENT APP WITH RADZEN BLAZOR WEB ASSEMBLY (LESSON FIVE) CUSTOM SECURITY PART 1

2
Comments
1 min read
How to create a table in SQL Server

How to create a table in SQL Server

2
Comments
3 min read
Common Table Expressions(CTE) in SQL Server

Common Table Expressions(CTE) in SQL Server

6
Comments 2
12 min read
SQL Server Reporting Services en .Net Core

SQL Server Reporting Services en .Net Core

12
Comments
2 min read
Obtener valores tipados de IDataReader

Obtener valores tipados de IDataReader

5
Comments
2 min read
How To Export Data From Database Query To XML

How To Export Data From Database Query To XML

5
Comments
5 min read
Creating a custom SQL Server Docker Image on top of the Official Image

Creating a custom SQL Server Docker Image on top of the Official Image

2
Comments
3 min read
SQL Server on Linux via Docker

SQL Server on Linux via Docker

2
Comments
1 min read
Executando o SQL Server em um contêiner docker 🐳 no windows

Executando o SQL Server em um contêiner docker 🐳 no windows

8
Comments
2 min read
CRUD Operation with ASP.NET Core MVC, Entity Framework Core And SQL Server

CRUD Operation with ASP.NET Core MVC, Entity Framework Core And SQL Server

7
Comments
1 min read
Geohash Open-Source library in TSQL for SQL Server

Geohash Open-Source library in TSQL for SQL Server

4
Comments
1 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

2
Comments 2
1 min read
Transformando varias linhas em uma linha só

Transformando varias linhas em uma linha só

2
Comments
1 min read
Building a machine learning model with SQL Server, ML.NET and C#

Building a machine learning model with SQL Server, ML.NET and C#

16
Comments 2
6 min read
SQL Local DB

SQL Local DB

10
Comments
5 min read
How to see a history of queries ran on a SQL server

How to see a history of queries ran on a SQL server

14
Comments 2
2 min read
Set up Extended Events in SQL Server

Set up Extended Events in SQL Server

3
Comments 1
5 min read
Easy way select the right column as Primary Key for a given table

Easy way select the right column as Primary Key for a given table

3
Comments
1 min read
SQL Server huge data performance points

SQL Server huge data performance points

5
Comments
2 min read
Tips and tricks for SQL Server database (table) design?

Tips and tricks for SQL Server database (table) design?

4
Comments 1
3 min read
Connecting your ASP.NET core application to a local instance of SQLServer

Connecting your ASP.NET core application to a local instance of SQLServer

3
Comments
2 min read
Explore data system design with C# and SQL Server

Explore data system design with C# and SQL Server

5
Comments
8 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
Manually setting up an Azure VM to Host SQL Server

Manually setting up an Azure VM to Host SQL Server

6
Comments
7 min read
List users in SQL Server database

List users in SQL Server database

4
Comments
1 min read
Containers | Building a local TSQL development environment

Containers | Building a local TSQL development environment

6
Comments
3 min read
Using Docker for local SQL Server development

Using Docker for local SQL Server development

19
Comments
4 min read
loading...