Some quick SQL tips for myself

osql -E- Login with your Windows credential to change your authentication mode to Mixed Mode (meaning you can use both local password such as sa, and Windows Credentials), change… HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode from 1 (default) to 2(mixed). Now that you have mixed, mode you can change the sa password.. osql -E sp_password NULL,”<new-password>”,sa go

Excessive memory usage in services.exe in windows 2003

I had an SE contact me about services.exe using excessive memory on some of his boxes (~130MB.) As he was worried about this (and he had a ticket), so was I. I started with the semi-handy Process Explorer from Microsoft. I’ve been spoiled by the nifty things you can do with UNIX (lsof for instance), …

Continue reading ‘Excessive memory usage in services.exe in windows 2003’ »