Great news guys!  Congrats!  May you guys find continued success in everything you do!

Hehe.  I was interviewing with the CEO of a manufacturing company for an IT Manager position when an employee came in to tell us every client on the network had simultaneously...

That would address Microsoft's business decision for creating such a program; however, it does not seem to justify the business decision that individuals and corporations must make in investing in this program. ...

No offense taken, just wanted to point out the value that this community adds to Microsoft and their product offerings, generally at little to no cost to Microsoft.  Communities like...

By "this community" is it safe to assume that you're talking about:

- All these developers who use SQL Server, .NET, Windows, and nearly every other product Microsoft puts out.  The old...

A bit is a bit, and a byte has been 8 bits since sometime in the late 1970s when they did away with 10-bit, 12-bit, and other strange byte sizes (Anyone else...

Thanks.

There was a question about how to access the functions from a database other than the master database, but I didn't have a chance to respond previously.  Just use 3-part...

Hi eengler,

You're right, it's good programming practice to explicitly cast your results to the proper type.  You should also specify a target size for the cast data type or SQL...

Thank you Priyaranjan, I appreciate the feedback!

To "escape" single quotes in SQL Server, you have to double them up meaning you put two single quotes back-to-back:

SELECT * FROM [Login] where [User] = 'Frances'' test of...

Yes, unfortunately the SQL Server SOUNDEX() function stops encoding a name when it encounters a non-alphabetic character.  So "DE LA POINTE", "DE LA SOUL", etc. will all encode to "D000". ...

The code was changed to reflect the NYSIIS "standard" a little better after the article was published (see this discussion board for details).  The "H" in Johanson and Johannsen is...

This package doesn't have any asymmetric encryption routines.  All of the encryption algorithms implemented are symmetric encryption algorithms.  (See Windows Help file for more info).  If I were going to implement...

The only time (that I know of) that SQL returns NULLs with SUM() is if there are no rows to SUM.  This is the case if: 1) There are no...

Yes, the encryption is tied to the local machine via the CryptoAPI.  This is by design.