Office 365 and more

I just kept thinking why can't I just use the Azure Information Protection (AIP) Label as an Office 365 Label. If you think about it using the AIP label sounds so logic. You have the security with AIP your data is encrypted and secured. However you want to enable other things like Data Loss Prevention (DLP) on the content Making an AIP Label visible in Office 365 label is not possible at this moment BUT Microsoft is working on it. I heard the planning is somewhere end of Q1 2018 or later. I understand from Microsoft standpoint that it's not easy combining a tool they bought (AIP was bought from Secure Island back in the end of 2015) with other technology the fact they got AIP up and running so quick is a big achievement.  In a demo they gave during Ignite 2017 Microsoft showed that it is going to be possible to combine AIP and labels so that's pretty cool. You can find the video here . I created an image so you get an idea of what I'm talking about. Left is AI...

I didn't want that the search results were being loaded before I had fired of a query in the search box. To prevent SharePoint from starting you can use the Query below. {?{SearchBoxQuery} (path:"<URL>") (IsDocument:"True" OR contentclass:"STS_ListItem")} This way you can search in a specific library for a certain contenttype but it won't load the data till the SearchBox has been entered.

In this article I'm describing the 5 levels of security for BYOD (I know Level 0 is 6 but I'm not counting that one). These 5 levels can help your environment to work open and safe with data on an enterprise environment. Level 0 - Lock Don't leave phones/tablet's/laptops un-locked on your desk. This is a no-brainer. Level 1 - Password The Password! I'm not talking about the pattern you have to draw on your Android phone or the swipe action to unlock the phone. No, real passwords! The password creates the feeling of security for the user. However the password is also the most vulnerable. We all have the password managers and the Camel method we all talk the Breezer language as they used to call it. Passwords like P @Ssw0rd123  are not uncommon. Or we all know the Welcome01 introduction passwords or what about @ppForApplication01. Do you want to check if your password has been Pwned you can check at https://haveibeenpwned.com/passwords . My 10 cents ...

I was asked to look at an Excel sheet that was giving an error stating that an external connection could not be established. Excel online was stating that there was a link in it and so did Excel. That was the easy part, the hard part was finding the external connection and removing it. Excel (desktop) will warn you of any link that cannot be established, and Excel will ask you what to do with the error. You can do a few things (see image below) Edit links options   Everyone would normally choose "break link" and let the problem be fixed, however Excel doesn't allow this. Excel won't state why not or where the reference is but   it won' t remove it either. So how to go about finding this link and removing it? Below I have put my questions I asked myself and the steps I took to see if the link was there. In which worksheet is the problem? The answer to this question is pretty simple, remove the worksheets one by one. Excel shows in the info if there...

Editing meta-data is something you might want to do during the use of a library. However if you adjust meta-data you also adjust the modified date. This you don't want because you don't need people to know that you adjusted something, that's confusing. A great solution for this is using the export to Excel feature in Sharegate to adjust the metadata. First you click on the icon Excel in the top left corner of the tool  Export selection to Excel to export the data into Excel Adjust the meta-data in Excel  Using the Excel button Import the data from Excel Sharegate wil adjust the metadata but not the modify date, very cool feature!

Security is /has been booming for a while now. Everywhere you read about the amount of data being leaked. Now just yester day a  contractor named  Deep Root Analytics put a database online with 198 million potential voters open to download for the public on an Amazon S3 storage server. Well that person will have the worst day of his or her life.  Is this an uncommon thing? Well no, people are leaving data everywhere. We are very sloppy with our or the data of someone else. USB sticks, phone or laptop stolen, e-mails with data, We dump data everywhere and it's scary. In this article I'm going to talk about what my solution would be to prevent any harm being done after a data breach. Methods Let's start by just going through some possible solutions. Not just talking about the data itself but also the identity and the devices that a company uses. Lost or stolen credentials Try using Multi factor authentication (MFA) to enhance the security of the identity. You cou...

So the world of tech is not slowing down at all at this moment. Some very cool stuff has been going on recently. Let's start one by one and talk through what the tech is and what it can do. Everybody get's a blockchain! I think the word blockchain has been shouted out in recent weeks/ months. If it's about the price of bitcoins (currency that runs on a blockchain) going through the ROOF or how Ethereum is taking over the world with it's new blockchain. So what is the blockchain? The video below explains it pretty short and sweet. The possibilities are endless. The easiest ones are removing banks from the process of transactions. But you could also use blockchain to register what steps a product has been through before it reached it's destination. OK, so we got the blockchain covered but what about Ethereum or Ether. Ether was created as a new and improved version of Bitcoin. Ether is not only decentralized money but also a decentralized computer making the po...