Backups are a particularly troublesome bird. Especially since throwing a password on a backup doesn't encrypt them. Speaking of which, anyone have any experience with SQLLiteSpeed and how it works?

K....

Another important point is the localsystem account has full administrative rights to the system, meaning if a client can compromise a sysadmin account, the client compromises the server.

I used to...

SQL 7 or SQL 2K? If SQL 7, download the forcibly shrink tran log script Steve Jones posted to the site. You'll need it.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

If you've not grabbed the updated BOL, the 38.5 MB DL is completely worth it.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

The last estimate I read on cracking true 128bit encryption for SSL (not the Netscape attempt of yesteryear where only 40 bits were actually encrypted to stay in compliance with...

The biggest argument against dynamic SQL: security.

If you're comfortable letting users have access to the base tables, then it doesn't matter. However, with the case here where you're trying to...

This isn't necessarily the case. It really depends on the encryption mechanism used.

For instance, 40-bit encryption for SSL was cracked in '95 or '96. However true 128-bit encryption would...

There is the script posted here (based on shoeboy's original post to a security forum) and there's also dSQLSRVD, which you should be able to find via Google. The latter...

Probably the easiest way is to parse everything in VB, it's not terribly difficult.

If you just want the first non-zero value, however, look at the coalesce function in T-SQL. I...

When you say only return what is not null, what do you mean? Do you mean if a particular field for a particular row is not null return that field?...

EFS is a very interesting technology... perfect for mobile users who might accidently get drunk with a laptop holding military software:

http://english.pravda.ru/main/2002/10/22/38519.html

If you've got sensitive data, this is definitely a technology...

More on the weakness of the passwords:

http://www.nextgenss.com/papers/cracking-sql-passwords.pdf

Of course, since this technique requires access to sysxlogins, you can only implement as a sysadmin. Of course, if someone can take advantage of...

Then your best bet is probably clustering using Windows 2000 Advanced Server.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Microsoft's answer:

http://www.microsoft.com/data/mdac21info/MDACinstQ.htm

Basically, they have one of two recommendations if you don't want to stay at the ugpraded versions:

1) Restore the system from backup or image

2) Rebuild the system.

Lovely, right? They...

The memory manager in SQL2K is supposed to handle memory across multiple instances reasonably well, but to be honest, my shop has not put it to the test. We have...