Here is where I must concur with Celko. Nulls should be avoided except when a null value has real meaning to the business logic. (ex: CancellationDate, or MiddleName )

The...

what happens when you just execute this statement:

SELECT @to AS Recipient, @copy AS Copyto, @subj AS Subject, @message AS Body

FROM dual

Might be a permissions issue.

We wrote our own encryption classes in .NET using the cryptographic objects/methods. This gave us the ability use our own key management, and be able to encrypt/decrypt data from (T-SQL)...

"For the record, in defence of programmers, I have to say that while DBAs are expert at administering and maintaining database servers, few of them would have comparable skills in...

did you run:

sp_dropserver 'oldServerName'

sp_addserver 'newServerName', 'local'

if not, please do that then bounce the service.

On 64bit OS, 16 bit installers will not work and 32 bit drivers will not work. But unless you need to use SQL native client for your application to work...

The clients should continue to work as they did before. I say this with a slight caveat, because if the application is doing anything strange, or perhaps depending upon a...

There are several products (GFI Faxmaker is one) that work with Exchange or any other SMTP server to provide fax capability. This technology is reliable and has all of the...

You might want to consider database mail as a way of sending faxes. You have a lot of flexibility, even passing a query to the senddbmail method. It is...

sheesh. Lighten up celko. lol

Yeah, that methodology won't cut it. If the the volume of this syslog data is really high a C++ program running native is the way parse and pump this stuff...

Any non-clustered indexes need to be updated to point to the new data pages when page splits occur so it will take longer when other indexes are involved.

Null state of a column is determined by a bit in a null bitmap for each row. If there is no null bitmap, or an existing one is full a...

I would simply do this with a separate .net program. I have seen (and used) a third party syslog parser and loader program as well but it also did inserts...

I would concur with Craig's advice.