Encryption of data at rest in SharePoint Online

A very common question I get is about how secure information is in Office 365. The above video shows you how SharePoint Online data is saved when at rest.

Microsoft do a lot in my books to ensure that data stored in Office 365 is secure as possible and in my books far more secure that most people achieve on premise. That means to me security is a major reason to CHOOSE the cloud over anything on premise.

Security is a journey and not a destination I know but Microsoft have the resources to ensure that the information they maintain is a secure as possible and I’m comfortable with that.

Getting Started with Azure course now available

As I detailed back in January I have now made available my Getting Started with Azure training product. You can find it on my publications page at:

www.ciaops.com/publications

The product is not designed a comprehensive deep dive but as a way for those with little knowledge about Azure to get up and running quickly. The course contains:

– 12 video tutorials

– A 70 page manual that includes material not covered in the videos

– A number of free Azure publications

– Links to other material, documentation and training

and us available for only AU$120

I have pulled together information from many different sources and distilled the essentials of what you need to get started using Azure.

You can download the table of contents that includes a listing of video lessons to see what the product covers. 

This product will continue to be updated over time and your single purchase will provide you will all the updates at no additional cost.

I think this produce will provide the short cut many are looking to understand how they can start using Azure and what it is capable of.

Need to Know podcast–Episode 74

In this episode I’m joined my Melanie Gass, also known as the Microsoft Princess, from Centerpoint Solution to talk about the latest changes in Office 365.

We look at the recent changes in Office 365 and how you can keep up to date. We review the Office 365 plans and then take a deeper dive into some of the new products in the Office 365 suite including Delve and Clutter. For resellers we talk about the Microsoft Partner Network and what resources are available.

If you want to learn about the latest with Office 365 as a customer or reseller, this is a not to miss episode.

You can listen to the episode at:

http://ciaops.podbean.com/e/episode-74-melanie-gass/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Resources

www.centerpointsolution.com

Office 365 roadmap

Office 365 pricing plans

Delve info

Clutter information

Become a Microsoft partner

Learn more about Microsoft Partner Internal Use Rights

Cloud SureStep training for Microsoft Partners

Configuring an Azure SSO portal

In a previous blog post I show how to enable your Office 365 Azure AD. Once you have access to Azure AD you have access to the free version of Azure AD. Amongst other things this allows you to manage user accounts, synchronise with on premises directories and get single sign (SSO) on across Azure, Office 365 and thousands of web based applications.

To set up this SSO portal you will need to login to your Azure AD as an Office 365 global administrator.

image

Select Active Directory from the menu on the left and the name of your Active Directory. That should display a screen like that shown above. From the menu across the top select the Applications option.

image

This will list any pre-configured web apps. If this is the first time here you will probably see that both Office 365 Exchange Online and SharePoint Online have been configured for you.

To add a new application to the SSO portal select the Add button at the bottom of the page.

image

Next, select the option to Add an application from the gallery.

image

You should see that there over 2,400 apps currently that you can select from. The easiest way to locate app you want to integrate into your SSO portal is by using the search features in the top right.

Here, I’m going to integrate Evernote, so I simply select the icon in the middle of the page once I have located it in the list.

image

Different applications have different configuration requirements but in this case with Evernote all I need to now do is assign which users need to access it. I do this by selecting the button Assign users.

image

This should now take you to a list of users (here, my Office 365 users).

Firstly, select the user you wish to assign the app to and then press the Assign button at the bottom of the page.

image

This will now prompt you to enter the app login credentials you wish to have for the user. Enter these and select the check icon in the lower right corner.

image

You should now see that user has a Direct assignment for that app as shown above.

image

To access the SSO portal you need to have users navigate to:

http://myapps.microsoft.com

and because we can connected our Office 365 directory to this SSO they can login using their usual Office 365 credentials but now they will only need to do that to access all their web based applications you have configured for them.

image

Once a user logs into the SSO portal they will see all the apps that you have configured for them. To access any of these they simply click on the icon.

image

In this case, if I click on the Evernote icon I just configured a new tab in my browser will automatically open and I will be automatically logged into the application using the credential entered at the configuration stage.

So that’s the basics of what’s included for free with Office 365, Azure and the single sign in portal. Is there more that you can do? Sure is, but that will have to wait for an upcoming blog post.

Introduction to Lookup Columns in SharePoint

SharePoint has the ability to act as a basic relational database. Thus, you can create one list that if referred to by other lists. This means that you can maintain only a single location for all your information. The most basic method to achieve this is by using Lookup Columns.

This tutorial will show you how to create a lookup column in a new list and then how to work with the information. You’ll see how to add and update information as well as edit the column headings in the new list so they present better.

This video is another in my Intermediate SharePoint series that you can follow through. Of course don’t forget my Getting Started with SharePoint series which you also get via email or download and install on your own SharePoint Team Site. You can subscribe to the free Getting Started with SharePoint lessons by entering your email below.


#mc_embed_signup{background:#fff; clear:left; font:14px helvetica,arial,sans-serif; }
/* Add your own MailChimp form style overrides in your site stylesheet or in this style block.
We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */

Subscribe to free SharePoint training via email

Need to Know podcast–Episode 73

I’m joined by an old friend, MVP Mark O’Shea to talk reseller opportunities in the Microsoft cloud. We especially look at products like Azure and Intune. Mark gives us his experience and knowledge about really getting into Azure and how it can make a real difference to your business and your customers.

Mark spells out how import Azure is becoming and why resellers really need to start looking into what solutions it can provide from them. You’ll also hear more about Intune and role that it can play when coupled with Office 365 and Azure to provide an overall management solution.

You can listen to the episode at:

http://ciaops.podbean.com/e/episode-73-mark-oshea/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Resources

intunedin.net

@intuned

OneDrive for Business now available for MAC

Yes all you Office 365 and Mac fan boys and girls, Microsoft has just announced that SkyDrive for Business sync client for MAC is available on iOS! You can read all the good news here and how you can procure it:

http://blogs.office.com/2015/01/28/onedrive-business-comes-mac-ios-devices/

There is also an Office Mechanics video that shows you all the features.

Demonstrates how OneDrive for Business is really a great cross platform tool for sharing and syncing files.

Connect SharePoint to MS Access

You can consider SharePoint as an extension of the Office applications you have on your desktop. One of these that provides a huge amount of power but gets used infrequently is Microsoft Access.

Many don’t appreciate that you can easily connect a SharePoint list to Microsoft Access on the desktop. Doing so allows you to use SharePoint as the data repository and Access as the analytical front end, allowing to create complex structures and queries as well as producing mind blowing reports and data analysis quickly and easily.

This tutorial will show you the basic steps of connecting SharePoint to your desktop version of Access. You see how that when you do it establishes an bi-directional link that means data is updated no matter where it is changed.

This is only the beginning of what is possible when you combine Access and SharePoint, however it is a very good place to start. Watch out for more content on this topic very soon.