Hot answers tagged

6

Well, you could not grant execute on it explicitly to end users (deny it even), and only enable it in stored procedures that use EXECUTE AS with some login that does have execute permissions. Then grant execute on only that stored procedure to the user that needs to run the command. First, make sure xp_cmdshell is enabled for the instance: EXEC ...


5

You can also setup a proxy account using sp_xp_cmdshell_proxy_account to allow non-administrators to use xp_cmdshell. This will allow you to setup a less privileged Windows account rather than xp_cmdshell always using the SQL Server service account. This is similar to setting up proxy accounts for SQL Agent jobs.


5

The no-beep option causes the mysql command line client not to beep when errors occur. If that's an option you want, it should be in the [mysql] section of your my.cnf. This error suggests that it's in the [client] section of your my.cnf, which causes mysql_upgrade to throw the error since the option isn't recognized. Check your my.cnf and either remove ...


5

The only option to think about is disk layout but you only have six of them. This isn't enough for "optimum performance" A RAID 1 volume with 2 disks will be around 135GB so if your database is 100GB+ you'd need RAID5/RAID 10 with 4 disks, but then you don't have enough for separate logs/OS/Tempdb volumes. As an aside, with 100GB+ DB why only 16GB RAM? ...


5

Please keep in mind that prior to MySQL 5.1.38, InnoDB was not designed to access multiple CPUs. You have one of two options to get MySQL to take advantage of multiple CPUs. OPTION 1 : Install MySQL 5.5 OPTION 2 : Install MySQL 5.1 InnoDB Plugin There are new options available since MySQL 5.1.38 (InnoDB Plugin Only) that is now fully available in MySQL ...


5

"Isn't it possible to scale database servers through virtualization, like forever?" Yes, you can make more and more database servers and you can also make a larger and larger database server (but the scale up limit can be reached very quickly), but in the scale out scenario are the servers you mention supposed to cooperate in any way or are they ...


3

You could still use xp_cmdshell; however, you'll need to make sure that your SQL Server Service account (the AD account used to run SQL Server) has access to the directory containing the exe file and any other directories that that program may require. xp_cmdshell runs on your SQL Server itself; you can use it just like any other command window. If, on the ...


3

Xp_cmdshell would work fine - just access the file using the UNC path (\server1\share\file.exe). As the other person mentioned, make sure you have proper permissions for you sql agent service account to access the file. If, instead, you actually want to run the file on the remote server, you can use a tool called PSEXEC that will run am exe on another ...


3

There are several reasons why this can happen: Make sure you are not using the query cache on your old server and not on the new one. Execute always benchmarks with SELECT SQL_NO_CACHE. Execute the same queries several times. If it is a new server -the buffer pool, filesystem cache and other buffer are probably not yet settled for best performance, ...


3

You can indeed do this, but I recommend against it. You can create a linked server on DB-SERVER-1, connecting it to DB-SERVER-2. You then could write a query using four part naming convention as follows: (assuming you are running this query on DB-SERVER-1) select * from DB1.dbo.YourTable a join [DB-SERVER-2].DB2.dbo.OtherTable b on b.ID = a.ID ...


3

I one up'd the answer above because, technically, it's correct on how to accomplish it. However, I would make the opposite recommendation. Meaning, I would recommend using linked servers for what you are doing. This is because it seams like you're asking the question about architecting Federated Servers using Distributed Partitioned Views techniques. There ...


3

So far (I'll update this as you provide more info). 2 disk RAID 1 for the OS, 2 disk RAID 1 for the data, 2 disk RAID 1 for the transaction logs. These are the kinds of questions you should be asking before you purchase hardware.


3

It seems that postgresql doesn't like your postgresql.conf file. The log message clearly says that it wasn't expecting a " character on line 392, but it doesn't tell you which one (of two " on this line) is it. I would assume that there is an unclosed " earlier in the config file.


3

No. If it starts to swap, it means that MongoDB needs more RAM than the system has available. Limiting the RAM used would make the situation worse. MongoDB uses only up to a certain limit (95% of physical RAM, iirc), which might lead to the wrong assumption that there is free RAM available and it must be a problem caused by MongoDB. Quite the contrary: ...


