Are there any dump files?

That would be nice. I like when Google does that as well.

How about database icons instead of stars? Okay, maybe that's too geeky. Just a thought.

I like to see certifications, but they aren't what I base my final opinion on. Case in point, I was asked to sit in and give the technical portion of...

This may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

The reason you can't see more than 2 GB in the server properties dialog box is because SQL Server is only able to see 2 GB until the...

I believe you're only going to see the 0xA5 if passwords are being entered. Reason being the encrypted stream is just as long as the original password (ouch). What you...

This will help you know what packet to look for:

http://www.freetds.org/tds.html

Also, a sign that there is a password is if in the login packet you see 0xA5 every other character....

We've had backups with VERIFYONLY fail to restore correctly with the proper data, so yes, the only sure way is to do the restore. The file size sounds like a...

You can use xp_cmdshell to call the command-line ftp client. If you've got all the commands to execute in order (including the login), you can use the -s:<filename> to tell...

One caveat: if the user doesn't have access to the table/column, it won't show up in this query using the information schema views. If you're accessing as a user with db_datareader or db_owner, for...

In the past when I've given oral tests, I tended to ask open-ended questions on purpose. The reason being I wanted to see your reasoning process. This through a couple...

Don't forget the dragonfly!

Oops, missed the autonumber part. Doh! Thanks, Noeld, for catching that. For SQL Server, use the IDENTITY(1,1) to autonumber.

It may be one of the worms that go after sa with a blank password. A network trace could tell you for sure. If so, they did go after ranges,...

ALTER TABLE tbl_open_order

ADD rownum int NULL

or

ALTER TABLE tbl_open_order

ADD rownum bigint NULL

Depending on the number of bytes you need for the integer. NULL is necessary if you have rows until you...