Nicely said, a good balance of information and humor.

I was involved in the Sarbannes Oxley preparations last year at my company and we implemented the CobiT framework in IT (Control...

Are you sending encrypted data or looking to encrypt the data stream? SSL will encrypt the stream, but the data will be text in the server. If you encrypt on...

You need to run profiler and see what is actually being run through there. There has to be a bunch of transactions to grow the log like this.

Can you shrink...

Profiler is the least intrusive. You can setup a trace for a specific database and a specific objectid, like a table and then catch the person in the act.

David, the author letter is for all authors and comes directly from Andy. The last one was this past week. I deleted it, but I've let Andy know and he...

It's annoying me too. We're working on it.

Ahh, but a DBA could run a OLAP type db and not implement normalization. Or an object db where different rules apply. I tend to agree that a DBA needs...

you need to determine the cause for the suspect flag being set. Do you know the reason?

SQL Server doesn't really have any good load balancing solutions. What type of load balancing do you need? In an OLTP environment?

At PASS I saw a vnedor building hardware boxes...

I'd go with what I see in sp_configure. It's possible that the EM is pulling some information from somewhere else, but I'd bet that the sp_configure is what the server...

Not in master. too easy to forget on restore, rebuild of new server, DR, etc.

Store it in each db, build a script to redeploy to multiple databases if you have...

Sorry about the single line, forum flips out randomly.

I tend to store in a .asp include file, depending on what the data is. In a financial company, we did use...

sp_changeobjectowner or

create table personal.tableA instead of create table tableA

The old system grouped by forum, then listed threads by reverse datetime of the last post. We'll get there since I keep bugging Andy as well. I depend on this...

I found it annoying as well, but  changing it in my profile solved that issue. It isn't checked anymore for me.