Server Fault Stack Exchange
Server Fault Stack Exchange

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].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
0
votes
1 answer

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 I attempt to connect with SSMS, I get the…
Influence
  • 11
0
votes
1 answer

creation of sql database impossible

When trying to create a SQL database in the Azure Cloud I always get a validation error. Neither the database nor the database server are created as result. I have no clue about the reason for this. Thanks for any help. According to the system…
Tim vor der Brück
  • 1
0
votes
1 answer

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 i should add the node 2 to the the SQL Server…
JamesFlipper
  • 1
0
votes
1 answer

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 following error message when trying to connect to my…
David Rogers
  • 215
  • 2
  • 11
0
votes
2 answers

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 client (SQLNCLI). But it remains deprecated and it is…
Link
  • 25
  • 7
0
votes
1 answer

"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 Windows 10 1909. Any…
Gary Simmons
  • 1
  • 1
0
votes
1 answer

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 instance name properly so we can access it faster in…
neb
  • 11
  • 1
0
votes
0 answers

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. Opening the file with WinDbg I get some information…
The One
  • 113
  • 1
  • 5
0
votes
1 answer

SQL Server; how to import data from another DB with different collation; conversion errors?

I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (right click DB > Tasks > Import Data) DB1 is the source DB, it has a collation set to Cyrillic_General_CI_AS DB2 is the destiantion DB, it has a…
user155695
  • 290
  • 3
  • 5
  • 14
0
votes
1 answer

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 monthly option is available for SQL Databases…
Prasad
  • 1
0
votes
1 answer

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

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 would that be? 2. What would be an estimate on …
user1034912
  • 1,345
  • 3
  • 14
  • 20
0
votes
1 answer

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 be if we take for 500 GB database? Please let me…
bhuva nesh
  • 1
  • 1
0
votes
1 answer

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: /var/run/mysqld/mysqld.sock Time …
Ghita Dan
  • 3
  • 2
0
votes
1 answer

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

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 possible, because i worked with the wordpress…
rita1989
  • 11
  • 2
  • 7
0
votes
2 answers

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 called? Specs: Server - Lenovo System x3250 M6 Rack…
Alan
  • 1
  • 2
1 2 3
…
85 86