DEV Community

loading...

# sqlserver

👋 Sign in for the ability sort posts by top and latest.
Common Table Expressions(CTE) in SQL Server

Common Table Expressions(CTE) in SQL Server

Reactions 4 Comments
12 min read
Alter SQL Server Temporal Table

Alter SQL Server Temporal Table

Reactions 4 Comments
1 min read
How To Export Data From Database Query To XML

How To Export Data From Database Query To XML

Reactions 4 Comments
5 min read
Case Senstive Columns in SQL Server

Case Senstive Columns in SQL Server

Reactions 4 Comments
1 min read
SQL Server Temporal Tables

SQL Server Temporal Tables

Reactions 6 Comments
1 min read
SQL Server Reporting Services en .Net Core

SQL Server Reporting Services en .Net Core

Reactions 5 Comments
2 min read
Obtener valores tipados de IDataReader

Obtener valores tipados de IDataReader

Reactions 5 Comments
2 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

Reactions 2 Comments
3 min read
IT Toolbox: CLR Stored Procs versus TSQL Stored Procs – Round 2

IT Toolbox: CLR Stored Procs versus TSQL Stored Procs – Round 2

Reactions 5 Comments
11 min read
GUID Primary Keys

GUID Primary Keys

Reactions 5 Comments
1 min read
SQL Server on Linux via Docker

SQL Server on Linux via Docker

Reactions 2 Comments
1 min read
Base64 Conversions in SQL Server

Base64 Conversions in SQL Server

Reactions 4 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

Reactions 5 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

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

Geohash Open-Source library in TSQL for SQL Server

Reactions 4 Comments
1 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

Reactions 2 Comments 2
1 min read
Three differences between TRUNCATE and DELETE

Three differences between TRUNCATE and DELETE

Reactions 6 Comments
4 min read
Transformando varias linhas em uma linha só

Transformando varias linhas em uma linha só

Reactions 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#

Reactions 3 Comments 1
6 min read
How I Learned to Love Databases

How I Learned to Love Databases

Reactions 62 Comments 2
8 min read
SQL Local DB

SQL Local DB

Reactions 6 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

Reactions 3 Comments
2 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

Reactions 3 Comments
1 min read
SQL Server huge data performance points

SQL Server huge data performance points

Reactions 5 Comments
2 min read
Como concatenar o texto de várias linhas em uma única sequência de texto no SQL server?

Como concatenar o texto de várias linhas em uma única sequência de texto no SQL server?

Reactions 1 Comments
1 min read
Explore data system design with C# and SQL Server

Explore data system design with C# and SQL Server

Reactions 5 Comments
8 min read
Querying MySQL from SQL Server using linked server

Querying MySQL from SQL Server using linked server

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

Using data from MSSQL linked server with EF Core

Reactions 7 Comments
4 min read
List users in SQL Server database

List users in SQL Server database

Reactions 4 Comments
1 min read
Using Docker for local SQL Server development

Using Docker for local SQL Server development

Reactions 18 Comments
4 min read
SQL Server Management Studio

SQL Server Management Studio

Reactions 3 Comments
2 min read
Runaway SQL Log growth

Runaway SQL Log growth

Reactions 3 Comments
2 min read
Tools | Data Tools and Software

Tools | Data Tools and Software

Reactions 8 Comments 1
4 min read
Running SQL Server in Docker

Running SQL Server in Docker

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

Getting Starting With Python For Data Exploration

Reactions 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?

Reactions 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

Reactions 8 Comments
12 min read
Using Python to create SqlServer tables with random schema

Using Python to create SqlServer tables with random schema

Reactions 7 Comments
1 min read
Purging data with batched deletes

Purging data with batched deletes

Reactions 6 Comments
5 min read
Code to purge data based on creation date

Code to purge data based on creation date

Reactions 6 Comments
5 min read
Changing a column from int to bigint, without downtime

Changing a column from int to bigint, without downtime

Reactions 5 Comments
9 min read
What the heck is the SQL Server Version Store?

What the heck is the SQL Server Version Store?

Reactions 3 Comments
4 min read
Blocking with OBJECT_NAME()

Blocking with OBJECT_NAME()

Reactions 5 Comments 1
4 min read
SQL Server’s identity column misconceptions

SQL Server’s identity column misconceptions

Reactions 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

Reactions 7 Comments 2
3 min read
CONNX Integration with Microsoft SQL server

CONNX Integration with Microsoft SQL server

Reactions 4 Comments
10 min read
Tales from Technological Backwaters

Tales from Technological Backwaters

Reactions 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

Reactions 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 

Reactions 13 Comments
2 min read
Understanding SQL Server Deadlocks

Understanding SQL Server Deadlocks

Reactions 79 Comments 1
5 min read
SQL Server Locking

SQL Server Locking

Reactions 13 Comments
3 min read
SQL Server Transactions and Isolation Levels

SQL Server Transactions and Isolation Levels

Reactions 18 Comments
3 min read
Name your Constraints

Name your Constraints

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

Reinventing SSIS scripting with JavaScript - COZYROC

Reactions 8 Comments
1 min read
Sql Server Multi Column Index Improvements

Sql Server Multi Column Index Improvements

Reactions 9 Comments
2 min read
SQL Server Row Versions

SQL Server Row Versions

Reactions 5 Comments
2 min read
sqlcmd's error: "locale::facet::_S_create_c_locale name not valid"

sqlcmd's error: "locale::facet::_S_create_c_locale name not valid"

Reactions 6 Comments 3
1 min read
The best and easy way to handle database migrations (version control)

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

Reactions 19 Comments
2 min read
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

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

Bug Report #1 - GETUTCDATE() In Longer Queries

Reactions 8 Comments
2 min read
loading...