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. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

1
vote
0answers
12 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
0
votes
1answer
282 views

Is this an SQL injection attack? If so, what's it trying to do?

I'm seeing a number of entries in my access log where 'A=0 is added to a query parameter, eg: http://www.server.org/foo/?bar=1'A=0&type=xml The parameter that 'A=0 is attached to varies, but it'...
0
votes
1answer
30 views

Get password for all failed MySQL logins

Im having issues trying to figure out what is the cause of a failing SQL login. The password seems correct to me, but it still isnt working. I want to see what exactly the user login is sending when ...
0
votes
0answers
14 views

Access denied error connecting to SQL DB with Postfix

I have no idea how to go about debugging this. I have created an SQL user called postfix and i have verified that i can log into the DB with this user and edit tables. I have configured postfix to use ...
0
votes
0answers
4 views

xp_cmdshell fails to call outside procedure W2K12

SQL Anywhere 12 DB event calls xp_cmdshell to run cmd.exe and points to a .bat file. This same exact process works on all verison of Windows Server but 2012. "the database event calls a procedure ...
0
votes
1answer
31 views

SSIS 2014 - map NFS

We are migrating SSIS from SQL 2008 to SQL2014. Old OS: WINDOWS 2008 R2 SP1 New OS: WINDOWS 2012 R2 I use the Execute Process Task to map an NFS share to a drive. Executable: C:\Windows\System32\...
0
votes
0answers
21 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
0
votes
0answers
128 views

SQL Server 2008 R2 eventually sends RST instead of FIN/ACK

My SQL Server 2008 R2, running on Windows Server 2012 R2 unexpectedly sends connection resets (RST packets) to its clients performing series of small queries. The problem is, it eventually happens. ...
3
votes
1answer
92 views

How to find out who / what is hammering SQL Server TempDB

I am using SQL Server 2012 Enterprise. The server has one availability group configured. There are several databases for different tools on the instance. The tools all belong together and therefore ...
2
votes
0answers
54 views

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is ...
1
vote
0answers
11 views

Sql Partitionning a table time by time [closed]

I try to do a partioning into a SQL table with Microsoft SQL Server Management Studio. I want to do this partition all night at 23h. For example i put all lines with a 0(on the column) on my ...
0
votes
0answers
36 views

Bacula stopped working after pool delete from catalog and from disk

We had 2 identical backups of 1 server. 1 was done by real name and the second was done by alias (CNAME in DNS). I deleted the one that was done by CNAME to free up disk space. First I deleted pool ...
1
vote
0answers
10 views

Hadoop Hive, Impala, Pig, and more — SQL access to Hadoop?

It appears that Hive, Impala, Pig, and others all provide SQL or SQL-like access to data stored on Hadoop clusters. They all seem to have support for HDFS, S3, and other forms. So why are there so ...
1
vote
0answers
13 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
0
votes
1answer
122 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse....
0
votes
2answers
180 views

Website/Server down for maintenance - Redirect to 'Landing Page'?

I have been given the task to make it so when customers try to access their websites while maintenance is taking place (Whether on their website, or taking the whole server offline) they are ...
1
vote
0answers
43 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
0
votes
1answer
494 views

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 ...
-1
votes
1answer
34 views

can I centralize SQL and AD users via LDAP? [closed]

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 ...
0
votes
3answers
49 views

How to find a word in SQL? [closed]

Lets say you are filtering on rows in a column that contains the word Engineer in a phrase. How can I exclude words like 'Engineering' or 'Engineered' or 'Engineers' when I wouldn't know all the ...
0
votes
1answer
57 views

slapd configuration for back-sql: how to traslate examples from slapd.conf to slapd.d

I'm trying to configure slapd with back-sql (specifically postgresql backend). All documents I found (Postgresq LDAP Howto seems to be more complete) are related to old configuration that use slapd....
0
votes
0answers
106 views

sql-php-sqlyog: Access denied for user .. unable to connect to database

I browsed around all other answers provided for this same issue. But didnt find a solution. So I thought to ask mine here. I am not very good with sql. But this is the first time I am facing this ...
0
votes
0answers
18 views

SSIS Package stops SQL Server services

I built a SSIS package to populate Fact Tables. I came across a strange issue. So whenever i run the package/DFT task it results on failure. On inspecting it, i see that connection problem to the sql ...
1
vote
1answer
820 views

In SQL Server 2012 Failover Clustering, we are getting “The action 'Move' did not complete. Error Code: 0x80071398”

We have setup 2 VM Nodes for SQL Server 2012 Failover Clustering. The iSCSI drives are on our SAN. Cluster setup and SQL Server 2012 SP2 install succeeded without errors. Connecting to SQL Server from ...
1
vote
0answers
113 views

Error when viewing database mirroring monitor in SQL Server with non-default port

I have database mirroring set up (with witness) on SQL Server 2014 Standard. Both servers use default instance on a non-default port (not 1433). Mirroring works perfectly fine. However, when I try to ...
0
votes
0answers
8 views

