Category Archives: DBA

Cleaning up sql job ownership

We have a lot of jobs owned by many different accounts due to the currently lax security. Before cleaning up the local admins group and removing all sysadmin role members it is important to make sure the jobs that are … Continue reading

Posted in Day to day, DBA | Tagged | Leave a comment

SQL Server 2000 sp4 and Memory

I configured 3 of the development sql servers to use the available memory last night. 2 had 8gb; 1 had 4. The one with 4 just required adding the /3GB and a restart; for the other two I modified the … Continue reading

Posted in DBA | Leave a comment

SQL Blogs I like

http://www.sqlskills.com/BLOGS/PAUL/ http://www.sqlskills.com/BLOGS/KIMBERLY/ http://sqlfool.com/ http://sqlinthewild.co.za/

Posted in Day to day, DBA | Leave a comment