I had a bit of trouble setting this up, it seems that most people want windows to be the NTP server and Linux to be the NTP client (seems like a bad idea to me). In the end, I found the solution at experts exchange and it seems that windows can act natively as the client. Even better, it’s almost intuitive! On the windows server, open a command...
Read MoreWindows backup of postgres database
I’ve just implemented a bacula backup strategy for my work network, the one stumbling point was that we have a small postgres database which is fairly vital to be backed up. I didn’t want to leave it simply to MS’ VSS (Volume Shadowing Service) to handle the backup, I prefer to have a file which I can check that it’s OK,...
Read Morerestore “show desktop” icon
For all of the people that can’t live without their “show desktop” icon (although Windows-m minimizes) but have accidently deleted the icon, here’s how to get it back. I found this information here, but it seems to be readily available everywhere. Create a text file on the desktop (call it something like “show...
Read MoreContivity connection through firewall
My work uses a Nortel contivity client/server VPN configuration. This got a bit annoying because the VPN system doesn’t use the latest VPN ports as defined by ICANN and also because you need to open so many ports. Anyway, in order to get access you need to open up the following ports: TCP 50, UDP 50 TCP 51, UDP 51 TCP 500, UDP 500 UDP 10000 UDP...
Read MoreThe proposed new database owner is already a user in the database.
This is an error to do with a syncing issue as described here Sp_changedbowner will return message ‘the proposed new database owner is already a user in the database’ if the sysdatabases/sysusers mapping is out of sync and the sysusers dbo SID is already mapped to the login. All you need to do is execute sp_changedbowner twice, once to change...
Read MoreViews accessing other databases
The default behaviour of SQL Server 2000 post servicepack 3 is for databases not to be able to access other databases through views. This is a really, really stupid thing – when I first approached this, I got really stumped about how to allow a view to access a table in another database with the same database owner. The trick is a thing called...
Read More