This can be a really complex topic and many variables can change the approach, but here are a few things that may help you:

> On a 32-bit system adding memory...

More information about what you are trying to encrypt would have been helpful. But in a nutshell you have three ways to protect your data at rest:

1 - Encrypt using...

I have not tried this with those statements, but have you considered changing the default column width? In option -> Results (query analyzer), you can change the characters per column...

Is this the security alert you were looking for? It was issued for the slammer worm that performs a DOS through UDP 1434.

http://www.microsoft.com/technet/security/alerts/slammer.mspx

Yes there is a way. You need something like a sql server firewall or proxy that will give you this kind of control. There is a version available for free...

Depending on the version of the SQL Server you are using you could use a DDL Trigger for Logon access. You can have full control on who/what/when/where. You will need...

Would a DDL Trigger work for you? The DDL Trigger would determine if the server name is A or B, and allow or deny the connection for a specific login...

Let me take the PLE (page life expectancy) part of your question. The PLE measures in seconds how long a page remains in memory before being reclaimed/flushed. In certain situations...

Andy, performance issues on SQL Server can be tricky to track down. Starting with Profiler is probably the best option. Typically when I do not know which procedure is causing...

Hi,

If your goal is to track which account is logging in, a good start would be to enable auditing within SQL Server. This would allow you to see the login...

James - auditing logins for the sa account only should not have any visible impact to your SQL Server performance. If you have a couple of SQL Servers to audit...

On SQL 2000 you only have one thing available: the MAC address of the client machine once it has connected. Look at SYSPROCESSES in the netaddress field. It contains the...

You can also try Enzo Audit - the new release just came out - it's a simpler product, but very effective - it comes with alerting capabilities and a...

A blanket block by IP would work if this meets your needs. If you need more granular control send me an email; I have something in mind.

Consider implementing a progressive migration plan so that metrics can be taken over time.

Since your shared resources (CPU, Memory, Disks, Network Cards) will become your bottlenecks, understanding how they are being...