Author: Harri Jaakkonen

Can’t change Office 2013 shortcut locations in the Office Customization Tool

Well this is annoying. When try to modify Skydrive or Lync shortcuts or even add a desktop shortcut they wont work. Hopefully there is a workaround for this. Add [ to Start In -box … like this: And you have…

Continue Reading Can’t change Office 2013 shortcut locations in the Office Customization Tool

How to display only user databases in SQL

This is how: select * from sys.sysdatabases where dbid>4 and [name] not like ‘$’

Continue Reading How to display only user databases in SQL

Find SQL-database backup dates

Type this query to find them:   SELECT T1.Name as DatabaseName, COALESCE(Convert(varchar(12), MAX(T2.backup_finish_date), 101),’Not Yet Taken’) as LastBackUpTaken, COALESCE(Convert(varchar(12), MAX(T2.user_name), 101),’NA’) as UserName FROM sys.sysdatabases T1 LEFT OUTER JOIN msdb.dbo.backupset T2 ON T2.database_name = T1.name GROUP BY T1.Name ORDER BY…

Continue Reading Find SQL-database backup dates

Remote powershell to Lync 2010 / 2013 FE

Connet session: $cred = Get-Credential domainusername $session = New-PSSession -ConnectionURI “https://LYNCFE.FQDN/OcsPowershell” -Credential $cred Import-PsSession $session Disconnect session: Get-PSSession | Remove-PSSession

Continue Reading Remote powershell to Lync 2010 / 2013 FE

What to do when VCenter start fails after demoting Domain Controller

MS SQL is the backend database, yes. If you have access to the DB server, the easiest way to view/modify the table is via MS SQL Server Management Studio. – Open MS SQL Server Management Studio and point it to…

Continue Reading What to do when VCenter start fails after demoting Domain Controller

Verify Exchange update rollup version

Open powershell and type: Get-Command Exsetup.exe | ForEach-Object {$_.FileVersionInfo}

Continue Reading Verify Exchange update rollup version