IBM Notes Client error: "No Sitemap Error" when opening Inbox
paul | Friday, 29 August 2014 | Notes | Sitemap
Due to corrupt configuration files.
 
  1. Close down the client
  2. Navigate to the Data folder (c:\Program Files (x86)\IBM\Notes\Data)
  3. Rename the Workspace folder
  4. Restart the client

It should then allow you to open the Inbox without any error mesaages.

Display Comments...
Transferring Outlook 2010 Calendar to IBM Notes
paul | Thursday, 28 August 2014 | Migration | Outlook 2010
When transferring an Outlook Calendar to IBM Notes the following instructions can be followed.
 
  1. Run Outlook
  2. Open Calendar
  3. Select File menu
  4. Select Save Calendar
  5. Select "More Options"
  6. Change "Detail" to "Full details"
  7. Change "Date Range" to "Whole Calendar"
  8. Press OK
  9. Specify ICS filename/location when prompted
 
  1. Run Notes
  2. Open Calendar
  3. Select File menu
  4. Select "Import..."
  5. Select the saved file
  6. Press Import button
 
Notes that there is a limit of 500 calendar entries which Notes will import (selecting a date range for future entries only may help with this).
Display Comments...
Blackberry not syncing contacts
paul | Tuesday, 26 August 2014 | Blackberry | adress book

Contacts not synchronising with Blackberry device (pre-BB10).

Delete the sync setting from the service books on the device and then resend them from the BES server.

1. Options > Device > Advanced System Settings > Service Book

2. On BES in BAS select the "Resend service books to a device" option

More information on Blackberry website at: http://btsc.webapps.blackberry.com/btsc/viewdocument.do;jsessionid=BC8487E65EA6DA0C43F988F1F9A1FA69?externalId=KB10594&sliceId=2&cmd=displayKC&docType=kc&noCount=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

Display Comments...
SQL Server Backups - Optimizing performance
paul | Thursday, 14 August 2014 | SQL Server | Backups
SQL Server backups are pretty good in newer versions of SQL Server but for larger databases they can still cause issues. Some searching on Google has offerred up some Backup command options which can be applied to improve the throughput and reduce the duration of backups. Henk VanDerValk's blog article http://henkvandervalk.com/how-to-increase-sql-database-full-backup-speed-using-compression-and-solid-state-disks is particularly useful.
 
Basic Backup Command
 
Backup Database [Database1] To Disk = 'd:\backups\Database1.bak'  With COMPRESSION,FORMAT;
 
Backup Command with Additional Options
 
Backup Database [Database1] To Disk = 'd:\backups\Database1.bak'  With COMPRESSION,FORMAT,CHECKSUM,SKIP,NOREWIND,NOUNLOAD,STATS=10,BUFFERCOUNT=2200,BLOCKSIZE=65536,MAXTRANSFERSIZE=2097152;

 

Testing has shown that the buffercount,blocksize,maxtransfersize options are reducing the backup duration by an average of 60%.

Display Comments...
SQL Server: Enable the Dedicated Administrator Connection
paul | Friday, 01 August 2014 | SQL | DAC

You never know when you are going to need to connect onto a SQL Server to troubleshoot an issue so ensure the dedicated administrator connection (DAC) is configured so that a connection is reserved for emergencies.

The T-SQL below will configure the option.

sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
 
More information on MSDN at: http://msdn.microsoft.com/en-us/library/ms190468.aspx
Display Comments...
Page 1 of 53 (266 Articles) << 1 2 3 4 5  Next >>