If it's not showing Hai, what is it showing?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Completely depends on what I'm doing. For instance, I stated it as A.B.C.D, but I'd write it as a 32 bit stream... very handy when doing masks that don't follow...

If you can command-line the process, you may be able to reduce it's priority by using the start command. I've never tried it for a non-interactive process, though. Executing a...

I have used bitmaps in a few cases, but like most of the comments here, the relational approach is the way to go. If I *know* that the number of...

In SQL Server 7.0 and higher the TOP operator is available. For instance:

SELECT TOP 10 OrderID

FROM dbo.Orders

ORDER BY OrderDate

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

And as would be expected, this is as accurate as your DNS is. If systems aren't auto-registering properly (or DHCP in Windows 2000 isn't handling it properly for clients that...

Good point on getting your incident response team involved if you have one. All of us neglected to state this. If it's a hosted solution, etc., talk to your ISP.

K....

Correct, the spXXX behaviour and sp_XXX behavior are different. spXXX is treated like uspXXX so long as spX isn't sp_ (just to be clear).

sp_ behavior:

It looks in syscacheobjects for a...

And try to make the "password" a phrase. That eliminates a dictionary attack and the length tends to make a brute force attack less feasible. For instance:

ManchesterUnitedIs#1!

It has...

It is confusing. I haven't seem many straight-forward licensing agreements.

Internally, if you already have the CALs, then no, the per processor licensing may not be the best option. You can...

To piggy-back on Andy...

The GO is a batch separator, it's not an actual T-SQL command. Query Analyzer uses it to realize what T-SQL statements to group together. That's why you're...

Here's the problem you run into... you only are guaranteed a Windows username is you're using Windows authentication. Named Pipes happens to be a communications mechanism that's requiring authentication.

Keep in...

You may also want to set up SQL Server Agent alerts to fire when an invalid login is attempted. Might give you enough time to fire up a packet capture...

Doh! I did write concurrent. Trying to do too many things. Jonathan is 100% correct (figured I'd better respond other than confuse you more).

If you choose to go the...

Agreed. Security people are paid to say no first. It doesn't make us very popular.

With that said, business must make the decision between security and...