Hey there! I’m Toni, the Co-Founder and CEO of Syskit, creators of Syskit Point and SPDocKit. Welcome to Toni on Tech, where we explore the ever-evolving world of software, technology, and business.
-
Getting Users to Appreciate Lookup Columns in SharePoint – Part III
Use case 3: Lookup list for reusable items (many-to-many) The last use case is the list of products which are stated on the invoice. Any invoice can contain more than one product. In this example, the products are software licenses. The name of the list is “Invoice Items” and looks like this: As you can…
-
Getting Users to Appreciate Lookup Columns in SharePoint – Part II
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 list, such as “Organization Name”…
-
Getting Users to Appreciate Lookup Columns in SharePoint – Part I
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 of use cases related to…
-
Manage Azure database security with T-SQL
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 advanced properties including security. The…