A number of the default “apps” that Microsoft provide tend to get on my nerves, as I have Skype and Office already installed I was annoyed to see the “Get Skype” and “Get Office” were listed. I tweak the below on all new machines as some members of my family do have a Windows Phone […]
The following allows you to work out the current time on the Unix Environment. The Datediff function is used to work out the number of seconds between 01/01/1970 and the current date. I have used this against data which is stored and as Unix time.
|
1 2 |
--Get current Unix datetime SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) as UnixTime |
Other resources for T-SQL Dates: DwainCSQL
The server.id can be setup to have a password. This can cause problems on Windows where on Windows 2003 the Domino server starts, however it expects a password. This caused me the issue of getting stuck when logging in. Although passwords are recommended I tend to rely on the security of the server (Ensuring only […]
This Outlook 2010 VBA code was used to impose a time when emails could not be sent and were instead delayed until the next work day. This was put together (Credits go to key parts of this VBA are in the actual code) because the Managing Director where I work realised he was making people […]
Note: I can’t find who to credit with this, I believe it was the IBM Notes forum but I never took a URL. When IBM Notes 8 is installed mailto links will still launch the Standard Client. For machines which you want to launch the Standard Client the registry needs to be amended Open the […]
I had an issue where corruption on local Lotus Notes Database views resulted in views such as the Inbox showing [Replication or Save Conflict] instead of actual emails. For me this occurred during migrating nsf files to the latest version (Version 6.x to Version 8.x) on Lotus Domino (Domino was already version 8.0.1 however we […]
If a user finds they are unable to turn off their Out of Office Alert after setting it on Domino Web Access in version 8.0 the below fix from IBM Notes Forum can correct the affected Agents behaviour. 1. Run “tell amgr sched” on all the servers in the Domain in order to verify in […]
To setup the Domino 8.0.x SNMP Agent (If not included as a feature when installing Lotus Domino) first ensure Windows snmp service is installed and stopped. Dominos SNMP utilises event4.nsf and therefore can be customised as required. We can instruct the Domino Server to install a service on Windows by running the following in a […]
The following has been used to backup a server with Cisco Cubac on. The software runs on Windows 2012 machine and uses SQL Server 2008 Express. As its not on a managed server I had to find a way to backup the server and the database, plus keep the backup as small as possible. I […]
This code was used to speed up the setup of SyncToy 2.1 (I see no reason to backup the entire user profile folder, but I hate having to setup multiple sync jobs). As Microsoft has not updated SyncToy it may not work on anything other than Windows 7. The script expects SyncToy 2.1 is installed […]