Dave,

Are you referring to scanning anything on the server except the data & log files?

We have real-time protection enabled on most of our servers & have not seen a performance...

MIchelle,

A couple of cons of going directly to tape are that it takes  quite a bit longer to do a restore from tape as opposed to disk.  It is good...

As Brian suggested, turn on the auditing of failed logins.  We then created an alert to email us any any failed logins. We used the following to email us of...

I have taken the microsoft classes at New Horizons & attended the PASS conference last year.  I would say the more indepth training was at the PASS conference.  The in...

Robbie,

It will be supported as the official release of service pack 1.  There is a  CTP of SP1 out that supports mirroring.  I can't remember what the timeframe that has...

Thanks for the replies.  I didn't think this would work but I wanted to get it confirmed.

We are getting a new EMC SAN but we were trying to conserve space...

I have installed SQL 2005 standard & developer edition on an XP machine.  It was a pretty straight forward installation.  I don't have any answers for you but wanted to...

Boon,

Yes, there is a SQL 2005 Developers Edition.  I am not what it costs normally but with our nonprofit discount it is only $16.  It is probably around $50 normally.

HTH,

John

Alex,

This is a bug in DTS.  There is a workaround that my fellow DBA found out on the web.  It has something do changing one of the properties in your...

I believe SQL 2005 Express is the only version you can get free.  You would have to purchase a standard license to get a copy of SQL Management Studio.

John

Yes, it will be OK but don't expect to get good performance with it just because the drives are RAID 10.  If this server will get much traffic at all,...

I know there are several SQL tuning tools out there that do a nice job of this.  I saw a webinar from Quest software on their tool.  It will show...

Here at our company, the database performance monitoring & tuning is the DBA's responsibility.  Our sysadmins are responsible for the network & server hardware.  Our sysadmins no nothing about SQL...

I would agree with you that a best practice should provide the optimal result.

In our data warehouse environment, we have our main data warehouse database & a few other supporting databases. ...

I am pretty sure I didn't say that I did have the optimum configuration.  I just said that I believe this is the first time I have read that this...