DEV Community

# sqlserver

Posts

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

17
Comments 2
6 min read
SQL Local DB

SQL Local DB

11
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

15
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

5
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
Containers | QuickStart Docker Compose for SQL Server

Containers | QuickStart Docker Compose for SQL Server

6
Comments
3 min read
Tools | Data Tools and Software

Tools | Data Tools and Software

10
Comments 1
4 min read
Running SQL Server in Docker

Running SQL Server in Docker

6
Comments
4 min read
Getting Starting With Python For Data Exploration

Getting Starting With Python For Data Exploration

7
Comments
7 min read
Would you like to have better XML support in SQL Server?

Would you like to have better XML support in SQL Server?

5
Comments
1 min read
Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

11
Comments 2
12 min read
Using Python to create SqlServer tables with random schema

Using Python to create SqlServer tables with random schema

6
Comments
1 min read
Quill SQL Server: Returning via OUTPUT

Quill SQL Server: Returning via OUTPUT

6
Comments
2 min read
SQL Server’s identity column misconceptions

SQL Server’s identity column misconceptions

8
Comments
3 min read
Use the right tool to get identity values back after an insert

Use the right tool to get identity values back after an insert

14
Comments 2
3 min read
CONNX Integration with Microsoft SQL server

CONNX Integration with Microsoft SQL server

4
Comments
10 min read
Tales from Technological Backwaters

Tales from Technological Backwaters

6
Comments
3 min read
How To Work With Memory Optimized Objects in SQL Server

How To Work With Memory Optimized Objects in SQL Server

7
Comments
6 min read
The do’s and don’ts of dynamic SQL for SQL Server 

The do’s and don’ts of dynamic SQL for SQL Server 

12
Comments
2 min read
Understanding SQL Server Deadlocks

Understanding SQL Server Deadlocks

82
Comments 1
5 min read
SQL Server Locking

SQL Server Locking

14
Comments
3 min read
SQL Server Transactions and Isolation Levels

SQL Server Transactions and Isolation Levels

19
Comments
3 min read
Name your Constraints

Name your Constraints

21
Comments 1
2 min read
Reinventing SSIS scripting with JavaScript - COZYROC

Reinventing SSIS scripting with JavaScript - COZYROC

8
Comments
1 min read
Sql Server Multi Column Index Improvements

Sql Server Multi Column Index Improvements

9
Comments
2 min read
Youtube Video: ASP.NET Core Web API (Rest API) with Entity Framework Core, SQL Server and Visual Studio Code

Youtube Video: ASP.NET Core Web API (Rest API) with Entity Framework Core, SQL Server and Visual Studio Code

11
Comments
2 min read
SQL Server Row Versions

SQL Server Row Versions

5
Comments
2 min read
Microsoft SQL Server Client 2017 on Debian 9

Microsoft SQL Server Client 2017 on Debian 9

17
Comments 5
2 min read
sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"

sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"

6
Comments 3
1 min read
Microsoft SQL Server 2017 on Debian 9

Microsoft SQL Server 2017 on Debian 9

17
Comments
2 min read
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

7
Comments
2 min read
The best and easy way to handle database migrations (version control)

The best and easy way to handle database migrations (version control)

19
Comments
2 min read
Bug Report #1 - GETUTCDATE() In Longer Queries

Bug Report #1 - GETUTCDATE() In Longer Queries

7
Comments
2 min read
Bert & Pinal Troubleshoot a Slow Performing SQL Server

Bert & Pinal Troubleshoot a Slow Performing SQL Server

7
Comments
1 min read
My .NET Core Setup for MacOS/Linux

My .NET Core Setup for MacOS/Linux

150
Comments 26
4 min read
Azure Data Studio: Initial thoughts and walk-through

Azure Data Studio: Initial thoughts and walk-through

12
Comments
4 min read
SQL Server: cuáles son las diferencias entre @@identity y Scope_identity

SQL Server: cuáles son las diferencias entre @@identity y Scope_identity

12
Comments
3 min read
Review: SQL Operations Studio (Preview) for SQL Server

Review: SQL Operations Studio (Preview) for SQL Server

11
Comments
1 min read
Using C# LINQ API to perform SQL IN logic at WHERE clause

Using C# LINQ API to perform SQL IN logic at WHERE clause

22
Comments 9
1 min read
Add a unique nullable index to an entity property

Add a unique nullable index to an entity property

9
Comments 4
2 min read
SQL Server’s [N]VARCHAR(MAX) and How to Wield It

SQL Server’s [N]VARCHAR(MAX) and How to Wield It

8
Comments
1 min read
Open source tools for SQL Server on Linux

Open source tools for SQL Server on Linux

13
Comments
3 min read
Automating restoration of production databases into test using AWS RDS

Automating restoration of production databases into test using AWS RDS

18
Comments 5
4 min read
Exporting scripts from SQL Server for use with DBUp

Exporting scripts from SQL Server for use with DBUp

10
Comments 3
2 min read
How to work with stored procedures and not die trying

How to work with stored procedures and not die trying

33
Comments 11
8 min read
SQL Server Running on a Mac?!

SQL Server Running on a Mac?!

24
Comments 4
5 min read
Create your first REST API with ASP.NET Core And Visual Studio Part-1

Create your first REST API with ASP.NET Core And Visual Studio Part-1

5
Comments
1 min read
loading...