Christopher Shennan's Blog

A day in the life of…

Browsing Posts in MSSQL

I recently had to back up a MySQL database on a windows server so I could restore it to my local MySQL server for analysing the structure of an existing site which we are going to be rebuilding. I have done this hundreds of times on linux server but the usual command did not appear to work on this windows server. I was using:-

mysqldump -uroot -pPASSWORD database > c:\database.sql

but when I ran this I was presented with an “Access Denied” message.
continue reading…

For several months now I’ve been using eSense Visualizers for Microsoft Sharepoint to output the contents of a database in a meaningful and easy to understand view that is suitable for the client, although lately I’ve not been using it as much.  Just this morning I’ve had to use it for a few hours again and I’m quickly remembering why I don’t like it and I have several issues that bug me (and I’m hoping it’s not just me).  These include:-

continue reading…