Monthly Archives for February 2014

Getting Users to Appreciate Lookup Columns in SharePoint – Part II

Office 365, SharePoint, SharePoint 2013 - Toni Frankola - February 27, 2014

Use case 2: Lookup list with additional attributes The list I created for thsi use case is: “Clients”. You can see it bellow – it has a couple of attributes, it’s not as simple as “Payment Methods”. The purpose of this example is to show that some attributes of this…

Continue Reading

Getting Users to Appreciate Lookup Columns in SharePoint – Part I

Office 365, SharePoint, SharePoint 2013 - Toni Frankola - February 27, 2014

A software engineer or a technical person can easily understand the benefits of lookup columns (in SharePoint or any other system). However, not every SharePoint user is familiar with the concept of foreign keys and the advantages they provide. In this and next two posts, I will present a couple…

Continue Reading

Manage Azure database security with T-SQL

Misc - Toni Frankola - February 10, 2014

This is slightly off-topic but we recently deployed some SQL databases to Windows Azure. I wanted to tighten security and allow users to connect to a particular views only. To my amazement, even though you can connect to Azure databases with SQL Management Studio, you cannot manage any of the…

Continue Reading

Deleting a SharePoint Subsite in Office 365

Office 365, SharePoint, SharePoint 2013 - Toni Frankola - February 5, 2014

Some weeks ago I got this screenshot from an end user: OK, I changed his red caption a little bit. The text was more similar to “How THE HELL do I delete this???” You might be tempted to think that the delete button is just around the corner, but I…

Continue Reading