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].
1,281
questions
-1
votes
1
answer
34
views
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL
My server has 100GB RAM.
Of it I allocated innodb_buffer_pool_size as 90 GB
SET GLOBAL innodb_buffer_pool_size = 96636764160;
I ...
- 101
0
votes
0
answers
37
views
Getting an error in SQL Server 2019: The certificate chain was issued by an authority that is not trusted
I've enabled "Encrypt connection"
I've enabled "Trust server certificate"
I've added the TrustServerCertificate=true to my connection string
I've confirmed the service is running - ...
0
votes
0
answers
61
views
SSMS 19 issue with AWS RDS
still pretty new to SQL administration so please bear with me. We recently updated to SQL Server Management Studio 19 and have been running into issues.
The long and short of it is I am trying to get ...
-1
votes
1
answer
31
views
Anybody familiar with the Shoretel database?
I have a copy of the local db from our old shoretel voip system... which is no longer in service.
I've been tasked with trying to locate information pertaining to calls to and from specific numbers ...
- 212
0
votes
0
answers
30
views
InfluxDB influxQL v1.8 : Wrong timestamp used for writing to database
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
- 1
0
votes
0
answers
49
views
Configure xenforo 1.2.9 Using phpmyadmin 4.x with php 5.6.4 on IIS 10, Windows Server 2019
Versions/Programs:
xenforo 1.2.9, phpmyadmin 4.x, php 5.6.4, MySQL 8.0.32 IIS 10, Windows Server 2019
I am trying to host a local server for tinkering on an old computer I have. This server will be ...
- 1
0
votes
0
answers
25
views
CantStartEngineError: No sql_connection parameter is established
I have been trying to install openstack on centos7 but while building it gives error as "CantStartEngineError: No sql_connection parameter is established". The command I am using to build is ...
0
votes
0
answers
53
views
SQL always on cluster on RODC Environment
We are setting up an branch office which has couple of apps and DB servers, and RODC for authentication. we need to configure SQL always on cluster in that branch office. I have done it for RWDC but ...
- 327
0
votes
1
answer
41
views
Secure SQL Server and other traffic with end to end security
All,
I am wondering if there are any best practices or ways that I can open up secure access to a service such as (for example) SQL Server, or any other program normally requiring a port to be opened ...
- 199
0
votes
0
answers
113
views
WSB Not Working
Trying to get WSB working on a server running SQL. The current setup is this.
Server OS is 2019
Backup target is an iSCSI target configured on a NAS, its setup as a local drive on the server
Backups ...
- 71
0
votes
0
answers
21
views
SQL Server Logical Reads increased 10x in past week
I'm not an SQL DBA by any serious standard but I am trying to figure out why the logical reads have gone bonkers on a DB I have for a line of business app.
the image below shows a 10 x increase in ...
- 1
0
votes
0
answers
20
views
Simulate Outage on primary SQL Server in Azure Failover Group
I have a SQL Server with SQL Database in Azure that is replicated to a secondary SQL Server with a Failover Group. We have some functionality in code to redirect failed read requests to the secondary ...
- 101
0
votes
0
answers
35
views
unixODBC SQLFetch infinite loop after INSERT statement
I'm trying to work with unixODBC and a SAP Hana database, and created a simple C program to INSERT/SELECT into the database. My problem is, if I use for example
SQLExecDirect(stmt, "SELECT * FROM ...
- 1
0
votes
0
answers
89
views
GCloud SQL timed out on a Docker container
I have a flask app in a Paperspace Deployment Docker container. It is connected to a Google Cloud SQL (MySQL).
Here are the variables in the YALM parameters:
env:
- name: CLOUD_SQL_CONNECTION_NAME
...
0
votes
0
answers
263
views
How best to allow SQL Agent Jobs to be edited and run by a team of developers, without handing out Sysadmin rights?
I'm trying to find or devise a way to allow a team of developers to be able to amend SQL Agent Job steps and schedules, but that doesn't involve Sysadmin rights for the devs. As I can't assign ...
- 13
0
votes
3
answers
335
views
How to grant persmission for this sql?
How to grant permission for this? Thank you for your help!
ERROR is : ERROR 1142 (42000) at line 2: CREATE command denied to user '@'localhost' for table 'student'
CREATE TABLE STUDENT(
ID INT ...
0
votes
0
answers
95
views
Recomendation sample size for statistics sql server?
There are any recommendation for sample size for query "update statistics table"? Is default table sample size always ok? How to detect the cases when the default sample size does not work ...
0
votes
2
answers
1k
views
How can I use a value returned from one dataset to build a query for a different dataset, in SSRS?
I'm using SQL Server Report Builder 3.0 to create a report.
I have two tables and I want to look up a value in one table and then use that to select a value from the second table. Example as follows:
...
- 13
0
votes
0
answers
133
views
error 17054 severity 16 state 1 sql server 2014 enterprise edition
Our new database is just inaccessible.
I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL ...
- 1
0
votes
3
answers
48
views
Mariadb legacy support
I have old version of php site, which uses unescaped 'row_number' column number in its sql queries. It seems in the new version of mariadb there has been new function called "row_number()" ...
- 131
0
votes
1
answer
432
views
Why my simple searching query is too slow?
I don't know why searching in my "cities" table is so slow.
My query looking for a table "cities" located about 25km from the city.
I use this simple query and the database takes ...
- 3
0
votes
0
answers
317
views
Can't install/uninstall SQL Server
When I try to install SQL Server Express I got this error
Unable to install SQL Server (setup.exe)
Then I'm trying to uninstall everything related to the SQL server to avoid previous installation ...
- 101
0
votes
1
answer
81
views
Adding a security certificate to a remote sql server
I'm in the process of trying to add a security certificate to a sql server running on a remote machine. I managed to generate the cert, but I'm a bit lost on the next step. All the instructions I have ...
- 149
-1
votes
2
answers
798
views
Unable to find user account to set permissions for private key
I'm trying to set up a security certificate for a sql server. According to the documentation, I need to set up the permissions so that the sql server instance can read the private key. I tried setting ...
- 149
0
votes
1
answer
160
views
Can I move my encryption key (used for SQL always encrypted) from a key vault in one Azure tenant to another?
We have migrated a database (backup to .bacpac and restore to the new tenant) but the database was encrypted using always encrypted and the key is stored in the original tenant's key vault. I can look ...
- 29
1
vote
2
answers
1k
views
restrict access to a specific URL with .htaccess
Hello i am running server with xenforo. i would like to know how can i restrict url from .htaccess.
Url is : https://mywebiste.com/index.php?members/find&q=oi%5Bp%5C&_xfRequestUri=%2Findex.php%...
- 13
2
votes
1
answer
2k
views
SQL Database restore to different edition?
I have SQL server 2008 R2 standard in house server and want to move my database to SQL 2019 Web edition in VM in AWS cloud. Can I just backup database and restore it there? would that work? or ...
- 21
1
vote
1
answer
523
views
How to create a new user with sysadmin privilege in Azure SQL Server?
I need to create a new user with sysadmin privilege.
I went to the Azure portal > Query Editor. Then I run this commands.
Unfortunately I got this error:
Any help is welcome.
- 11
1
vote
1
answer
123
views
MySQL is 100% CPU over the past week, no idea why, details below
I'm trying to work out why MySQL is hitting 100% over the past week:
It's a server that does network/server monitoring called LibreNMS.
Top:
https://pastebin.com/1qypfm0n
Here I access MySQL and look ...
- 11
2
votes
2
answers
7k
views
Why can't I grant select privileges to all table in schema with PostgreSQL?
I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user ...
- 195
0
votes
1
answer
76
views
I have a sql server with a pictures table with 25 million entries and it has become too slow to query. currently have a xeon E5-2667v3 with 32g of ram [duplicate]
I have a sql server with a pictures table with 25 million entries and it has become too slow to query i currently have a Xeon E5-2667v3 with 32g of ram, I am looking to get a hp ProLiant Gen 9 and I ...
- 9
1
vote
0
answers
261
views
Does NT SERVICE\MSSQLSERVER require Kerberos authentication if the sql instance is on the local machine?
I had a bizarre issue today where NT SERVICE\MSSQLSERVER was being denied login as a service on a domain joined computer. I also noticed group policy was not being applied via gpupdate /force. I ...
2
votes
1
answer
754
views
MYSQL is at 197% CPU usage ~ not allowing site to run
Spec: 8 GB memory / 4 vCPUs / 25 GB ssd
Ubuntu 20.04
My website got hit with a DDoS recently and had this continuous high CPU usage error for 4 days and the site will not load up, I take a look using ...
- 21
0
votes
1
answer
70
views
SQL Server 2016 Log Shipping and Transaction Replication
Good Morning,
I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes.
Will ...
0
votes
1
answer
11k
views
Error 258 when connecting to sql server instance over the network
Can't connect to a sql server instance over the network, and all SSMS gives me is a 258 error.
Everything is supposed to be correct.
Both machines are inside a domain and the user was added to the
...
0
votes
1
answer
435
views
sp_send_dbmail succeding but sometimes failing
Also posted in Stack Overflow. Any feed back would be much appreciated.
I have a need for a SQL job to send multiple emails, and I have come across this error that I am unable to find any solutions ...
- 1
0
votes
1
answer
71
views
Rolling Backups of .sql files
I'm having a bunch of docker-containers containing different databases.
For every container there is a Jenkins-Job which performs a daily backup of the database as a .sql-file and then zips this file.
...
- 103
0
votes
1
answer
45
views
SQL Converting strings to date [closed]
this has really baffled me for a few days and am seeking help. I am using SQL Server 2017.
I am trying to handle strings from a free format field and either convert them to a date in the format of &...
- 1
0
votes
0
answers
189
views
SQLCMD CMD Line Tools Fails install
I recently installed the most recent version of SQL CMD Line Tools.
I installed it using these directions.
I ran the following command to make sure the module is installed:
Get-Module -ListAvailable -...
- 811
0
votes
1
answer
135
views
Logparser - Selecting data in the past 2 weeks
I am trying to use LogParser to return the data from my iis log files for the past 2 weeks. When I run the following I get "Error: Syntax Error: : no valid content: expecting opening parenthesis ...
0
votes
1
answer
102
views
SQL server connection TCP/IP overt Ethernet [closed]
I have two PCs. There is SQL Express installed on one of them. TCP/IP settins are here:
tcp/ip settings
tcp/ip settings
When I perform Test-NetConnection on local computer I get
But when I do it ...
-1
votes
1
answer
539
views
Users and Roles Extraction in Oracle
I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this:
SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
- 7
0
votes
1
answer
277
views
repmgr for streaming replication - standby register
I'm testing repmgr tool and I'm a little bit confused. Everything's fine until standby register step.
What should I have configured on standby server? From docs I assumed that standby should't have ...
- 485
0
votes
0
answers
26
views
Has anyone here tried using ZWAMP as a dedicated SQL instance for long-term data collection?
By "ZWAMP", I mean this product, especially its MySQL implementation.
What I'm really aiming to learn here are the inherent, hardware independent, data storage size, complexity, and duration ...
- 101
0
votes
2
answers
255
views
How does Google Cloud Platform handle database backups with --async flag?
I'm currently working on adding an extra step to our companies CI/CD pipeline so we make backups of the database before making a deployment that could potentially run migrations on our database.
To ...
google-cloud-platform
0
votes
1
answer
96
views
Error code ElasticPoolOverStorageUsage
I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code.
Error code: ElasticPoolOverStorageUsage.
We have a total space of 32GB and based on the ...
- 1
0
votes
1
answer
30
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 ...
0
votes
1
answer
75
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 ...
- 121
0
votes
1
answer
469
views
Accessing SQL Server Remotely - Connection fails when attempting to connect with new external domain
The 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 ...
- 11
1
vote
1
answer
432
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.
- 11