44 questions from the last 30 days
-2
votes
0
answers
42
views
Intermittent Database Connection Issues when using SSMS [closed]
I'm having intermittent connectivity problems when trying to connect to an azure based SQL database when using SSMS. I've done the following troubleshooting:
The exact same version of SSMS has been ...
- 81
0
votes
0
answers
47
views
Best practice for backing up large SQL Server databases to S3 [closed]
We are currently backing up all of our databases to a series S3-Compatibable storageGRID buckets hosted by our data center provider. Some of our larger databases backups run quite long (upwards of 8 ...
-3
votes
1
answer
51
views
Connecting SQL Server to Cypress
I am trying to connect the DB for testing web elements that have dependencies on data, and in general to add some reliable BE testing.
Currently I have cypress.config.js:
// cypress.config.js
const { ...
- 25
0
votes
0
answers
68
views
EF Core 9 migration fails on production database copy with "Cannot release the application lock" error
I'm using EF Core 9 and I'm trying to run a migration against a copy of our production database.
On our local development databases everything works, but on the production copy the migration fails ...
- 633
0
votes
1
answer
127
views
SQL CLR function bad performance comparing to .NET App
In our system we are hashing passwords with the following method.
public static string HashPassword(string password, byte[] salt)
{
if (salt == null)
{
throw new ArgumentNullException($...
- 377
0
votes
0
answers
67
views
Long-running procedure being terminated before finishing
We have an End-to-End process which loads data into a Landing database. It used to run individual repopulate scripts for each data source in sequence, but that was taking more and more time to the ...
- 19
-1
votes
0
answers
22
views
SQL Server Express Master database corrupted tables [migrated]
I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around ...
- 75
-1
votes
0
answers
43
views
SQL Server 2022 LinkedServer connector with Google BiQuery SIMBA ODBC is throwing the error [closed]
We were using SQL Server 2016 with SimbaODBCDriverforGoogleBigQuery connector and that was working as expected but when we migrated the SQL Server & OS to 2022, the ...
-1
votes
0
answers
49
views
sqlpackage.exe trying to alter column even though no changes are visible [closed]
I have an Azure Managed SQL Instance with SQL Server 2022, I'm trying to add column-level encryption to source control (Azure DevOps pipeline/Git) where it's already configured/deployed on the target ...
- 4,113
Advice
0
votes
2
replies
83
views
Process improvements, A company wants to incorporate AI but the current process hadn't change in 25 years
Goal
The company wants to grow and take advantage of the AI revolution. But there is no roadmap and the current process limits their growth capability. The current process is about 20% automation and ...
- 67
1
vote
2
answers
109
views
Clustered columnstore index with computed column -- why does segment elimination not work?
Recent versions of Microsoft SQL Server allow creating a clustered columnstore index on a table that has computed columns, as long as they are not persisted computed columns. [1]
I would like to get ...
- 1,622
Advice
1
vote
12
replies
154
views
Advice for archiving SQL Server data of a selected date range into a text file
We have some tables in an on-premises SQL Server database that we archive data every day.
Currently, we have a schedule task that runs a C# program, that write old data into a .CSV file. Each batch ...
- 3,907
Advice
2
votes
8
replies
118
views
Android driver app location sending to server (Taxi booking app)
I developed a simple Android app (A driver app for taxi booking).
App sends its location (lat/lng) every 5 seconds to server using TCP/IP. and server stores the driver location in SQL SEVER database. ...
- 860
2
votes
1
answer
86
views
Way to simply list the Forms of a word by the full-text parser?
We're using fulltext indexes in current builds of SQL Server and/or Azure SQL - compatibility levels well over SQL Server 2016 or higher, preferably SQL Server 2022 on Azure.
While the searching in a ...
- 976
2
votes
0
answers
135
views
Using two words in LIKE operator (eg.: %John%Doe%) VB6
TL;DR Is it possible to search for matches using two words in LIKE operator?
Eg.: rsCustomers.Filter("Name LIKE '%John%Doe%'").
I have this ADODB.Recordset called rsCustomers that persists ...
- 31
0
votes
1
answer
74
views
Varying SQL query results [duplicate]
I have a table valued function called "elara_customer_byname". When I execute SELECT * FROM elara_customer_byname('%Kar%') I get 2 rows, which is incorrect. If I copy the SQL from the ...
0
votes
2
answers
153
views
How do I write a query that pulls 0 minutes over time dynamically?
I have this data:
Client_Id
VisitDate
Mins
period_Id
program_Id
1
2025-01-01
3
600
T
1
2025-01-02
0
600
T
1
2025-01-03
45
600
T
2
2025-01-01
0
600
T
2
2025-01-02
0
600
T
2
2025-01-03
15
600
T
3
2025-...
- 9
3
votes
3
answers
118
views
Delete rows in two tables with relations in both directions using Entity Framework Core
How do you delete rows in tables using Entity Framework (Core), when you have two tables that are referencing each other in both directions?
Consider there classes:
public class ImageSeries
{
int ...
- 2,758
2
votes
2
answers
186
views
Join on one column and if null join another column
I need some help handling null columns in joins. I have three tables (below are just examples) Map, Employee and Region. Primary table is Map where I join Employee table on the MapID column to get ...
- 590
0
votes
0
answers
24
views
SQL Server 2019 (v15) : tempdb related files eat up about 80 GB on C disk, how to make it small and free up some space in C [migrated]
On Windows Server 2016 and with SQL Server 2019 (v15.0), the tempdb file size is huge at about 80GB and it is divided into many files such as:
tempdb.mdf,
tempdb_mssql_2.ndf
tempdb_mssql_3.ndf
...
...
- 317
0
votes
0
answers
135
views
Can on-premises SQL Server be accessed via SQL Connector in a Power Platform VNET-linked environment?
I'm trying to connect to an on-premises SQL Server instance using the SQL Server connector in Power Automate within a Power Platform environment linked to an Azure Virtual Network (VNET).
Microsoft ...
- 669
-1
votes
0
answers
101
views
How to enable full-text search feature in SQL Server on .NET Aspire?
How to enable full-text search feature in SQL Server for .NET Aspire?
var sqlServer = builder.AddSqlServer("sqlServer", builder.AddParameter("password123!!!", true))
.WithLifetime(...
- 3,542