Hey Guys,
Is it a bad idea to put Exchange and Sql Server on a same box?
We have about 4-5 GB database and 10 users for exchange, can this work?
Thanks
I have a scenario based question...Something , I haven't faced till now ,but i would be interested to know the answer.
If i have assigned a luns (say, of 50 GB) and put them in storage group.However, the windows server team did not grab that lun but sent an acknowledgment saying the Luns are alingned.
I would like to know what will happen to the Luns that belong to the SG ..in my opinion they will remain in the SG as unassigned Luns ..or is there a possibility that the lUns will move back to the storage.
I have 8 SQL Server installations (on 8 separate servers).
I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?
Hello,
I run into the same issue as someone who posted this question on experts-exchange.com (couldn't read the answer though as I don't have an account there):
{Quote Begin}
I noticed that the 180-day Evaluation version of SQL Server 2008 is the
Enterprise version. Is there going to be any problem "upgrading" the Evaluation Enterprise
version to a licensed STANDARD version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?
{Quote End}
Any advice is appreciated.
I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.
I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.
Thanks in advance,
Dan
Hi,
On a SQL server, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
here can I find somewhat reliable indications of server market shares, without having to fork out $$$$$ for IDC or Gartner reports?
I have considered the W3 statistics, net applications etc, and these are not what I would consider reliable.
Is there anything more, that is free?
I have a local user of a windows Server 2008 that is a member of builtin Users group, a program that run this user need to have write access to a Key located in the HKEY_LOCAL_MACHINE, can i enable this user to have write access in HKLM without adding it to Administrators group ?
Thanks.
I have folder to be shared on window server 2008.
If i disable all firewalls then MAC can see the folder
If i enable firewall then MAC can't connect to my folder
WHich rule i have to apply in firewall setting to make that share work
Please provide your tips and best practices for virtualizing SQL Server in VMWare ESX
I am interested in advanced configurations and settings.
Please provide reasoning behind your recommendations
Edit:
Just to clarify, I already have over 70 Virtual SQL servers in separate clusters using an ISCSI equallogic San -
What I am really looking for are those advanced configurations like:
How you configured your disks / RDM's
Do you make use of settings like
Mem.ShareScanGHz - http://communities.vmware.com/thread/143828 -
that are not well documented
I am trying to figure out how I can connect to an ESX server's storage system so that I can upload VM image files. I am a windows user if that matters (i suspect it does).
Thanks in advance
I have a Sql Server database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on these tables). I have no clue what could be causing this as I would assume zero rows would mean nearly zero space taken.
Any ideas?
Hi,
I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensible data. Is it possible?
Thank you all for help
Now that Windows Server 2012 comes with de-duplication features for NTFS volumes I am having a hard time finding technical details about it. I can deduce from the TechNet documentation that the de-duplication action itself is an asynchronous process - not unlike how the SIS Groveler used to work - but there is virtually no detail about the implementation (algorithms used, resources needed, even the info on performance considerations is nothing but a bunch rule-of-thumb-style recommendations).
Insights and pointers are greatly appreciated, a comparison to Solaris' ZFS de-duplication efficiency for a set of scenarios would be wonderful.
I currently have VPS in my company and there i host about 20 websites.
My company wants to set up server locally where they can host all websites rather using 3rd party VPS
How it will cost e,g about upload ,download speed from data centre.
Cpanel license
IP registration,
hardware ,
backups,
electricity backups,
Any other costs
etc
I would prefer centos
Am I correct that the NET TIME command should return the time from the PDC for the domain?
If so, the issue we are contending with is that NET TIME command returns \randomfileserver.
How do I reset time server for domain to be the PDC?
I have a SQL server behind a firewall. I need to push some limited SQL 2005 information to a Web Server in the DMZ so that I do not have to let database queries come all the way into the database server on our internal network. I want to push a small amount of dynamic data to a Web server in the DMZ and lock it down so that our hosted website does not need to come into the internal network for information; I want to put a server in the DMZ that will be the only connection allowed to the SQL database. This DMZ server will be the only server that can have any sort of connection to the back-end database so the hosting provider just pull the data from our server in the DMZ...
Hi,
I am wanting to setup a internal development server (LAMP), I need the web team to be able to access different developments sites ie:
example1.local
example2.local
example3.local etc
from within the network.
I believe it would be something to do with DNS?
Any help would be appriciated.
Kyle
This question already has an answer here:
What permissions should my website files/folders have on a Linux webserver?
4 answers
I have a dedicated server for my website. There are no other users, and no other websites on the same machine.
Is there any risk in setting 777-permissions on my site's public_html folder, bearing in mind configuration files with passwords and access keys are stored outside that root?
I'm having a strange problem with a SQL Server Maintenance Plan. It's set up to run a Reorganise Indexes and Rebuild Indexes, the history shows it has succeeded, but the fragmentation is still bad and requires me to manually intervene to fix them.
Has anyone seen this before?
Client asked if we can host our application for them on Amazon Cloud. The app has database running on MS SQL Server which is approximately 20 Gb in size.
We need to update the database almost every night and approximately 75% of all data is overwritten each time.
Any idea whether Amazon EC2 can reliably handle a load like that?