Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
#
sqlserver
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Sql Server Multi Column Index Improvements
Akash Kava
Akash Kava
Akash Kava
Follow
Jul 12 '19
Sql Server Multi Column Index Improvements
#
showdev
#
sql
#
sqlserver
#
discuss
9
reactions
Comments
Add Comment
2 min read
Youtube Video: ASP.NET Core Web API (Rest API) with Entity Framework Core, SQL Server and Visual Studio Code
jalpesh Vadgama
jalpesh Vadgama
jalpesh Vadgama
Follow
Jul 4 '19
Youtube Video: ASP.NET Core Web API (Rest API) with Entity Framework Core, SQL Server and Visual Studio Code
#
aspnet
#
aspnetcore
#
efcore
#
sqlserver
11
reactions
Comments
Add Comment
2 min read
SQL Server Row Versions
Joe Lowrance
Joe Lowrance
Joe Lowrance
Follow
Jun 15 '19
SQL Server Row Versions
#
sqlserver
5
reactions
Comments
Add Comment
2 min read
Microsoft SQL Server Client 2017 on Debian 9
nabbisen
nabbisen
nabbisen
Follow
May 23 '19
Microsoft SQL Server Client 2017 on Debian 9
#
sqlserver
#
database
#
debian
#
virtualbox
13
reactions
Comments
5
comments
2 min read
sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"
nabbisen
nabbisen
nabbisen
Follow
May 23 '19
sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"
#
sqlserver
#
database
#
sqlcmd
#
troubleshooting
6
reactions
Comments
3
comments
1 min read
Microsoft SQL Server 2017 on Debian 9
nabbisen
nabbisen
nabbisen
Follow
May 22 '19
Microsoft SQL Server 2017 on Debian 9
#
sqlserver
#
database
#
debian
#
virtualbox
17
reactions
Comments
Add Comment
2 min read
Experimenting Flyway with SQL Server
Praneet Nadkar
Praneet Nadkar
Praneet Nadkar
Follow
Mar 13 '19
Experimenting Flyway with SQL Server
#
sqlserver
#
sql
#
database
#
flyway
7
reactions
Comments
Add Comment
2 min read
The best and easy way to handle database migrations (version control)
Junior Oliveira
Junior Oliveira
Junior Oliveira
Follow
Apr 21 '19
The best and easy way to handle database migrations (version control)
#
database
#
migrations
#
mysql
#
sqlserver
19
reactions
Comments
Add Comment
2 min read
Bug Report #1 - GETUTCDATE() In Longer Queries
Horia Coman
Horia Coman
Horia Coman
Follow
Jan 20 '19
Bug Report #1 - GETUTCDATE() In Longer Queries
#
bugreport
#
sqlserver
#
getutcdate
#
post
7
reactions
Comments
Add Comment
2 min read
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Bert Wagner
Bert Wagner
Bert Wagner
Follow
Nov 14 '18
Bert & Pinal Troubleshoot a Slow Performing SQL Server
#
sql
#
performance
#
sqlserver
7
reactions
Comments
Add Comment
1 min read
My .NET Core Setup for MacOS/Linux
Christian Vasquez
Christian Vasquez
Christian Vasquez
Follow
Oct 13 '18
My .NET Core Setup for MacOS/Linux
#
dotnet
#
core
#
docker
#
sqlserver
150
reactions
Comments
26
comments
4 min read
Azure Data Studio: Initial thoughts and walk-through
Will Velida
Will Velida
Will Velida
Follow
Sep 25 '18
Azure Data Studio: Initial thoughts and walk-through
#
azure
#
data
#
sqlserver
#
database
12
reactions
Comments
Add Comment
4 min read
SQL Server: cuáles son las diferencias entre @@identity y Scope_identity
José M. Alarcón 🌐
José M. Alarcón 🌐
José M. Alarcón 🌐
Follow
for
campusMVP
Sep 20 '18
SQL Server: cuáles son las diferencias entre @@identity y Scope_identity
#
database
#
sqlserver
#
spanish
12
reactions
Comments
Add Comment
3 min read
Review: SQL Operations Studio (Preview) for SQL Server
randysims
randysims
randysims
Follow
Sep 4 '18
Review: SQL Operations Studio (Preview) for SQL Server
#
sqlserver
#
devtools
#
review
11
reactions
Comments
Add Comment
1 min read
Using C# LINQ API to perform SQL IN logic at WHERE clause
Alex Ruzenhack
Alex Ruzenhack
Alex Ruzenhack
Follow
Aug 30 '18
Using C# LINQ API to perform SQL IN logic at WHERE clause
#
csharp
#
sql
#
linq
#
sqlserver
22
reactions
Comments
9
comments
1 min read
SQL Server’s [N]VARCHAR(MAX) and How to Wield It
randysims
randysims
randysims
Follow
Aug 30 '18
SQL Server’s [N]VARCHAR(MAX) and How to Wield It
#
sqlserver
#
datatypes
#
sql
8
reactions
Comments
Add Comment
1 min read
Add a unique nullable index to an entity property
Alex Ruzenhack
Alex Ruzenhack
Alex Ruzenhack
Follow
Aug 29 '18
Add a unique nullable index to an entity property
#
csharp
#
entityframework
#
dotnetcoreidentity
#
sqlserver
9
reactions
Comments
4
comments
2 min read
Open source tools for SQL Server on Linux
Shayne Boyer
Shayne Boyer
Shayne Boyer
Follow
Jul 23 '18
Open source tools for SQL Server on Linux
#
linux
#
opensource
#
sqlserver
13
reactions
Comments
Add Comment
3 min read
Automating restoration of production databases into test using AWS RDS
Jeremy Gunzburg
Jeremy Gunzburg
Jeremy Gunzburg
Follow
May 8 '18
Automating restoration of production databases into test using AWS RDS
#
aws
#
rds
#
sqlserver
#
aurora
18
reactions
Comments
5
comments
4 min read
Exporting scripts from SQL Server for use with DBUp
Jeremy Gunzburg
Jeremy Gunzburg
Jeremy Gunzburg
Follow
Apr 18 '18
Exporting scripts from SQL Server for use with DBUp
#
dbup
#
sqlserver
10
reactions
Comments
3
comments
2 min read
How to work with stored procedures and not die trying
Darío Kondratiuk
Darío Kondratiuk
Darío Kondratiuk
Follow
Jan 11 '18
How to work with stored procedures and not die trying
#
sqlserver
#
visualstudio
#
storedprocedures
33
reactions
Comments
11
comments
8 min read
SQL Server Running on a Mac?!
David Neal
David Neal
David Neal
Follow
Oct 3 '17
SQL Server Running on a Mac?!
#
docker
#
devops
#
sqlserver
#
node
24
reactions
Comments
4
comments
5 min read
Create your first REST API with ASP.NET Core And Visual Studio Part-1
jalpesh Vadgama
jalpesh Vadgama
jalpesh Vadgama
Follow
Aug 10 '20
Create your first REST API with ASP.NET Core And Visual Studio Part-1
#
aspnet
#
aspnetcore
#
efcore
#
sqlserver
5
reactions
Comments
Add Comment
1 min read
Checking if the column was updated inside SQLServer update trigger
Ravenous Baboon
Ravenous Baboon
Ravenous Baboon
Follow
Aug 17 '17
Checking if the column was updated inside SQLServer update trigger
#
sqlserver
#
database
#
triggers
22
reactions
Comments
1
comment
1 min read
Find the SQL Server service account with sys.dm_server_services
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
May 18 '20
Find the SQL Server service account with sys.dm_server_services
#
sql
#
sqlserver
#
database
#
tsql
4
reactions
Comments
Add Comment
2 min read
Tips and tricks for SQL Server database (table) design?
Kate Naylor
Kate Naylor
Kate Naylor
Follow
May 15 '20
Tips and tricks for SQL Server database (table) design?
#
sql
#
sqlserver
#
database
#
crud
3
reactions
Comments
1
comment
3 min read
Quick Check of SQL Table Contents With Data Visualizers
Kate Naylor
Kate Naylor
Kate Naylor
Follow
May 7 '20
Quick Check of SQL Table Contents With Data Visualizers
#
sql
#
database
#
visualization
#
sqlserver
2
reactions
Comments
Add Comment
3 min read
Making non-SARGable queries seek, without changing the query
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
May 7 '20
Making non-SARGable queries seek, without changing the query
#
sql
#
database
#
sqlserver
#
performance
5
reactions
Comments
Add Comment
3 min read
Stop trying to shrink tempdb files
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
May 5 '20
Stop trying to shrink tempdb files
#
sql
#
sqlserver
#
database
5
reactions
Comments
Add Comment
4 min read
When STRING_SPLIT() falls short
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Mar 20 '20
When STRING_SPLIT() falls short
#
sql
#
sqlserver
#
performance
5
reactions
Comments
Add Comment
3 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4
Devart Software
Devart Software
Devart Software
Follow
Feb 24 '20
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4
#
sqlserver
#
sql
#
database
#
debugging
4
reactions
Comments
Add Comment
2 min read
What the heck is Accelerated Database Recovery?
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
What the heck is Accelerated Database Recovery?
#
sql
#
sqlserver
#
recovery
5
reactions
Comments
Add Comment
3 min read
How to create date buckets in T-SQL
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
How to create date buckets in T-SQL
#
sql
#
sqlserver
7
reactions
Comments
Add Comment
5 min read
Using PowerShell to tidy up CSV files
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Using PowerShell to tidy up CSV files
#
powershell
#
sql
#
sqlserver
7
reactions
Comments
Add Comment
3 min read
Testing as another user…without their password
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Testing as another user…without their password
#
sql
#
sqlserver
#
security
7
reactions
Comments
Add Comment
5 min read
What the heck is the dbcreator role?
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
What the heck is the dbcreator role?
#
sql
#
sqlserver
#
security
6
reactions
Comments
Add Comment
3 min read
When to put a non-clustered index on your clustering key
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
When to put a non-clustered index on your clustering key
#
sql
#
sqlserver
#
indexes
6
reactions
Comments
Add Comment
2 min read
Data Blogger Resource Kit
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Data Blogger Resource Kit
#
career
#
sql
#
sqlserver
7
reactions
Comments
Add Comment
3 min read
How does a database RESTORE affect plan cache?
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
How does a database RESTORE affect plan cache?
#
sql
#
sqlserver
#
backup
6
reactions
Comments
Add Comment
7 min read
I hate sp_estimate_data_compression_savings
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
I hate sp_estimate_data_compression_savings
#
sql
#
sqlserver
#
datacompression
5
reactions
Comments
Add Comment
6 min read
Failure is always an option
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Failure is always an option
#
career
#
sql
#
sqlserver
9
reactions
Comments
Add Comment
5 min read
Why does ALTER let me DROP?
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Why does ALTER let me DROP?
#
sql
#
sqlserver
6
reactions
Comments
Add Comment
4 min read
Configuring the distribution database in an Availability Group
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Configuring the distribution database in an Availability Group
#
sql
#
sqlserver
#
availabilitygroups
#
replication
5
reactions
Comments
Add Comment
3 min read
What the heck is downtime, anyway?
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
What the heck is downtime, anyway?
#
career
#
sql
#
sqlserver
5
reactions
Comments
Add Comment
3 min read
The thrill of purging old data
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
The thrill of purging old data
#
automation
#
performance
#
sql
#
sqlserver
5
reactions
Comments
Add Comment
4 min read
Recovery of database is 0% complete (approximately 1000000 seconds remain)
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Recovery of database is 0% complete (approximately 1000000 seconds remain)
#
sqlserver
#
sql
#
recovery
6
reactions
Comments
Add Comment
4 min read
New Formatting Profiles in SQL Complete v6.3
Devart Software
Devart Software
Devart Software
Follow
Dec 19 '19
New Formatting Profiles in SQL Complete v6.3
#
sql
#
sqlserver
#
dbforge
#
database
7
reactions
Comments
Add Comment
2 min read
dbForge Fusion Now Supports Visual Studio 2019
Devart Software
Devart Software
Devart Software
Follow
Nov 11 '19
dbForge Fusion Now Supports Visual Studio 2019
#
sqlserver
#
mysql
#
oracle
#
visualstudio
3
reactions
Comments
Add Comment
1 min read
View and Read SQL Server Transaction Log Data
andreasneuman
andreasneuman
andreasneuman
Follow
Nov 7 '19
View and Read SQL Server Transaction Log Data
#
sql
#
sqlserver
#
database
#
productivity
5
reactions
Comments
1
comment
1 min read
How to Run SQL Server on a Mac
Pete Freitag
Pete Freitag
Pete Freitag
Follow
Oct 21 '19
How to Run SQL Server on a Mac
#
database
#
mac
#
sqlserver
#
docker
7
reactions
Comments
Add Comment
2 min read
Massive Improvement of dbForge Studio for SQL Server 5.8
Devart Software
Devart Software
Devart Software
Follow
Oct 15 '19
Massive Improvement of dbForge Studio for SQL Server 5.8
#
sqlserver
#
database
#
schemacompare
5
reactions
Comments
Add Comment
2 min read
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete
Devart Software
Devart Software
Devart Software
Follow
Oct 7 '19
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete
#
sql
#
sqlserver
#
database
#
dbforge
5
reactions
Comments
Add Comment
2 min read
dbForge Transaction Log – A New Tool Made by Devart
Devart Software
Devart Software
Devart Software
Follow
Sep 25 '19
dbForge Transaction Log – A New Tool Made by Devart
#
sqlserver
#
sql
#
transactionlog
#
database
3
reactions
Comments
Add Comment
2 min read
Query to get Primary Key & Foreign Key columns
LFC
LFC
LFC
Follow
Sep 24 '19
Query to get Primary Key & Foreign Key columns
#
sql
#
database
#
sqlserver
4
reactions
Comments
Add Comment
1 min read
A Huge Update of dbForge Compare Bundle for SQL Server
Devart Software
Devart Software
Devart Software
Follow
Sep 5 '19
A Huge Update of dbForge Compare Bundle for SQL Server
#
sqlserver
#
databaseadministration
#
ssms
6
reactions
Comments
Add Comment
2 min read
dbForge Source Control Now Allows Version-Controlling of Static Data
Devart Software
Devart Software
Devart Software
Follow
Aug 5 '19
dbForge Source Control Now Allows Version-Controlling of Static Data
#
sqlserver
#
msssms
#
dbforge
#
databaseadministration
2
reactions
Comments
Add Comment
2 min read
With Love to Productivity and Great Discounts!
Devart Software
Devart Software
Devart Software
Follow
Feb 1 '19
With Love to Productivity and Great Discounts!
#
software
#
sqlserver
#
mysql
#
oracle
3
reactions
Comments
Add Comment
1 min read
Visualizing Hash Match Join Internals And Understanding Their Implications
Bert Wagner
Bert Wagner
Bert Wagner
Follow
Jan 21 '19
Visualizing Hash Match Join Internals And Understanding Their Implications
#
sqlserver
#
algorithms
#
performancetuning
#
programming
3
reactions
Comments
Add Comment
4 min read
Visualizing Merge Join Internals And Understanding Their Implications
Bert Wagner
Bert Wagner
Bert Wagner
Follow
Jan 2 '19
Visualizing Merge Join Internals And Understanding Their Implications
#
sqlserver
#
algorithms
#
performancetuning
8
reactions
Comments
Add Comment
4 min read
Developer Bundle will take you to 2019 right now!
Devart Software
Devart Software
Devart Software
Follow
Dec 24 '18
Developer Bundle will take you to 2019 right now!
#
sqlserver
#
databasedevelopment
#
sqlservertools
3
reactions
Comments
Add Comment
1 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account