one time we needed to restore msdb from 6 months ago and we didn't have backups that old. now i keep them for a year or so. usually when the...

i do full backups 5-6 days a week. only because each tape lasts a year or so for system db's and i have 3 tapes dedicated to it

we're looking to replace 2 nodes in an active/passive cluster and so far the plan is to add a new node and then evict an existing node. then do it...

could have been a delay in replicating DNS data. it takes us 20-30 minutes to replicate DNS data.

you change the IP, but SQL uses host names to find servers. DNS...

the easiest way is to set up a subscription to email the report on a regular basis and save the emails

when i get around to it, i'm going to write a powershell script to back it up to a folder that will then be backed up to tape

for HP check out Proliant DL 380 G7. we use G5's and will probably buy a few G7's soon.

EMC is expensive. check out netapp. never used them though.

Stejones (10/21/2010)

---

I have been here a couple years now so I almost take it for granted but:

Free drinks (coffee, tea, cokes,oj, apple juice)

Free lunch (1 day a week hot lunch...

i've noticed that a lot of DBA's tend to specialize and rarely change ways of doing things. i've seen DBA's who can write very complicated code but don't know a...

i use surrogate keys all the time. over the last 2 years i've been building a reporting system to track event log data. the Windows event logs have a record...

i have a db that i designed to hold data from security logs from servers. security was a big concern for me. it's not the most glam solution but what...

i think that if you're adding triggers to try to keep track of every single change you have problems, security problems. it's a huge performance hit to have triggers on...

Mark Salvador (2/5/2009)

---

When I left join them like this:

select *

from sys.dm_db_missing_index_group_stats AS migs

left JOIN sys.dm_db_missing_index_groups AS mig ON migs.group_handle = mig.index_group_handle

left JOIN sys.dm_db_missing_index_details AS mid ON mig.index_handle...

don't get too technical when talking to them. have a summary for everything you want to do with the reason and risks

and the most important thing is learn how to...

thx for your help. originally had the inner joins in there but used ands to see if it would change anything after it wasn't working. with your help i also...