Questions tagged [sql]

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

Filter by
Sorted by
Tagged with
-2
votes
0answers
17 views

Migration from SQL 2000 (Backend) + IIS (Server 2K) + MS Access To Azure

Good day. We plan to migrate our old web app server to Azure, here is the current setup: Frontend Web - Windows Server 2003 IIS Backend DB - SQL 2000 User input data using MS Access 2003 (ODBC ...
-2
votes
0answers
20 views

IPDB vs BigchainDB vs MySQL vs MariaDB vs Cassandra vs MongoDB vs PostgreSQL vs Oracle vs Redis [closed]

Is someone tested IPDB or BigchainDB ? If yes, what are the differences compared to traditional MySQL or MariaDB ? ** What are the cost ? ***** important : what is the actual speed ???? (looking over ...
0
votes
1answer
12 views

Error code ElasticPoolOverStorageUsage

I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code: ElasticPoolOverStorageUsage. We have a total space of 32GB and based on the Elastic pool data ...
0
votes
1answer
17 views

How to best setup SQL 2019 with 6 drives?

SQL 2019; Dell R710 2x2.93 GHz x5670; 144 GB RAM; 6 - 2 TB drives Derived from a previous question (posted here 10 years ago), I figure 3 x RAID 1 is the best way to go. Please correct me if I am ...
-3
votes
0answers
23 views

issues with subquery sql [migrated]

Hi im getting this error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. this is my current SQL query: DECLARE @UgpEntry VARCHAR(50) SELECT @...
-1
votes
0answers
22 views

(Robocopy) Output shows 1 mismatch file, i would like to know what that means

Total Copied Skipped Mismatch FAILED Extras Dirs : 1 0 1 0 0 0 I get 1-2 mismatched files, i would like to know why that is and what it ...
-2
votes
0answers
23 views

Use if else sql statement with two selects [migrated]

Currently I have the following SQL query DECLARE @UgpEntry VARCHAR(50) IF (@UgpEntry = -1) SELECT t1.ItemCode as sapitemcode , t1.CodeBars as Barcode , t1.ItemName as description ,LEFT(...
0
votes
0answers
10 views

PostgreSQL, find first time started after X days

I hope the explanation make sense. I'm trying to find how long it takes from a car owner gets their car, to they turn it on for the first time. We have records of all ignition_start from the cars, and ...
0
votes
1answer
21 views

Axapta 3.0 How to change Company permission for user?

We got an old axapta 3.0 Server to manage of one of our customers. The problem is our customer needs this old server to access old company data and no one has a plan how to administrate it. We need to ...
0
votes
0answers
19 views

Azure SQL database migration to new region not working

I tried to migrate a SQL database from Azure's Central US region to another region. I used the Azure resource mover (as outlined in this Microsoft article). I completed the mover steps and it appears ...
0
votes
1answer
46 views

Accessing SQL Server Remotely - Connection fails when attempting to connect with new external domain

Scenario is: Right now, we can remotely access SQL server using SSMS or a ODBC connection using the SQL driver. We are currently using sql1.mydomain.com We are switching to sql2.mydomain.com. When I ...
0
votes
1answer
40 views

Any PowerShell Script to Backup and restore Ms-sql database using dB username and password?

I am looking for a PowerShell script which can take backup and restore MS-SQL databases using SQL authentication.
0
votes
0answers
45 views

Continuous windows events 4648 and 4624 generated when ODBC driver is configured with Integrated windows authentication

We are running a C# application in my VM,which is configured to run as a windows service. The service runs as local system account and talks to a locally installed SQL database server. I have access ...
0
votes
1answer
31 views

creation of sql database impossible

When trying to create a SQL database in the Azure Cloud I got always a validation error. Neither the database nor the database server are created as result. I have no clue about the reason for this. ...
0
votes
1answer
102 views

Cluster network name blank in SQL cluster node configuration (setup exit with “Error code 0x84C00001”)

I created 2 nodes fail over Microsoft cluster Windows 2016. On the node 1 an SQL 2014 server clustered has been installed, the new role is working and is online in the cluster management console. Now ...
0
votes
1answer
22 views

Unable To Access SSAS via MSMDPump File and URL

I had this same issue when trying to connect to SSAS via a MSMDPump file, as stated in this article. String reference not set to an instance of a String. Parameter name: s (mscorlib) I got the ...
0
votes
0answers
29 views

SQL Server Express - How to prohibit access from Domain Admins

Per comment suggestion, this question has been posed on this forum from Stackoverflow. I need a way to lock a SQL Server Express database that is deployed to a PC, which may or may not be on a domain. ...
0
votes
0answers
24 views

How to reduce the time required to migrate tables from Azure SQL to Azure Synapse SQL using Azure Databricks with jdbc connection?

I have been trying to migrate tables from Azure SQL to Azure Synapse SQL, the data gets loaded from Azure SQL very easily in Azure Databricks but when I try to overwrite a table in Azure Synapse SQL ...
0
votes
0answers
14 views

SQL Issues with Draytek 2862

I switched from a Sonicwall TZ210 to a Draytek 2862 recently, I have port based 2 VLANS. VLAN1 - Main Office 192.168.1.1 VLAN2 - WIFI 192.168.2.1 They are not inter-lan linking as they need to be kept ...
0
votes
2answers
175 views

Microsoft OLE DB Driver connection string for RDS High Availability

I need to configure RDS Farm High Availability based on Windows Server 2016 with MS SQL Server 2016. One of the steps is connect to database. All available guides tell me to use SQL Server Native ...
0
votes
0answers
32 views

Connection SQL distant remote communications link Failure gcloud

Hello at all I try to connect through a server Tomcat hosted on google cloud to my host DB (Green Geek) I have donats created two rule firewall between /out on google is one on GreenGreek for the sql ...
0
votes
1answer
881 views

“An existing connection was forcibly closed by the remote host” when trying to connect to azure sql server

I'm trying to deploy a SQL database to my azure SQL server. When I'm trying to connect to my target server, I get the error listed below. I'm using Microsoft SQL Server management studio 18 with ...
1
vote
1answer
127 views

Strange behaviour of MySQL on Windows (CPU 100% with simple query)

We run MySQL 8 on Windows 2019 server (Dell R420, 32 cores, 64GB, SSDs on Raid10). Every now and then, our website goes completely offline, as the CPU on the MySQL server is completely bottlenecked (...
0
votes
0answers
28 views

SQL instance IP address pointing to the SQL server hostname

Our SQL instances IP addresses are pointing to the same DNS entry (which is the SQL server name) although the TCP/IP is enabled. My question is, how do you set up the SQL instances IP address and ...
0
votes
0answers
25 views

MySQL Proxy with routing system

I am looking around for a solution to very specific problem. I have few years old big system. This system uses the Sphinx system to cache some data from MySQL databases. I have run the Sphinx cluster ...
0
votes
0answers
93 views

SQL Server generating 1G dump files

I have a SQL Server generating large dump (mdmp) files, some of them are 1 GB in size, these are generated daily, sometimes 2 or 3 in a single day. This server is used heavily for PowerBI reports. ...
0
votes
0answers
12 views

SSRS Server instances subscription service preferences

For SSRS, if you would have two server instances linked using scale-out deployment, why would server1 be heavily loaded and seems to handle all report subscriptions, while the server2 does not seem to ...
0
votes
0answers
13 views

SQL statements in Extended Events limited to 4000 characters?

I have enabled auditing of my Azure SQL Database. Every time a SQL statement fails to execute, this is recorded in an SQL Database Extended Events File (*.xel) which is useful for me when ...
1
vote
0answers
31 views

Is admin the least required Permission Role to start SQL Always On Instance?

We've got an SQL 2019 Enterprise with Always On. Everthing works fine, but the user, which is starting both instances has admin rights. So I want to change this, but all tutorials are talking about ...
0
votes
0answers
19 views

TFS 2013 Clone and rename and move to new domain

I am planning to move my current TFS (Team Foundation Server 2013) environment from one domain to another domain, currently I am reading Microsoft articles on moving but i am planning to clone the ...
0
votes
0answers
148 views

Can I call a .Net Core console application from my SSIS package hosted in an Azure SQL managed instance?

We have an application that we are moving from an on-premise or VPS environment to Azure. We have a SQL managed instance on Azure and have set up our Integration Runtime for SSIS. We have deployed ...
0
votes
1answer
126 views

Is there any upfront cost for Azure SQL Database Reserve Capacity Monthly Pay option?

Planning to go with Azure reserved capacity for SQL Databases. Azure price calculator not showing any option to get the pricing monthly as it shows like for virtual machines. Wants to know whether ...
0
votes
0answers
9 views

AzureSQL - Improving View Performance and Maximizing Maintainability

Setup: I'm a developer that knows how to write SQL but does not have anything close to depth of knowledge with SQL so I'm not sure if there is a better way to handle my situation. The first question ...
-1
votes
1answer
36 views

MS SQL Server Cores / License To Purchase [closed]

After almost 6 years I'm approaching the 10 GB limit of my MS SQLExpress deployment. I'm looking at the licensing for MS-SQLServer and am getting more confused with everything I read. Can anyone help ...
-1
votes
1answer
50 views

Could facebook minimize the number of servers if they used a faster database rather than MySQL? [closed]

Facebook needs 30,000 Servers to run. Seriously that's a lot! Facebook is old. It uses MySQL. I was wondering if they started with a much faster and efficient database, my question: 1. What database ...
0
votes
0answers
49 views

MariaDB not starting after adding .frm and ibdata file to /var/lib/mysql?

I've created mariadb database on a AWS EC2 linux ami server from a volume previously connected to another instance, but have run into a wall. The database worked fine on my previous instance but with ...
1
vote
4answers
2k views

Cannot set SQL_MODE to Mysql 8

I have to set a persistent custom SQL MODE persistent to my server. I added this line in /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld] ... sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,...
2
votes
1answer
124 views

Change retention time for backup in Azure SQL Database

is there any way to change retention time for backup in Azure SQL? For example, there is some backup with retention time for 1 month and I want to change retention time for that backup for 1 year, is ...
-1
votes
1answer
68 views

Why SQL query does not work with subquery but works with comma seperated list? [closed]

I have query: SELECT p.[id], p.[page_file], p.[page_header], p.[page_icon] FROM [dbo].[setup_pages] AS p WHERE CONVERT(nvarchar(100),p.[id]) IN ( SELECT l.[access] FROM [dbo].[licenses] AS l ) ...
0
votes
0answers
32 views

how to hide server structure (hdd) in sql server 2017 from non admin users

In sql server 2017 i have create users but when they tray to restore database they can see hdd structure but cannot restore anything because don't have privilege, how to deny see even hdd structure ...
0
votes
1answer
181 views

How to take backup of 500GB SQL database data?

We tried to copy 500GB data to local drive using copy option in SQL management studio but it getting failed after 2 or 3 hours...is there any size limitation to copy? How much size script file should ...
0
votes
1answer
37 views

sql injection “Slep”

how to determine ip address or url address logs ? i have this in my mysql-slow-query /usr/sbin/mysqld, Version: 5.5.62-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /...
2
votes
1answer
107 views

SQLite works, but PostgreSQL migrated database causes ERROR - Django 3.0

Situation I have built Django 3.0 project with a couple of applications. I have created the accounts app based on following course and it's github Than I have created an application fro ...
1
vote
2answers
7k views

AWS RDS to PgAdmin Error saving properties Unable to connect to server: timeout expired

Short description: AWS RDS connecting server to PgAdmin 4, PostgreSQL 11 Done: I have done similar to this guy or to this aws guide but at the end when I click save it does not accept it for me. ...
0
votes
1answer
795 views

XAMPP on Catalina - Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' [closed]

i installed xampp to make a local website. i finished the website and tried to export the db to switch to production and i noticed that the DB in php my admin seemed to be empty ( which couldn't be ...
4
votes
1answer
2k views

Error creating Sql Server in Azure this location is not available for subscription

Im trying to create Sql Database resource and any location i select i get: "this location is not available for subscription" Im trying to create WebAPP with Database. Plan is pay as you go
2
votes
2answers
39 views

Decreasing OS drive free space on Azure VM running SQL Server 2016

Recently I noticed that drive C: is decreasing in free space on my Azure VM running Windows Sql Server 2016 (doing daily azure VM backups in Recovery Services Vault). Drive C: keeps adding 100-250mb ...
0
votes
2answers
66 views

Is it safe to have virtual memory in servers?

I'm not sure if it's safe to have virtual memory (pagefile.sys) in servers? Safe in the sense of: Would it affect the data in the cache that is being handled by RAM? Does it conflict if it will be ...
2
votes
0answers
477 views

Azure SQL bacpac import job stuck - timeout on it?

Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name. The file is being pulled in from an Azure storage account. I ...
1
vote
0answers
36 views

AWS Performance Insight Huge Load from “Other” SQL

Engine: MySQL 5.7.26 Looking at my AWS Performance Insight metrics, I noticed that most of my Database load consumes the query marked "Other" Can I check what is hidden under this label? Screenshot:

1
2 3 4 5
26