• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

Test SQL Connection in Azure

Azure VMs and connectivity brings some interesting challenges to the fore. I have a scenario where I created 4 new VMs (3 x app and 1 x sql). The App servers are bare bone so did not have any SQL client tools. I found the method below the easiest way [...]

Read More

Slow People Picker

We recently updated our AD configuration to include a 2-way trust with a number of other AD domains. Since the change our People Picker has been extremely slow (up to 3 minutes) and often timing out. Using the address book function was fine as a workaround but as soon as [...]

Read More

Move search index location

When you install SharePoint 2013 there is no option to change the default search index location (like the ULS log folder). If (like us) you keep your default c drive small and only allocated for installations it can cause some issues with size as the search index grows. Unfortunately there [...]

Read More

Azure Backup

Now in public preview, Long-Term Retention (LTR) allows you to enable your databases to create weekly backups stored in your own Azure Backup vault and extend the retention period built into SQL Database from 35 days to up to 10 years. This drastically improves the functionality in Azure to serve [...]

Read More

Unable to retrieve all data

We recently ran into some issues where we could not export a Sharepoint 2010 list OR successfully edit it in datasheet view. Even though the list is fairly big we have not issues with other lists of the same size. When exporting to Excel we get the error: An unexpected [...]

Read More

Azure: Temporal Tables

Will be adding some Azure content just to try and keep myself sane with all the new features and updates rolled by MS. Temporal Tables: Nice new feature that enables versioning and history out the box for SQL databases, so no need to build your own archiving etc. Hit the [...]

Read More

SPContext.Current.Web.CurrentUser.LoginName

We had an issue where the SPContext.Current.Web.CurrentUser.LoginName displayed the incorrect (old) login for a user i.e. user loginname was changed. In most cases it works to run the migrateuser command to link the old and new account. But in some cases this does not pull through correctly. The following solution worked [...]

Read More