When working with sql server recently, I changed the initial configuration so that I could use it via a VPN IP address that was used and I also told sql server NOT to listen on all IP addresses also. I found that a website I was working on had stopped working, turns out that the sql server process had restarted and failed to start! (more…)
28.Nov.09 
Databases, Sys Admin 
Submit a comment
Are you using MySQL and your password, even though you are sure it’s 100% correct, isn’t letting you login? Are you getting ‘error establishing database connection’ errors from wordpress (or some other similar message)? This might crop up if you are running your own MySQL server on your own linux distro. (more…)
02.Feb.09 Databases Submit a comment
I had to make sure (very quickly) that users in a particular database had properly formatted email addresses, as some of the email addresses were missing characters, making the email address invalidand generating undeliverable email reports on the server eating up diskspace! (more…)
Tags: charindex, filtering, sql
17.Jan.09 Databases Submit a comment
Ever look at those sql server files and say: “How come they’re so big?”
That’s usually because of transaction logs, they keep a record of all the activity, so that in a worst case scenario, you’d be able to restore rows that were affected by an update operation (in simple terms). (more…)
Tags: log files, shrink, sql server
14.Dec.08 Databases Comment (1)