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
1answer
800 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
0
votes
2answers
65 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
1
vote
1answer
41 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
1
vote
1answer
30 views

create a view to show the backup status in every 10 mins

I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/11/2013 11:00:00, 04/11/2013 11:55:00 102, 04/11/2013 11:00:00, 04/11/2013 11:24:00 103, 04/11/2013 ...
0
votes
3answers
345 views

Server periodically freezing - Help Stabilizing [closed]

We run an asp.net/sql server data collection website with a hand full of clients dumping data in and running reports. We moved to a new server (specs below) and have had issues with it freezing and ...
0
votes
1answer
113 views

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and ...
-1
votes
1answer
32 views

need help scripting website reboot

I have a small website that crashes once or twice a week. I have spoken to both the websites original designers, who has now retired and its host and both blame the other. The website can be ...
3
votes
1answer
79 views

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 ...
0
votes
1answer
4k views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
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
278 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
1
vote
1answer
521 views

Why I can't execute SQL query on Amazon Redshift from VPC private instance?

I have an instance in a private subnet in an Amazon VPC. This instance uses a NAT to access the Internet. I use the Redshift JDBC driver to connect to a cluster hosted in the same region as my VPC ...
3
votes
1answer
649 views

Windows Server 2012 Forest and Domain functional levels compatibility

I'm using a Windows 2003 domain, and a currently planning for a Windows Server 2012 upgrade, so I'm looking at all software which could be hurted by a Domain (and Forest) functional level raise to ...
2
votes
3answers
609 views

MySQL Injection Attacks? Random URL's Causing Errors

We just started running our own web server a few months ago on Rackspace (they are great). I use NewRelic (also pretty cool) to monitor server usage and I am getting error alerts that appear to me to ...
-1
votes
1answer
49 views

Guide to choose which is the best for VM - microsoft or vmware [closed]

i am confused between VM Ware and Microsoft Hyper V whic one is the best in terms of all. is there any comparison chart then please let me know. as to run os in vmware need to install esxi; it is ...
1
vote
1answer
51 views

Terminal Server trying to connect to 1433/tcp on client

We are facing a strange issue here. Everytime a user connects via RDP client to one of our terminal server, the server itself tries to establish a connection via 1433/tcp to the client (and even ...
4
votes
1answer
6k views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
164 views

Why is SQL Server IO so much slower than the disk capacity?

I'm running SQL Server 2012, and doing a simple SELECT * query, I can see that my disk IO in performance monitor is < 10MB/s. If I do a backup of the database, however, I see values > 200 MB/s. ...
0
votes
1answer
21 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...
-2
votes
1answer
62 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
-1
votes
2answers
324 views

Keep Getting an Error When Running My SQL Code

I keep receiving the dreaded "An expression of non-boolean type specified in a context where a condition is expected." errorr at the bolded "dbo.v_R_System.ResourceID" in the code below in the "From' ...
0
votes
1answer
152 views

Multiple POST SQL injection from same IP [duplicate]

Recently I checked my Apache domlog and noticed the following attack: POST ...
0
votes
2answers
936 views

How to allow domain groups access to SQL server?

I'm sure this is a simple problem, bu I've looked for days... I have a SQL server that is part of a domain. The domain has many many users. I want to allow select permissions to anyone within a ...
0
votes
1answer
236 views

Are there simple command line tools to decode a SQL Injection request string? [closed]

My web server periodically comes under attack, and I get a bunch of requests that look like /my.page?union+all+select+0x31303235343830303536%2C0x31303235343830303536%2C0x31303235343830303536-- Are ...
0
votes
1answer
68 views

SQL Server normalizing for performance

I have a table create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null ) All ...
-1
votes
1answer
49 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
1k views

How do I grant select, insert privileges in Postgres on Cygwin?

How do I grant permissions in Postgres? I followed the documentation, however it is not working. $ psql tmadev psql (9.2.4) Type "help" for help. tmadev=# grant all privileges on database tmadev to ...
1
vote
3answers
203 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
0
votes
1answer
100 views

Which Database (SQL/NoSQL) is the best fit? [closed]

I have 2 nodes, one gateway and one worker. Data must be passed from gateway to worker (without direct connection). I would like to store a Key into a database identified with an ID and a Time To ...
0
votes
1answer
62 views

RDP Access in Windows Server 2012 [closed]

Is it possible to restrict RDP access the SQL server to be only from the Terminal Services server
1
vote
3answers
68 views

SQL Server 2005 Issue

I am stuck. I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB. It has swallowed all available disk ...
13
votes
2answers
15k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
1answer
144 views

Server shuts down when running sql query

Sql Server 2005 Windows Server 2003 64 bit 8 processors 3 volumes with at least 100 gigs free on each I was adding an sql index for a table with millions of rows and the server shut down. Nothing ...
1
vote
1answer
255 views

SQL Databases get stuck in Unavailable State daily

Every day I notice several of my project DBs on SQL 2008 R2 (v. 10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, ...
0
votes
0answers
387 views

Data Protection Manager and SQL

We are currently using Data protection manager 2012 SP1 to back up our medical records database in SQL Server 2008 R2. The database server is running Windows Server 2008 R2 as a virtual machine with ...
2
votes
1answer
1k views

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my ...
-1
votes
2answers
181 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
1answer
168 views

Importing old mediawiki SQL dump MAMP

I've been tasked with importing an SQL database to setup up with a local mediawiki website (v1.14). We were sent a SQL file with an image file to upload to the local site. After setting up mediawiki ...
3
votes
1answer
411 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
1answer
88 views

Grant user Permission using Wild Card on MYSQL

I'd like to Grant for example an insert permission for spacific user in all databases started by WA_ for example in my server I make the following syntax but it dosent work GRANT SELECT ON ...
0
votes
3answers
55 views

SQL Instances and Servers

I have two installations of SQL on two seperate boxes (I have "Inherited" these). A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect ...
0
votes
2answers
2k views

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL ...
-1
votes
1answer
2k views

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL ...
0
votes
3answers
63 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
0answers
94 views

Tips on Copying 3 Database files nearing 250 GB?

We are upgrading from SQL Workgroup 2005 to SQL Standard 2012. We have plenty of databases of smaller sizes that copied over with straight windows file copy in a reasonable time frame. We have one ...
0
votes
1answer
51 views

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
0
votes
2answers
117 views

Upgraded SQL server, performance plummets

Seeking help with a new SQL server. A client of mine was running an aging SBS 2003 server (Xeon 3060, 4 gig of RAM) and a line of business application with a 25 gig SQL Database using SQL Server ...
0
votes
1answer
56 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
1answer
199 views

Sql server 2008 R2 using Half of the memory [closed]

i built a new 2 cpu 8 core 40 gb ram Server for our ERP software which use Sql server 2008 R2 on Win server 2008 standart R2, in Sql There are 7 databases, 2 of them for Tests, 2 of them to keep ...
0
votes
1answer
5k views

mysqldump ignore table with wildcard

I need to take a dump of a database containing 50 odd tables of which I want to exclude about 15 odd that have prefix 'exam_' I tried mysqldump --ignore-table=dbname.exam_* and even tried ...