Is CAL licen for SQL Server [duplicate]

We have build a web application in asp.net and sql server 2014 but i was searching around and found that any who uses sql server requires a CAL. How are SQL Server CALs counted?. But what if non of ...
0
votes
0answers
6 views

Maintain and version controll config- and SQL scripts

I'm looking for recomandations of handling variouse config scripts for a few databaseservers. The scrips fall into the following categories: OS Config scripts and files, such as crontab for multiple ...
-5
votes
2answers
92 views

How to stop/start only SQL Server in Windows 7 when logged in as Limited User [closed]

I have an employee working as a data entry operator on Windows 7 PC. I want to create backup of the data and for that I have to stop SQL server while in administrator mode, to move data files to ...
0
votes
1answer
342 views

SQL Server 2012 Native Client returns missing DLL error on install

OS: Windows 7 Pro SP1 Whenever I try to install the SQL Server 2012 Native Client x64 the install process gets to the end, the "removing backup files" stage then throws up this error: "There is a ...
0
votes
0answers
80 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
0
votes
2answers
178 views

Disabling TLS v1.0 with SQL & RDP

How do I disable TLS 1.0 without breaking MS SQL & RDP on Windows Server 2008 R2? If I simply disable it, RDP stops working along with MS SQL. Tried googling but I can't find a solution. Is this ...
1
vote
3answers
158 views

Do SQL backups run faster if you set the databases to read only first?

I have to do a backup of all databases back to back (3.25 GB of data for all .BAK files combined). Will it go faster if I configure the script to set the database to read only first before backing it ...
0
votes
0answers
479 views

How to export SQLCMD output to Excel

I am using SQLCMD command in powershell to run SQL scripts. When i pipe the output to TXT ,the formatting is all messed up. i want to export the results to excel file. how can i do that. My command ...
0
votes
1answer
43 views

on prem SharePoint 2013 size limitations

I am attempting to provide some of my remote users (bandwidth limited) with a on prem sharepoint server (Sharepoint 2013 foundation) on a Dell poweredge t110 II running windows server 2012 r2 standard....
0
votes
1answer
37 views

Virtualized IIS 7 Intranet page is slow when querying against SQL database

OK… I’ve been tasked to figure out why an intranet site is running slow for a small to medium sized company (less than 200 people). After three days of looking on the web. I’ve decided to post what ...
0
votes
0answers
46 views

Upgade SQL Express 2012 -> 2014 gives: Script level upgrade for database 'master' failed because upgrade step

Trying to upgrade my SQL Express 2012 to SQL Express 2014 with the upgrade wizard, but get the error: Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade....
0
votes
0answers
133 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
-1
votes
4answers
302 views

MYSQL - is LOCALHOST speedy than i.e. (domain) mysql.domain.com [closed]

I am interested, on some hosting(although they are paid hostings, for example, DreamHost. probably 000webhost too), in database server, you have to insert: mysql.domain.com (instead of: localhost). I ...
0
votes
1answer
137 views

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, ...
3
votes
2answers
356 views

Performance azure disks, high average queue length

I'm having a classic developer-system admin battle where I am stating that there is an IO problem on the disk of the shared sql server while the system admin tells me that the capacity hasn't been ...
0
votes
1answer
42 views

SQL clustering without WSFC (Windows Server Failover Clustering)

Is it possible to cluster, or make SQL "highly available" without having to pay the huge enterprise prices? By the looks of it, any type of SQL clustering requires enterprise edition Windows Server. ...
0
votes
1answer
82 views

Azure SQL - Sudden connection spike

At first: This is my first question on Serverfault. I am not sure if it fits better on Information Security. If so, please leave a comment and I will move the question. Question My company is ...
-1
votes
2answers
66 views

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 ...
-5
votes
1answer
104 views

DB Server and Fully Qualified Domain Name

I have a hosted virtual server (Windows Server 2012 R2) that exists solely to host a few SQL databases. I need to purchase a SSL certificate to encrypt data but purchasing a certificate requires that ...
2
votes
1answer
174 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
-2
votes
0answers
89 views

Where are the latest benchmarks on SQL-on-Hadoop performance? [closed]

I'm investigating adoption of Hadoop in my company, and a key requirement will be use of SQL for doing analytics. Hard to know exactly what the main usages will be but no doubt a mix of small and ...
0
votes
2answers
2k views

Copy DB table across 2 different MSSQL servers

I have 2 MSSQL servers running, with more or less the same data set. It is really a production/development setup. Now, my workflow is like this. Every day backups are made of each one of the ...
0
votes
1answer
38 views

how to create public SQL server [closed]

I installed sql server on my computer. I can work with it as localserver. But i want to it to be a public server. I followed lot of tutorials but it's still don't work(I can't connect the server ...
0
votes
1answer
244 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
1
vote
1answer
104 views

SSH Tunnel issues

Our setup is as follows; - 2 tomcat servers hosting sites - 1 load balancer - SSH connection to client server which contains database This approach has worked fine with the exception of one client ...