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

Stop SQL default instance

I have installed SQL Server 2014 named instance and configured to connect on static port 1433(Default SQL port). For example: db.mycompany.com\SQL2015,1433 But its able to connect to the default ...
0
votes
0answers
60 views

setting up a new infrastructure… im a mess [on hold]

Question edited. Need advice on following. Have 50-75 clients working simultaneously. 20 work with 2 different softwares relying on mysql databases. Need to setup a domain controller with active ...
0
votes
0answers
5 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 ...
-4
votes
2answers
41 views

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

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 ...
1
vote
1answer
3k views

SQL PowerShell Snapin Problems

I am hoping this is an easy fix and oversight on my part. I need to be able to run the SQL cmdlets from remote machines. I have installed Microsoft® Windows PowerShell Extensions for SQL Server® 2008 ...
0
votes
1answer
1k views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
0
votes
1answer
9 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 ...
3
votes
1answer
967 views

How to Explain a query in PostgreSQL 8.3 that has bind variables

I need to explain an application generated SQL statement in PostgreSQL 8.3. I captured the SQL statement in the log but it has a lot of bind variables. Is their any way that I can explain this SQL ...
0
votes
0answers
25 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. ...
-2
votes
0answers
13 views

sql query to merge a variable number of rows into one row [closed]

I have a rather complicated query that I need some help with. I am not sure if it can be done in SQL. I have two tables: tags: tag_id tag_name 1 blue 2 green 3 black 4 ...
-2
votes
0answers
14 views

SQL Joins and Relationships [migrated]

Joins are somewhat confusing. I want to know how to choose the join based on the relationship between tables, or do joins have no dependency on relationship? if relationship is "one-to-one" then ...
0
votes
1answer
1k views

Sending Email from SQL Server Agent scheduled job

I've scheduled a job in SQL Server Agent that sends the result of a query in an email. If I execute the stored procedure from SSMS, it works fine. But the SQL Server Agent is not able to send emails. ...
3
votes
2answers
471 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
0answers
4 views

Hows to make a DB2 table read-only? [migrated]

We need to test how an application will fail when the DB2 database cannot be written to. What is the easiest way to make a DB2 table read-only? Is this considered locking? Thanks in advance, Bert
0
votes
1answer
42 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 ...
0
votes
0answers
39 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
1answer
1k views

SQL Server doesn't allow to execute subquery as dynamic SQL

I tried to make a dynamic SQL which gets all tasks for some users The procedure [GetAllSubExecutorsByUserId] returns IDs of all subalterns of curent user I write these IDs into a temporary table, and ...
0
votes
1answer
3k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
3
votes
2answers
99 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
0answers
44 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
23 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 ...
0
votes
0answers
14 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
16 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 ...
0
votes
0answers
16 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 ...
2
votes
1answer
52 views

backup compression ratio in SQL 2012 worse than in SQL 2008

We have SQL 2008 Enterprise with TDE enabled and upgraded to SQL 2012 with TDE still enabled. Everything works fine except that I am getting worse backup compression than in SQL 2008. I do ...
-1
votes
4answers
86 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
12 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
0
votes
1answer
21 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, ...
2
votes
2answers
721 views

why would adding a crossover private nic cause IP address resource fail?

2 node Win 2008 R2 quorum cluster Configured 192.168.0.0/24 "public network" Configured cluster MSDTC Installed SQL 2008 R2 cluster instance Manually failover groups - OK Reboot server w/o failing ...
0
votes
1answer
21 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
20 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
2
votes
2answers
1k views

How do you migrate a SQL Membership database with encrypted passwords where the decryption key is autogenerated?

I have a server where the machine.config states the following: <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="SHA1"/> A decryption ...
0
votes
1answer
31 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
1answer
39 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 ...
0
votes
0answers
9 views

Having Trouble Setting up OLAP/Analysis Services on SQL Server 2014

I have been having extreme trouble setting up an azure server with a sample multidimensional database i have been using this tutorial ...
-5
votes
1answer
23 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
42 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
36 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
77 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
35 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 ...
5
votes
2answers
1k views

Renamed a SQL Server, however maintenance plans still have old name

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'. The text boxes containing the server names for Local ...
0
votes
1answer
58 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
37 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 ...
0
votes
1answer
31 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
0
votes
0answers
60 views

How do I create an SQLAlchemy class with two foreign keys (to different tables)?

Contrived example: class Person(Base): __tablename__ = 'person' id = Column(Integer, primary_key=True) name = Column(Unicode) class Location(Base): __tablename__ = 'address' id = ...
0
votes
1answer
81 views

How to import postgresql file on Linux with space in path?

If I try to import an sql script with a space in path, the file is not found. mypsqluser=> \i /home/markus/Documents/Projekte/My App/Installation/server_sql_script.sql ...
3
votes
0answers
33 views

SQL & BITS Errors on prereq for SCCM 2012

Hey anyone that can help, I've been stumped by this problem for a while now and I've no idea what to do. I've installed SQL 2008 to run with SCCM '12. I've set Log On As a domain account with ...
0
votes
1answer
61 views

How to backup SQL database without users and stored procedures

I have a database which i need to take backup monthly / or by running an script. I need to backup the data and structure only. I don't want to backup stored procedures and users for example... I have ...
0
votes
1answer
226 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
1answer
35 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...