130 reputation
16
bio website 2bsoftware.co.za
location South Africa
age 31
visits member for 2 years, 2 months
seen Mar 7 at 14:49

code monkey


Jan
11
comment Migrating SQL Server 2008 R2 to new server
I confirmed that the server names are the same (@@server and physical server). The new servers are on a completely different network, actually different country. So having the same name is not a problem. I already script the sql jobs as part of my daily backups, so I'll restore them from there. Thank you for warning me about those.
Jan
9
comment Which stored procedures are using a specifc index
excellent article. thank you for the info
Jan
9
comment Which stored procedures are using a specifc index
thank you, that helped a lot and explained the high usage
Oct
4
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
Thank you Jon, what you stated above is matching up with my findings/testing. Things are slowly coming together now.
Oct
2
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
Thank you Jaime. A whole bunch of lights went on this morning in my head. I got a bit of information overload from all the books and articles, but concepts are starting to come together now.
Oct
2
comment Sql Server 2008 R2: Simple recovery model with transaction log backups
very true - working on that. I'm a developer who accidentally fell into the role of DBA a short while ago, so busy testing and configuring everything correctly now (and building up knowledge at the same time). That's kinda how it goes with small companies :)