DEV Community

# sqlserver

Posts

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

13
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
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
Add a unique nullable index to an entity property

Add a unique nullable index to an entity property

9
Comments 4
2 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
Checking if the column was updated inside SQLServer update trigger

Checking if the column was updated inside SQLServer update trigger

22
Comments 1
1 min read
Find the SQL Server service account with sys.dm_server_services

Find the SQL Server service account with sys.dm_server_services

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

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

3
Comments 1
3 min read
Quick Check of SQL Table Contents With Data Visualizers

Quick Check of SQL Table Contents With Data Visualizers

2
Comments
3 min read
Making non-SARGable queries seek, without changing the query

Making non-SARGable queries seek, without changing the query

5
Comments
3 min read
Stop trying to shrink tempdb files

Stop trying to shrink tempdb files

5
Comments
4 min read
When STRING_SPLIT() falls short

When STRING_SPLIT() falls short

5
Comments
3 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
What the heck is Accelerated Database Recovery?

What the heck is Accelerated Database Recovery?

5
Comments
3 min read
How to create date buckets in T-SQL

How to create date buckets in T-SQL

7
Comments
5 min read
Using PowerShell to tidy up CSV files

Using PowerShell to tidy up CSV files

7
Comments
3 min read
Testing as another user…without their password

Testing as another user…without their password

7
Comments
5 min read
What the heck is the dbcreator role?

What the heck is the dbcreator role?

6
Comments
3 min read
When to put a non-clustered index on your clustering key

When to put a non-clustered index on your clustering key

6
Comments
2 min read
Data Blogger Resource Kit

Data Blogger Resource Kit

7
Comments
3 min read
How does a database RESTORE affect plan cache?

How does a database RESTORE affect plan cache?

6
Comments
7 min read
I hate sp_estimate_data_compression_savings

I hate sp_estimate_data_compression_savings

5
Comments
6 min read
Failure is always an option

Failure is always an option

9
Comments
5 min read
Why does ALTER let me DROP?

Why does ALTER let me DROP?

6
Comments
4 min read
Configuring the distribution database in an Availability Group

Configuring the distribution database in an Availability Group

5
Comments
3 min read
What the heck is downtime, anyway?

What the heck is downtime, anyway?

5
Comments
3 min read
The thrill of purging old data

The thrill of purging old data

5
Comments
4 min read
Recovery of database is 0% complete (approximately 1000000 seconds remain)

Recovery of database is 0% complete (approximately 1000000 seconds remain)

6
Comments
4 min read
New Formatting Profiles in SQL Complete v6.3

New Formatting Profiles in SQL Complete v6.3

7
Comments
2 min read
dbForge Fusion Now Supports Visual Studio 2019

dbForge Fusion Now Supports Visual Studio 2019

3
Comments
1 min read
View and Read SQL Server Transaction Log Data

View and Read SQL Server Transaction Log Data

5
Comments 1
1 min read
How to Run SQL Server on a Mac

How to Run SQL Server on a Mac

7
Comments
2 min read
Massive Improvement of dbForge Studio for SQL Server 5.8

Massive Improvement of dbForge Studio for SQL Server 5.8

5
Comments
2 min read
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

5
Comments
2 min read
dbForge Transaction Log – A New Tool Made by Devart

dbForge Transaction Log – A New Tool Made by Devart

3
Comments
2 min read
Query to get Primary Key & Foreign Key columns

Query to get Primary Key & Foreign Key columns

4
Comments
1 min read
A Huge Update of dbForge Compare Bundle for SQL Server

A Huge Update of dbForge Compare Bundle for SQL Server

6
Comments
2 min read
dbForge Source Control Now Allows Version-Controlling of Static Data

dbForge Source Control Now Allows Version-Controlling of Static Data

2
Comments
2 min read
With Love to Productivity and Great Discounts!

With Love to Productivity and Great Discounts!

3
Comments
1 min read
Visualizing Hash Match Join Internals And Understanding Their Implications

Visualizing Hash Match Join Internals And Understanding Their Implications

3
Comments
4 min read
Visualizing Merge Join Internals And Understanding Their Implications

Visualizing Merge Join Internals And Understanding Their Implications

8
Comments
4 min read
Developer Bundle will take you to 2019 right now!

Developer Bundle will take you to 2019 right now!

3
Comments
1 min read
loading...