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
-1
votes
1 answer

how to choose server that can handle about 1 or 2 million visit of my website

I am building website using Angular and .net core, some modules will be written in python I have searched on hosting specs and know the difference between them and I am comfortable for dedicated server to help me manage the website, database , etc…
Amira Elsayed Ismail
  • 127
  • 3
-1
votes
1 answer

ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user

Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to connect to the Azure database which are working fine…
Akki
  • 1
  • 1
  • 2
-1
votes
1 answer

linux mysql convert .sql.tar.gz to csv

I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks
Born vs. Me
  • 1
  • 3
-1
votes
1 answer

How to create a SQL Server Database from DBML

I have corrupted an entire database and I have no access to it or backups. Is there a way to recreate the structure of it using a .dbml from visual studio project? Thank you in advance.
AJ GS
  • 37
  • 7
-1
votes
1 answer

Best database (SQL\NoSQL) for storing file hashes and corresponding description

I am working on a system that store file hashes and a corresponding description basically, the structure is very simple just 1 table, HASH (key) and File Description. For example: 8F28067D10C64952F79542BF1EE349CB | Windows XP beckgrounf…
dave
  • 1
-1
votes
1 answer

SQL 2008 cluster

I have a problem with the SQL cluster 2008 after I backup one of the volume, format the volume and restore the volume, then the cluster SQL agent can't start anymore. I did so many times but everything was always fine. Now if I do the restore one…
ArturKis
  • 3
  • 2
-1
votes
2 answers

Flush Privileges in My SQL gives HY0000 Unknown Error

When I try to run FLUSH PRIVILEGES; in MySQL I get this error: Error 1105 (HY000): Unknown error I am running the very latest version of MySQL 5.7 in Windows Server. Does anyone have any idea why this might be happening?
A X
  • 469
  • 4
  • 10
  • 31
-1
votes
1 answer

Active Directory CSV QUERIES NOT ADMIN

My situation: I work at a help desk and have access to the server active directory is on. I do not have edit privileges. I am in control of inventory and need to have a way to get employee information more efficiently then navigating through the…
user370480
  • 13
  • 2
-1
votes
2 answers

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible?

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running on a separate AWS desktop machine to pump data…
Bobby
  • 1
-1
votes
1 answer

Web page generating error on SQL stored procedure

I am a total newbie to SQL. I am a networking specialist so like most smaller IT positions I kind of got this problem dropped into my lap. I have been able to pinpoint some issue through event logs and research but I am still stumped as to this…
machinica
  • 19
  • 1
-1
votes
1 answer

SQL Express 2012 error when installing vCenter Update Manager 6.x

When installing a fresh VUM 6.0u1 VM I ran into an issue where if you choose to use the free MS SQL Express 2012 DB you get an error that says 'SQL Installation was not successful'. If you try to run the SQL Express installed directing from the…
Chopper3
  • 101,299
  • 9
  • 108
  • 239
-1
votes
1 answer

can I centralize SQL and AD users via LDAP?

I have to mention that I am talking about 60 - 100 users. We are having SQL database for specific internal use, where contain all the users in the company. Now we are deploying Windows Active Directory and think of a way to centralize the users.…
Vasil Nikolov
  • 159
  • 1
  • 6
-1
votes
4 answers

MYSQL - is `localhost` faster than domain name (i.e. mysql.domain.com )

Some hosting providers doesn't have localhost as mysql hostname, instead they give-out mysql.example.com as host-name to be used in applications. Could there be any difference in performance, as they, instead of having 127.0.0.1 (or even localhost)…
T.Todua
  • 214
  • 1
  • 4
  • 14
-1
votes
2 answers

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the database is replicated to . I need to set up another…
user1339913
  • 101
  • 1
-1
votes
1 answer

Unable to backup SQL database due to insufficient permissions

We are attempting to do an internal SQL backup of our databases, however it appears when the databases were configured the SA user account had been disabled. For whatever reason the BUILTIN\Users only have "public" permissions. We have tried logging…
user3045068
  • 51
  • 1
  • 8
1 2 3
…
85 86