Hi,

Here are some recommendations for you:

1. Secure the Web Tier

You need to ensure that your application/website tier validates all user input before passing it on to the database layer. Rather...

One further point, as far as I understand things, SSIS uses a specific protion of a servers memory, sometimes called the memToLeave portion of the entire SQL Server Memory space.

So...

Hi,

Hope you are enjoying the weekend.

Take a look at the following Microsoft article. It provides details and generic instruction as to how to performance tune SSIS projects.

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx

Hi Nag,

Take a look at the following resource.

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1316451,00.html

There is quite a lot of information here, with references to additional resources at the base of the page.

Hi,

Here is a little something I often use to perform a table wide replace.

You could quite easily extend this for all tables within a database and additional data types should...

Hi,

Why not just use SQL Server Management Studio, to work with Analysis Services?

The BIDS suite is also used to buil and deploy your Analysis Services projects in SQL Server 2005.

I have just found the following link that may be appropriate however is it safe to make these changes on a live production server?

http://support.microsoft.com/kb/899634

Many Thanks,

John

Hi,

Thanks for your comments.

I wanted to avoid copying the table because of concerns that the database application may change the data during the copy process. Ideally I would like to...

Hi Tim,

Thank you for your comments. Standard edition is what the environment will be running.

We also have plenty of room for expansion on the existing SAN, so as you say...

Thanks Brian.

Good point, although given the amount of licenses we have, one more will make little difference :-).

Hi Subhash,

Thank you for your comments.

I am not sure if we would need to create a new Virtual Name and IP. I was under the impression that we could simply...

Yes please do.

Thaks for your comments.

Hi,

Thank you for your reply.

It sounds as if we are thinking along the same lines. I was planning on implementing a separate SAN if we were to go ahead and...