Having your CV up to date should always be part of your DR strategy!!!! . Even if you recover things, it may not be...

I don't know of a way to alert on a particular user. You can alert on login, but I don't think that will help you.

If this is an ongoing issues,...

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