Viewing 15 posts - 35,296 through 35,310 (of 39,720 total)
Having your CV up to date should always be part of your DR strategy!!!!
. Even if you recover things, it may not be...
January 28, 2004 at 3:55 pm
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,...
January 28, 2004 at 3:45 pm
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...
January 28, 2004 at 9:45 am
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...
January 27, 2004 at 5:06 pm
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...
January 27, 2004 at 10:48 am
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.
January 27, 2004 at 10:17 am
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...
January 27, 2004 at 9:53 am
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...
January 26, 2004 at 5:43 pm
you need to determine the cause for the suspect flag being set. Do you know the reason?
January 26, 2004 at 5:37 pm
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...
January 26, 2004 at 5:34 pm
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...
January 26, 2004 at 5:31 pm
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...
January 26, 2004 at 5:30 pm
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...
January 26, 2004 at 11:48 am
sp_changeobjectowner or
create table personal.tableA instead of create table tableA
January 26, 2004 at 10:30 am
Viewing 15 posts - 35,296 through 35,310 (of 39,720 total)