3

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. What this error means This message means SQL Server is installed on your machine but when it is trying to come online it failed. And the reason for the failure would be located at SQL Server errorlog file. Open the content of file in notepad and ...


2

Its an underlying table for sys.partitions, which returns the same information as SELECT * FROM sys.partitions But what is a partition? Refer to Partitioned Tables and Indexes on MSDN. idmajor is the column name that's commonly known as object_id idminor is the index_id. Lets do some testing now: I have used AdventureWorks 2012 from CodePlex. ...


2

Ideally you can shutdown using /etc/init.d/mysqld stop I cannot add comments so requesting to post what do you see in error log when you do mysqladmin shutdown About kill commands please note that mysqld_safe is wrapper script which will start mysqld upon killing... so you should kill mysqld_safe first followed by mysqld. ( not a suggested way ...


2

I probably found the reason, I made nightly backups to external server, but those were also stored on our server which had exceeded allowed disk usage. I didn`t understand /dev/vda1 at first, but I now get that is not a file but probably a partition or something like that.


2

You can use machines of different sizes as long as the lesser machines can actually keep up with the more capable primary when replicating (particularly at peak traffic times). You can use priorities to ensure that the more powerful machines are preferred when they are up and healthy and you can set any host that absolutely should not become primary to ...


2

The way to gauge hardware performance is to be take a look at your current workload. So I would begin by quantifying that: Take a look at Brent Ozar's perf tuning stuff Identify your bottlenecks (are you seeing bad parallelization, CPU chugging away without finishing, memory, storage) Determine what differences there will be between your new and old ...


2

There is actually nothing really wrong here, at least not based on what you have included in the question. Go back to this point: ubuntu-user@ubuntu-vm:~$ mongo MongoDB shell version: 3.0.1 connecting to: test Server has startup warnings: 2015-03-27T12:37:30.430+0100 I CONTROL [initandlisten] 2015-03-27T12:37:30.430+0100 I CONTROL [initandlisten] ** ...


2

If you install from apt-get you will be able to use apt-get upgrade option later and other apt-get build in options (available from Ubuntu). Furthermore apt-get installs binaries and manages their versions. You just install and nothing more. Installing from source gives you the ability to do a more detailed installation. (You can customize the build and ...


2

You should not need to DENY CONTROL to a login. Simply do not GRANT the right to that user. Regarding the side effects of DENY CONTROL see the post here: http://sqlity.net/en/2102/deny-control-side-effects/ Comment from that link: "The only option you have is to pay careful attention to not grant any permission to the principal that you did not indeed ...


2

It sounds to me as if the D: drive isn't accessible when the SQL service starts. Consider telling the service to start on a delayed start, or create a process which checks for a file on D: before doing a "net start mssqlserver".


2

SQL Server has transparent database encryption, which provides the functionality you are looking for. TDE performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery. The DEK is a symmetric key secured by using ...


2

MyISAM or InnoDB? Depending on which, you need to see the appropriate cache buffer. If you had 16GB of RAM, you could set that so that the table will (eventually) be entirely in RAM. That would move it from being I/O bound (as it probably is now) to being CPU bound. At that point, an old, slow, cheap, spinning drive will be almost as good as SSDs. Can ...


2

No i disagree. I dont believe it should be faster on your laptop given the spec you have just described. I also dont believe a difference in version or flags should explain it either. A 9000% difference suggests something is going very very wrong. You should expect to get at least the same or similar result on the server, or even better. At this point ...


2

No. The instance is configured to use cluster resources and as such if the cluster is removed the instance will not function correctly. If you like to play with fire in an experimental-not-in-production-learn-by-trial-and-error way, you can do the opposite of How to move SQL Server from Standalone to Cluster environment.


2

For this scenario, the database server should not be publicly exposed, for obvious security reasons. You should expose a public interface (API) of your application, probably by using something like web services. The mobile application instances then only communicate directly with the API. This separation (decoupling) allows for all sorts of good things to ...


2

Note you say this is in the server log and there are no known problems with clients. Consequently, I don't think that it is libpq per se. Additionally on doing some additional searches, it looks like this is a standard Windows "connection refused" message, which suggests that PostgreSQL is trying to connect to something and being refused. If you are ...



Only top voted, non community-wiki answers of a minimum length are eligible