New answers tagged sql
No, converting the disk from Basic to Dynamic does not require a reboot.
Have you tried using the postgresql client from your VPC instance? I had the same issue and it was the security group applied to my instance.
Try this out: select count(distinct extract_value(cs-uri-query, 'mac')) from *.log where extract_value(cs-uri-query, 'state') = '1' You might hve to adjust field names depending on your log format.
SOLUTION I was using PHP 5.3.10 which had the following bug still in it, https://bugs.php.net/bug.php?id=64338 Turns out the PDO driver was making a USE statement which Microsoft Azure SQL Database doesn't like. I upgraded to PHP 5.4.21 and everything worked properly.
You can also try granting access to xp_sysmail_format_query to NT AUTHORITY\NETWORK SERVICE: USE master --Create user in master if necessary CREATE USER [nt authority\system] FOR LOGIN [nt authority\system] GO --Grant execute to the stored procedure that's failing GRANT EXECUTE ON [xp_sysmail_format_query] TO [NT AUTHORITY\NETWORK SERVICE] GO Best thing, ...
If you look at your php.ini file, I think you'll find it's configured to email you errors; but it's failing to do that (which would explain both why you don't see any useful errors, and why you're getting that sendmail error message). I suggest at least temporarily reconfiguring that file to write to an error log somewhere, that you can look through. ...
Losing a database file, even one as critical as the tempdb file, is still a database-level event. According to this Microsoft Technet article: (Failover and Failover Modes (AlwaysOn Availability Groups) ) Issues at the database level, such as a database becoming suspect due to the loss of a data file, deletion of a database, or corruption of a ...
Try connecting via the command line to see if it's a PHP issue or a MySQL issue: mysql -u USERNAME -pPASSWORD -h 127.0.0.1 DBNAME
Not in a generic manner. You can restrict the access to the database server to trusted users but trying to achieve perfect (or even descent) security using code obfuscation is a pointless waste of time and resources in most (if not all) cases. Edit: there is one thing that you can do to make it a tinny little bit harder to see exactly what is happening in ...
Top 50 recent answers are included