You are here

Feed aggregator

Skype for Business App SDK 紹介

MSDN Blogs - Wed, 05/11/2016 - 23:56

Skype for Business API 開発

こんにちは。

今回は、最近ダウンロード開始された Skype for Business App SDK について、実際の code を使って紹介します。

補足 : ここでは Objective-C を使用しますが、Swift でも書けます。ただし、後述の Helper クラスは Objective-C しかないので、Swift で Helper と同様の処理を頑張って記述する必要があります。

Skype for Business App SDK で可能なこと

以前紹介した Skype Web SDK は Skype for Business REST API (UCWA, User API) を使った JavaScript API (Web 用の API) でしたが、ここで紹介する Skype for Business App SDK は iOS, Android 用の SDK です。

ただし、利用シナリオが限定されているので注意してください。
Skype Web SDK では Skype for Business の一般シナリオである B2B での利用を想定していましたが、この Skype for Business App SDK は B2C での利用を想定しています
Skype for Business を持っていない一般ユーザーが、Skype for Business を持っている裏側のアドバイザー、医者、ヘルプデスクなど (スタッフ) と接続して連携するような使い方で、以前、似たシナリオで Skype URI や Skype Button を使った開発手法を紹介しましたが (「Skype URI で Skype for Business に Call する」を参照)、今回のシナリオでは Skype さえも不要で、iOS や Android で動く一般のアプリに埋め込まれた形で使用できます。(利用者は、それ以外の追加のアプリなどは不要です。)

B2C シナリオの設計(Design)

本投稿では開発に踏み切る方のハードルを上げないよう、以降では極力簡単なサンプルで紹介しますが、実は、この Skype for Business App SDK を使用するには、そこそこちゃんとした設計 (構成) が必要です。

というのは、上述の通り B2C シナリオのため利用者 (User) は匿名で利用しますが、この匿名アクセスを実現するために「Skype Meeting を API (REST, Web) で処理する (Skype for Business)」で紹介した Online Meeting を組み合わせるためです。(組み合わせ方がいろいろ考えられます。)
Skype for Business の Online Meeting では、Skype for Business のライセンスのない匿名ユーザーも会議に参加できますが (会議の設定により、匿名アクセスを拒否したり、ロビーで承認したユーザーのみアクセスさせることなども可能)、Skype for Business App SDK は、この仕組みを使って Skype for Business を持っていない一般ユーザーと Skype for Business を持っているバックエンドのスタッフをつなぎます。(Skype for Business App SDK に Meeting Url を渡すことで、この接続をおこなってくれます。)

From “MSDN – Embed Skype business-to-consumer communications in your mobile app” (Richard Taylor, Microsoft)

さまざまな方法 (シナリオ) が考えられますが、一例を紹介すると、例えば下記のような処理をおこなう一連のアプリ (フロントエンド アプリ、バックエンド アプリ) を提供します。

  1. 顧客からの質問に応答するバックエンド スタッフ (Skype for Business のライセンスを持ったユーザー) は、カスタム アプリ (ISV アプリ) を使って、内部で、「Skype Meeting を API (REST, Web) で処理する (Skype for Business)」で解説した方法で Scheduled Meeting を作成しておきます。(顧客からの問い合わせを待機した状態)
  2. 顧客がモバイル アプリ (スマホ アプリ) を使って問い合わせをおこなうと、アプリのサーバー側では、利用可能なバックエンド スタッフの Scheduled Meeting (上述) を検索して、そのうちの 1 つの Meeting Url をアプリ (スマホ アプリ) に返します。
  3. スマホ アプリ (iOS, Android) は、Skype for Business App SDK を使って、このバックエンド スタッフ (Skype for Business User) と顧客 (Anonymous の Guest User) を接続します。

こうした方法以外に、「Skype Meeting を API (REST, Web) で処理する (Skype for Business)」で解説した Ad-hoc Meeting を使うパターンも考えられます。
認証フローに注意しながら、アプリのニーズに応じて、さまざまな方法で設計できます。

補足 : なお現在、Skype for Business Online (REST) は「Azure AD : Backend Server-Side アプリの開発 (Deamon, Service など)」で解説した方法をサポートしていません。もし将来、この方式がサポートされれば、さらに接続シナリオは増えていくことでしょう。

アプリの構築 – Meeting Url の取得

では、実際に簡単なサンプルを構築してみましょう。
上述の通り、本来なら、サーバー側 (バックエンド) のプログラミングなども必要ですが、サンプルを煩雑にしない目的で、今回は上述の 3 の処理のみをプログラミングします。(1 と 2 は「Skype Meeting を API (REST, Web) で処理する (Skype for Business)」で解説した API で実装されているものと仮定します。)

そこで、このあとのプログラミングのため、あらかじめ Meeting Url を手動で作成して、この Meeting Url を使って、Skype for Business App SDK による Video 接続の iOS アプリ (サンプル) を作成します。
使用する Meeting Url は「Skype Meeting を API (REST, Web) で処理する (Skype for Business)」で解説した Join Url で、「https://meet.lync.com/o365directory/tsmatsuz/3O719UCX」といった形式です。
PC や Mac をお使いの方は、Office 365 の試用版などで Outlook (Web 版の Outlook Web App も可) にログインして Skype 会議 (Skype Meeting) を作成することで、下記の赤の囲みの通り、簡単に Meeting Url が取得できます。

なお、作成された Skype Meeting の既定の設定では、Meeting Url さえ分かっていれば匿名 (Guest) ユーザーで参加可能ですが、Skype Meeting の設定 (管理) 画面でこの権限の確認・変更が可能です。

アプリの構築 – XCode プロジェクトの作成・構成

では、上記で取得した Meeting Url を使って、モバイル アプリを作成してみましょう。

XCode でプロジェクトを新規作成します。(今回は [Single View Project] を作成してみましょう。)

Skype for Business App SDK をダウンロードし、上記で作成した XCode プロジェクトの [Embedded Binary] に、SDK の AppSDKiOS/SkypeForBusiness.framework を追加します。

補足 : BUILD と RUN における SDK 利用の注意点
今回紹介する Video のサンプルは、Mac 上の iOS Simulator では動作 (RUN) しません。必ず、iPhone など実機を接続して動作確認してください。
なお、iOS Simulator で上記の AppSDKiOS/SkypeForBusiness.framework を使用した場合、BUILD も通りません。(“missing required architecture x86_x64″ のエラーが発生します。) もし、開発中、iOS Simulator の構成で BUILD をしたい場合は、一時的に AppSDKiOSSimulator/SkypeForBusiness.framework のほうを使用してください。(上述の通り、動作確認 (RUN) では Simulator は使用できないので注意。)

また今回、SDK に含まれるヘルパークラス (SfBConversationHelper など) を使用するため、Skype for Business App SDK の Helpers/SfBConversationHelper.h、Helpers/SfBConversationHelper.m をプロジェクトのソースに含めておきます。(下図)

さいごに、必要な XCode のフレームワークを追加します。
プロジェクトの [Linked Frameworks and Libraries] を表示して、今回は、AVFoundation.framework と GLKit.framework (このあと GLKitView を使います) を追加します。

アプリの構築 – UI の作成

XCode の Storyboard を使って UI を作成します。
今回のサンプルでは、単に、アプリ起動時に Video 会議に接続して、相手の顔 (Incoming Video) と自分の顔 (Outgoing Video) を表示しますので、ボタン遷移などの Storyboard らしいデザインは不要です。

プロジェクトに含まれる Main.Storyboard で、既定の [View Controller Scene] を表示して、下図の通り、Incoming Video (相手の顔) を表示するための GLKitView (下図の薄い水色の部分) と、その中に Outgoing Video (自分の顔) を表示する UIView (下図の白い部分) を Drag & Drop で挿入します。

このあと、プログラム コード (Objective-C) を使って、この挿入した View や Layout にストリーミングを関連付けることで Video が表示されます。
そこで、あらかじめ、これらの挿入した View を、Control キーを押しながら View のソースコード (ViewController.m) の @interface と @end の間に Drag & Drop して、下記太字の通りサブクラスを作成します。

#import "ViewController.h" #import <GLKit/GLKit.h> @interface ViewController () <SfBConversationHelperDelegate> @property (strong, nonatomic) IBOutlet GLKView *incomingView; @property (strong, nonatomic) IBOutlet UIView *outgoingView; @end @implementation ViewController . . . @end

補足 : 上記ソースコードの通り、GLKit.h のヘッダー参照も追加 (import) しておいてください。

アプリの構築 – プログラミング

以上で準備完了です。
以降は、Skype for Business App SDK を使ってプログラム コードを作成してみましょう。

まず、Skype for Business App SDK を使用するため、前述で挿入したバイナリー (SkypeForBusiness.framework) や挿入したヘルパークラス (SfBConversationHelper) へのヘッダー参照を追加 (import) します。

#import "ViewController.h" #import "SfBConversationHelper.h" #import <GLKit/GLKit.h> #import <SkypeForBusiness/SkypeForBusiness.h> @interface ViewController () <SfBConversationHelperDelegate> . . . @end @implementation ViewController . . . @end

今回は単純に、上述で取得した Meeting Url に匿名 User (Guest User) で接続し、アプリ起動時 (View の表示時) に、上記で挿入した View に Video を表示します。ViewController の表示が完了した段階 (viewDidAppear) でこの処理をおこなうため、下記太字の通りソースコードを追加します。

なお、「https://meet.lync.com/o365directory/tsmatsuz/3O719UCX」は上記であらかじめ取得した Meeting Url で、「Demo Customer」は Meeting に Guest 参加 (Anonymous 参加) した際の参加者の名前です。

#import "ViewController.h" #import "SfBConversationHelper.h" #import <GLKit/GLKit.h> #import <SkypeForBusiness/SkypeForBusiness.h> @interface ViewController () <SfBConversationHelperDelegate> @property (strong, nonatomic) IBOutlet GLKView *incomingView; @property (strong, nonatomic) IBOutlet UIView *outgoingView; @property (strong, nonatomic) SfBConversationHelper *conversationHelper; @end @implementation ViewController - (void)viewDidLoad { [super viewDidLoad]; // Do any additional setup after loading the view, typically from a nib. } - (void)didReceiveMemoryWarning { [super didReceiveMemoryWarning]; // Dispose of any resources that can be recreated. } - (void)viewDidAppear:(BOOL)animated { [self joinMeeting]; } /** * Joins a meeting */ - (void)joinMeeting { NSError *error = nil; NSString *meetingURLString = @"https://meet.lync.com/o365directory/tsmatsuz/3O719UCX"; NSString *meetingDisplayName = @"Demo Customer"; // Join online meeting SfBApplication *sfb = SfBApplication.sharedApplication; SfBConversation *conversation = [sfb joinMeetingAnonymousWithUri:[NSURL URLWithString:meetingURLString] displayName:meetingDisplayName error:&error]; if (conversation) { // Success : Set observer and show video in UI View [conversation addObserver:self forKeyPath:@"canLeave" options:NSKeyValueObservingOptionInitial | NSKeyValueObservingOptionNew context:nil]; _conversationHelper = [[SfBConversationHelper alloc] initWithConversation:conversation delegate:self devicesManager:sfb.devicesManager outgoingVideoView:self.outgoingView incomingVideoLayer:(CAEAGLLayer *) self.incomingView.layer userInfo:@"Demo Customer"]; } else { // Fail : Show error details UIAlertController *alertController = [UIAlertController alertControllerWithTitle:@"Error" message:error.localizedDescription preferredStyle:UIAlertControllerStyleAlert]; [alertController addAction:[UIAlertAction actionWithTitle:@"Close" style:UIAlertActionStyleCancel handler:nil]]; [self presentViewController:alertController animated:YES completion:nil]; } } @end

今回は Video の処理のため、Video の状態通知の際に呼ばれる、下記の 3 つの Callback Listener も実装します。

#import "ViewController.h" #import "SfBConversationHelper.h" #import <GLKit/GLKit.h> #import <SkypeForBusiness/SkypeForBusiness.h> @interface ViewController () <SfBConversationHelperDelegate> @property (strong, nonatomic) IBOutlet GLKView *incomingView; @property (strong, nonatomic) IBOutlet UIView *outgoingView; @property (strong, nonatomic) SfBConversationHelper *conversationHelper; @end @implementation ViewController - (void)viewDidLoad { [super viewDidLoad]; // Do any additional setup after loading the view, typically from a nib. } - (void)didReceiveMemoryWarning { [super didReceiveMemoryWarning]; // Dispose of any resources that can be recreated. } - (void)viewDidAppear:(BOOL)animated { [self joinMeeting]; } /** * Joins a meeting */ - (void)joinMeeting { . . . } /** * Callback listner */ - (void)conversationHelper:(SfBConversationHelper *)avHelper didSubscribeToVideo:(SfBParticipantVideo *)video { // Do some task at incoming video } - (void)conversationHelper:(SfBConversationHelper *)avHelper videoService:(SfBVideoService *)videoService didChangeCanStart:(BOOL)canStart { // When video service is ready to start, start the service. if (canStart) { [videoService start:nil]; } } - (void)conversationHelper:(SfBConversationHelper *)avHelper selfAudio:(SfBParticipantAudio *)audio didChangeIsMuted:(BOOL)isMuted { // When the audio status changes, do some task (ex. change mute/unmute button) if (!isMuted) { // Do some task } else { // Do some task } } @end

さいごに、今回、canLeave プロパティの observe もおこなうようにしたので (上記コード参照)、その Handler も追加しておきます。

#import "ViewController.h" #import "SfBConversationHelper.h" #import <GLKit/GLKit.h> #import <SkypeForBusiness/SkypeForBusiness.h> @interface ViewController () <SfBConversationHelperDelegate> @property (strong, nonatomic) IBOutlet GLKView *incomingView; @property (strong, nonatomic) IBOutlet UIView *outgoingView; @property (strong, nonatomic) SfBConversationHelper *conversationHelper; @end @implementation ViewController - (void)viewDidLoad { [super viewDidLoad]; // Do any additional setup after loading the view, typically from a nib. } - (void)didReceiveMemoryWarning { [super didReceiveMemoryWarning]; // Dispose of any resources that can be recreated. } - (void)viewDidAppear:(BOOL)animated { [self joinMeeting]; } /** * Joins a meeting */ . . . /** * Callback listner */ . . . /** * Monitor canLeave property of a conversation (Handler) */ - (void)observeValueForKeyPath:(NSString *)keyPath ofObject:(id)object change:(NSDictionary<NSString *,id> *)change context:(void *)context { if ([keyPath isEqualToString:@"canLeave"]) { // Do some task } } @end

今回は実装しませんが、もちろん、Video の Mute / Unmute や、会話の終了などの基本的な操作も可能です。

// Leave from conversation NSError *error = nil; [_conversationHelper.conversation leave:&error]; // Toggle Mute/Unmute audio [_conversationHelper toggleAudioMuted:nil];

以上で完成です。
実行結果は説明不要と思いますが、アプリを起動すると Online Meeting に Anonymous (Guest) で参加されて、下図の通り表示されます。(本田さんにご協力いただきました。。。) なお、上述の通り、Mac 上の Simulator ではなく、実機で動作を確認する必要があるので注意してください。

さいごに、今回作成したソースコード全体を掲載しておきます。今回は Objective-C ですが、Swift で記述した場合、上述の通り、Helper が使用できないため、もっと長くなります。

#import "ViewController.h" #import "SfBConversationHelper.h" #import <GLKit/GLKit.h> #import <SkypeForBusiness/SkypeForBusiness.h> @interface ViewController () <SfBConversationHelperDelegate> @property (strong, nonatomic) IBOutlet GLKView *incomingView; @property (strong, nonatomic) IBOutlet UIView *outgoingView; @property (strong, nonatomic) SfBConversationHelper *conversationHelper; @end @implementation ViewController - (void)viewDidLoad { [super viewDidLoad]; // Do any additional setup after loading the view, typically from a nib. } - (void)didReceiveMemoryWarning { [super didReceiveMemoryWarning]; // Dispose of any resources that can be recreated. } - (void)viewDidAppear:(BOOL)animated { [self joinMeeting]; } /** * Joins a meeting */ - (void)joinMeeting { NSError *error = nil; NSString *meetingURLString = @"https://meet.lync.com/o365directory/tsmatsuz/3O719UCX"; NSString *meetingDisplayName = @"Demo Customer"; // Join online meeting SfBApplication *sfb = SfBApplication.sharedApplication; SfBConversation *conversation = [sfb joinMeetingAnonymousWithUri:[NSURL URLWithString:meetingURLString] displayName:meetingDisplayName error:&error]; if (conversation) { // Success : Set observer and show video in UI View [conversation addObserver:self forKeyPath:@"canLeave" options:NSKeyValueObservingOptionInitial | NSKeyValueObservingOptionNew context:nil]; _conversationHelper = [[SfBConversationHelper alloc] initWithConversation:conversation delegate:self devicesManager:sfb.devicesManager outgoingVideoView:self.outgoingView incomingVideoLayer:(CAEAGLLayer *) self.incomingView.layer userInfo:@"Demo Customer"]; } else { // Fail : Show error details UIAlertController *alertController = [UIAlertController alertControllerWithTitle:@"Error" message:error.localizedDescription preferredStyle:UIAlertControllerStyleAlert]; [alertController addAction:[UIAlertAction actionWithTitle:@"Close" style:UIAlertActionStyleCancel handler:nil]]; [self presentViewController:alertController animated:YES completion:nil]; } } /** * Callback listner */ - (void)conversationHelper:(SfBConversationHelper *)avHelper didSubscribeToVideo:(SfBParticipantVideo *)video { // Do some task at incoming video //self.incomingView.hidden = NO; } - (void)conversationHelper:(SfBConversationHelper *)avHelper videoService:(SfBVideoService *)videoService didChangeCanStart:(BOOL)canStart { // When video service is ready to start, start the service. if (canStart) { //if (self.outgoingView.hidden) { // self.outgoingView.hidden = NO; //} [videoService start:nil]; } } - (void)conversationHelper:(SfBConversationHelper *)avHelper selfAudio:(SfBParticipantAudio *)audio didChangeIsMuted:(BOOL)isMuted { // When the audio status changes, do some task (ex. change mute/unmute button) if (!isMuted) { // Do some task // [self.muteButton setTitle:@"Unmute" forState:UIControlStateNormal]; } else { // Do some task // [self.muteButton setTitle:@"Mute" forState:UIControlStateNormal]; } } /** * Monitor canLeave property of a conversation (Handler) */ - (void)observeValueForKeyPath:(NSString *)keyPath ofObject:(id)object change:(NSDictionary<NSString *,id> *)change context:(void *)context { if ([keyPath isEqualToString:@"canLeave"]) { // Do some task //self.endCallButton.enabled = _conversationHelper.conversation.canLeave; } } @end

New tool for helping resolve Office 365 issues

MS Access Blog - Wed, 05/11/2016 - 09:00

Office 365 is an extremely reliable service, with service availability that typically exceeds 99.9 percent. So if an occasional issue occurs with, for example, getting your email, you may not know where the difficulty lies. Is it your network connection? Has your colleague inadvertently removed your access to that shared mailbox? In these situations, wouldn’t it be nice if you had an automated assistant to help you troubleshoot—and resolve—the problem? Now, there is!

The Support and Recovery Assistant for Office 365 is an easy-to-use app that asks you some simple questions, tests for some of the most common Office 365 support issues and attempts to implement resolutions on your behalf. While the current version is focused on some the more common scenarios people encounter with Outlook, the Support and Recovery Assistant will gain new troubleshooting and resolution capabilities in the future. The Support and Recovery Assistant is built to automatically update itself as these new capabilities become available.

Getting the Support and Recovery Assistant

You can install the Support and Recovery Assistant by visiting diagnostics.outlook.com. Note that you’ll need to have administrator rights to install software on your computer.

Helping to grow and improve the Support and Recovery Assistant

As the last step in using this tool, you are asked to let us know if the Support and Recovery Assistant was able to resolve the problem, assign a rating to your experience and provide any feedback for how the tool could be improved. We carefully review these submissions and use this information to help prioritize new ways that the Support and Recovery Assistant can help find and fix issues.

For more information about the tool, please visit Fix Outlook account problems in Office 365 and watch the video and see some sample images from the app.

We encourage you to install the Support and Recovery Assistant, so that if you do run into an issue, your automated assistant is ready to help!

The post New tool for helping resolve Office 365 issues appeared first on Office Blogs.

Smithfield Foods: many brands, a single mission

MS Access Blog - Wed, 05/11/2016 - 09:00

Today’s post was written by Mansour Zadeh, retiring senior vice president and global chief information officer and current senior advisor to Smithfield Foods.

Smithfield Foods is known for responsible operations, transparency and innovation. As the world’s largest pork producer, we strive for excellence in every facet of our business. But with so many employees operating in so many locations around the world, it can be tough for everyone to be on the same page.

Our aim is to operate holistically as “One Smithfield,” and we’re making progress toward that objective. When I joined the company in 2001, we had more than 20 operating companies worldwide, all with different business processes and technology systems to support them. Those operating companies were doing fine on their own, but we weren’t running efficiently as a comprehensive organization. We needed to take advantage of economies of scale and provide all our employees with the same capabilities so that they could work together more successfully.

To operate as one, we needed modern technology across the whole company, with a focus on communication. With so many divisions and operating companies, even straightforward tasks like coordinating meetings, schedules and distribution lists were difficult. Beyond those fundamentals, we also didn’t have the luxury of videoconferencing and other features that would help support teamwork. We have a powerful corporate brand, and we needed our internal operations to unify and better reflect that brand as an effective global enterprise.

When cloud computing emerged onto the technology scene, we recognized all the benefits it offered a multinational company like ours. We immediately embraced the cloud and started to use Google tools for communication and collaboration. But when it came time to make an enterprise decision about our long-term cloud technology platform, we chose to adopt Microsoft Office 365. We saw that Microsoft had more experience with enterprise needs, such as governance and account relationships, and a clear technology path for the future. We also felt as though Office 365 fit into our environment better and that adopting it would be an easier transition for the bulk of our user community. Plus, Microsoft provided us with a greater value from our investment and showed us its commitment to a strong partnership.

In the past, I didn’t believe that Microsoft was an innovative company, but Office 365 has certainly changed my impression. I’ve been surprised by the level of ingenuity and the pace of change that I’ve seen with Microsoft. Improvements in the video call quality and flexibility of Skype for Business Online, the rich features in Microsoft SharePoint Online, the addition of mobile device management capabilities—there’s so much to benefit from. We’re expanding our use of Office 365 worldwide and even going beyond that suite of capabilities to adopt Microsoft Azure for various workloads. Our plan is to move as much to the Microsoft cloud as possible so we have flexibility in scaling our computing and storage needs, and can ultimately deliver on our core competencies: improving the quality of our business data and making it easily and securely accessible to our people.

Best of all, we now have technology that supports our employees’ ability to work closely together, no matter where they are around the world or what device they’re using. With so many integrated communications and collaboration capabilities at our disposal, we’re steadily breaking down the silos that hampered teamwork, and we’re confident that we’ll soon realize our goal of One Smithfield.

Read the case study to learn more about how this global food producer became One Smithfield with the help of Office 365.

The post Smithfield Foods: many brands, a single mission appeared first on Office Blogs.

May Office 365 security and compliance update

MS Access Blog - Wed, 05/11/2016 - 09:00

Over the last month, the Office 365 team has continued to introduce new security features and capabilities while gaining accreditation around the world for upholding the highest standards in cloud security.

Below is a roundup of some key news items from the last several weeks.

Email Safety Tips in Office 365—Today’s spam and malware attacks are sometimes so well crafted they may look like legitimate emails to your users. Putting messages into the Junk Email folder isn’t enough. Over the coming weeks, we are rolling out Safety Tips in Exchange Online Protection, which provides a warning to the user in an email that is marked suspicious or a reassurance when a message is safe.

New regions and capabilities available for Office 365 Import Service—The Office 365 Import Service is now generally available and has expanded to new regions with additional capabilities that make it even easier to import data into Office 365.

Automate time-consuming eDiscovery search tasks—Quickly creating and reporting discovery searches is often an important step in eDiscovery and investigations when you’re trying to learn about the underlying data and the richness and quality of your searches. To help you do this, the Office 365 Security and Compliance Center offers a set of Windows PowerShell cmdlets to automate time-consuming Content Search tasks.

Yammer attains advanced Office 365 compliance—Recently, we announced that Yammer has achieved a series of industry-leading security and compliance standards, including ISO 27001 and SSAE 16. These independent compliance reports are now available to customers at the Office 365 Service Trust Portal, so customers can easily perform their own regulatory risk assessments. To learn more about industry standards and regulations that Office 365 supports, view the Office 365 Compliance Framework.

How Microsoft monitors and protects sensitive data in Office 365—Microsoft IT recently released a case study on how it leverages the data loss prevention solution in Office 365 to help reduce the risk of sharing sensitive data while still promoting collaboration.

Office 365 now accredited for Cloud Security Gold Mark in Japan—The Cloud Security Mark (CS Mark) is the first security standard for cloud service providers (CSPs) in Japan and is based on ISO/IEC 27017, the international code of practice for information security controls. The CS Mark helps customers verify operational transparency and visibility into Office 365’s information security controls and address common concerns around security and confidentiality of data. The CS Mark is accredited by the Japan Information Security Audit Association (JASA). JASA developed the Authorized Information Security Audit System (AISAS), which specifies the audit of approximately 1,500 controls covering such areas as organization for information, physical and development security; the security of human resources; and business continuity, disaster recovery and incident management. After rigorous assessments by a JASA-certified auditor, Office 365 is one of the first cloud service providers that has received the CS Gold Mark.

Office 365 along with Azure is first hyperscale cloud service provider to receive Spain’s National Security Framework—The framework establishes core policies and mandatory requirements that government agencies must meet, as well as require, for its service providers. It defines a set of specific security controls for different classifications of security—availability, authenticity, integrity, confidentiality and traceability. Microsoft Azure and Microsoft Office 365 have gone through a rigorous assessment by BDO, an independent auditor, which issued an official statement of their compliance. BDO reports that the security measures in both services, as well as their information systems and data processing facilities, comply at the high level with Royal Decree 3/2010 (which forms the basis of National Security Framework for Spain) without requiring any corrective measures.

Can a shift to the cloud improve your security posture?

As many of our customers are now discovering, keeping up with changes to the security landscape is one of the unique advantages of the cloud. In fact, there are a number of properties that make the cloud inherently different versus managing your own IT services. These go well beyond security, but have important security implications and benefits.

Watch this video for a look at security in the cloud:

The post May Office 365 security and compliance update appeared first on Office Blogs.

New editor coming to Outlook 2016 for Mac

MS Access Blog - Wed, 05/11/2016 - 09:00

Welcome to the new editor in Outlook 2016 for Mac. Enhanced formatting support has been one of the most frequently requested improvements in Outlook 2016 for Mac. Today, we are laying the foundation with the new editor and will continue to build on this work in future updates, including support for Tables.

Let’s take a look at some of the key improvements.

Resize and format pictures

When you insert a picture in an email message, you’ll notice the new resize and rotation handles. You can use these to resize or rotate the image on the canvas. You can also pull up the context menu and select the Size and Position… option to manually set the size in the dialog, as shown below. Double-click an image in the editor to open up the full task pane with image editing controls.

Rich formatting support

With the new editor in Outlook 2016 for Mac, you now have access to a richer set of fonts, font colors and bullet and numbered lists—plus enhanced font editing and hyperlink dialogs. These are available on the ribbon by using the familiar controls in the Message tab or using the menus for Calendar, Contacts, Tasks, Notes and Signatures.

These features will roll out in mid-May. You can also sign up for Office Insiders program to get early access to new Office innovations. Please read “Format email messages in Outlook 2016 for Mac” to learn more on how to use these features.

What’s next?

We will continue to refine the new editor in upcoming releases. This includes adding support for Tables. If you have additional requests for specific functionality, please suggest or vote at our UserVoice forum.

—The Outlook team

 

The post New editor coming to Outlook 2016 for Mac appeared first on Office Blogs.

Office 365 datacenters now available in Canada

MS Access Blog - Tue, 05/10/2016 - 10:00

Following up from our announcements of new datacenter regions in Japan, Australia and India over the last 18 months, today we are announcing the general availability of a new Office 365 datacenter region in Canada. The new datacenter region adds in-country data residency, failover and disaster recovery for core customer data at rest to customers in Canada. Canadian customers continue to have access to the full breadth of productivity and collaboration services available in Office 365 today.

This announcement strengthens our commitment to making Office 365 the most trusted cloud service for productivity by delivering security, compliance and control to Office 365 customers around the globe. Our new datacenter region is comprised of two geographically distributed datacenters located in Toronto and Quebec City. Providing data residency for customers in Canada will accelerate the growth and potential of Canadian industries and public sector organizations by providing more opportunities to innovate, collaborate and flourish in our increasingly mobile world by using the power of the Microsoft cloud. Both Office 365 and Microsoft Azure customers in Canada can now benefit from enterprise-grade reliability and performance combined with in-country data residency, including data replication within Canada. For details, read “Accelerating the Canadian Cloud.”

Office 365 continues to take a comprehensive approach to compliance, achieving industry standards such as ISO 27001, ISO 27018, SOC 1 and SOC 2 reports, which provide the gold standard in security to government agencies, education and other commercial enterprises. To learn more about security and compliance in Office 365, please visit the Office 365 Trust Center.

All involved in Office 365 and Microsoft Azure are elated to provide these technologies locally to continue to help Canadian businesses and administrations be globally competitive.

—Rajesh Jha, corporate vice president for the Office 365 team

The post Office 365 datacenters now available in Canada appeared first on Office Blogs.

Microsoft FastTrack team helps airline soar to the cloud in 8 weeks

MS Access Blog - Tue, 05/10/2016 - 09:00

Today’s blog post was written by Matina Massa, chief information officer of Air Malta, one of Europe’s busiest regional airlines.

Air Malta is a full-service regional airline based on the island of Malta, which lies south of Sicily and midway between Italy and North Africa in the heart of the Mediterranean Sea. With regularly scheduled flights to many destinations in Europe and the Middle East, our airline is of vital importance to the island economy, providing transportation for about 50 percent of the millions of tourists, business travelers and local residents who fly in and out of Malta each year.

Air Malta is one of many European airlines currently going through a restructuring program, in an effort to bring it back to profitability. Part of my mandate as CIO is to dramatically reduce our IT operational costs while improving communication, collaboration and productivity for our widespread and increasingly mobile workforce of almost 1,000 employees. That’s what triggered our move to Office 365.

As we prepared to deploy Office 365, we had a very tight exit plan with the existing service provider for Microsoft Exchange. We didn’t have the luxury of a staged migration—we had to move fast. When I met with Microsoft to sign the contract, I said, “Look, this is my challenge: I need to migrate all of our Office 365 and Exchange Online services within the next eight weeks.” With millions of euros at risk, plus the need to keep our airline operating smoothly, failure wasn’t an option. That’s when I learned about Microsoft FastTrack.*

The FastTrack team supported us during every phase of the process—from planning, assessment and onboarding through remediation and migration. It’s a straightforward process that has been proven by the experience of thousands of Microsoft customers. The FastTrack team guided us through every step, helped us stay focused on the essential issues and provided the information and support we needed to be successful.

In some ways this was a complicated project, because it involved four teams from four different companies. We had the Air Malta and FastTrack teams in addition to our day-to-day service provider and a consultant here on the island that provided additional support and coaching when we needed it. Due in large part to the leadership and expertise of the FastTrack engineers, the team jelled within two weeks of starting the project and worked together extremely well. The FastTrack team was always there to help and support us. They dedicated a lot of time to coaching us on implementation and user adoption, and bringing us along the learning curve as fast as possible.

Air Malta has always relied on Microsoft technology, but due to the restructuring, the company had not made any significant investments in information technology during the previous six years. We were still running Microsoft Office 2007, and we had not taken advantage of newer technologies such as OneDrive and Skype for Business. So one of our goals was to drive a greater level of integration to improve service and reduce costs.

In the end, we achieved our goals. By switching to Office 365, we reduced our costs for email and productivity services by 70 percent. We also gained greater operational stability with the robust and resilient infrastructure that Microsoft cloud services provide. By using Office 365, we now have a platform to improve collaboration across our organization, and we have the tools to fully support mobility. That’s a big benefit to our flight crews, which are fully automated and carry tablets, and our commercial sales teams that are always on the move. We’re also in a better place in terms of security, because we are leveraging the enhanced security features of Microsoft cloud services.

Working with the FastTrack team turned out to be essential for Air Malta. It was an extremely positive experience, and it resulted in a successful project that was delivered completely on time, on budget and flawlessly from a service perspective, despite a very aggressive timeline and a virtual team that spanned four companies and several countries. Ultimately, however, the greatest benefit of working with the FastTrack team was peace of mind, knowing that we had the full support of a team with both the expertise and the technical muscle to help us get the job done right.

To learn more about FastTrack, visit FastTrack.microsoft.com and become familiar with what our customer-success service has to offer.

For more information about Air Malta, visit www.airmalta.com.

*FastTrack is available to customers with 50 seats and above with eligible plans, including Enterprise, Government, Nonprofit and Business plans. Refer to FastTrack Center Benefit for Office 365 for eligibility details.

The post Microsoft FastTrack team helps airline soar to the cloud in 8 weeks appeared first on Office Blogs.

Connecting with teachers and students through our new “Meet the Microsofties” program

MS Access Blog - Tue, 05/10/2016 - 09:00

Today’s post was written by Eran Megiddo, corporate vice president of the Education, OneNote and Wunderlist engineering teams.

At Microsoft, we’re all in on education. Our mission is to empower every student on the planet to achieve more. We work hard every day to achieve this goal by creating innovations like OneNote, Sway, Skype, Minecraft and Microsoft Classroom, to make teachers’ lives easier and deliver the tools for success into students’ hands. We aim to be completely customer obsessed because listening to student and teacher voices on what they need in the classroom is the only way for us to empower them.

Meet the Microsofties

Today, we are announcing a new community effort that will help connect Microsoft employees to students and teachers from classrooms around the world. We call this effort Meet the Microsofties. Using our Skype in the Classroom program through the Microsoft Educator Community, your students’ voices can shape the future of Microsoft technology for the classroom. Over Skype, connect with the teams that build the tools you use every day. Tell them how you use our technology right now, what you like and don’t like and what features you dream about. This is also a great opportunity for your students to learn about the importance of STEM and hear firsthand what a career in tech looks like.

Skype call to a classroom in Pakistan.

South Korean students connecting with Anthony Salcito, VP of Microsoft Worldwide Education, over Skype during the Skype-a-Thon this December.

5 easy steps to meet your Microsoftie

  1. Determine which Microsoft group your classroom would like to connect with over Skype. We have an initial kickoff list of teams and products, but this will be expanding every day.
  2. Have the teacher register at the Microsoft Educator Community. If already registered, then just sign in.
  3. Head over to the Meet the Microsofties area of the Skype Classroom area of our community and find a team you like—as an example, here is the Sway team’s landing page.
  4. Find a time and date on the calendar and submit it.
  5. The Microsoft team will get back to you, and you can set up the Skype call from there.

Your Skype call with the Microsoftie

Typically, we expect your call to last 20–30 minutes. The Microsoftie will be interested in hearing product feedback from your classroom: what do students like about the technology and what do they not like? How might the product be improved? We hope to gather feedback from classrooms all around the world and improve our software based on what you and your students think is important. In addition to product feedback, your students might have other questions to ask, and we’re happy to answer. Ask the Microsofties anything, from what it’s like to work in STEM, career path or just their opinion on recent technology news.

By learning from classrooms around the world over Skype, we hope to be able to build the solutions that will empower every student on the planet to achieve more.

The post Connecting with teachers and students through our new “Meet the Microsofties” program appeared first on Office Blogs.

OneNote has revolutionized the way we work in our school!

MS Access Blog - Tue, 05/10/2016 - 09:00

Today’s post was written by Kristy Griffin, computing coordinator and a Microsoft Innovative Educator at the Bolsover C of E Junior School.

With the introduction of OneNote to our schools, in less than a year, we have transformed our pedagogy and the way we teach and learn. With this we have become a staff of “OneNote Avengers,” redefining our students’ learning and bringing a whole new approach to the way in which we work and teach in school. Driven by the passion of our executive head teacher, Rowena Herbert, along with heads of school, Paula Lowry and Claire Bailey, we have changed the dynamics of our teaching and totally revamped our school into a 21st-century “OneNote school,” which enhances teaching and learning through the use of Microsoft technologies.

Our journey began when our leadership team introduced the use of OneNote as a way for us to collaborate across our two schools and share our notes from meetings. Quickly we realized the impact and power this tool could have not only from a staff perspective but also for our students. Following on from this we took the plunge to sign up all students and staff to Office 365 and so began our Microsoft expedition, on which we would embark to totally renovate the culture of our schools. The Staff OneNote Notebook took the lead as we began by moving previously bulky files into the OneNote world, allowing instant ease of access anywhere, any place and any time. We invested time within professional development and shared the benefits and ease of moving previously paper-based monitoring into the digital world, cutting staff workload and opening up better opportunities for collaboration and sharing.

We now, as a staff, use OneNote for all of our admin-based needs within school, including staff handbooks, coordinator files, sharing of timetables, data monitoring, intervention tracking and much more.

As a staff, we quickly saw the benefits of having this simple and easy way to share important information and make the day-to-day environment across two busy schools more effective and conducive to sharing and collaborating. All of our teacher assistants at our school also use OneNote to track the intervention work they do with students and can easily share this information with various class teachers.

Most recently, staff started using OneNote to share planning across classes and year groups and to organize resources all in one place, accessible by all in the team. With the implementation of these changes there have been challenges; however, by creating a shared vision for all staff, we have invested time and support in ensuring the process of change ran smoothly. One year in and we don’t miss the days of stacks of files and limited means of communication—the power of OneNote is simply amazing!

Aside from the transformations OneNote has created for the way we work as staff, the most revolutionary and important change has been within the classroom. All teachers have their own OneNote Class Notebooks for their classes, where they can adapt the resources to the individual needs of the class or student. This gives students one-to-one access to their learning resources on their devices, giving them ownership over their own learning. Each student has access to a Content Library, which can be used to access handouts and as a textbook. The Collaboration Space allows students to share and collaborate on a topic and, finally, a named book that allows them to ink or type digitally onto OneNote to complete their work. Now, in both our schools, not a day passes where OneNote doesn’t enhance learning within a lesson and give students instant access to a variety of lesson resources digitally.

With the introduction of the new Class Notebook add-in, books can now be managed with ease, saving time and allowing pages and sections to be distributed with the click of a button. Not to mention, teachers can more efficiently and quickly review students’ work and give individual feedback allow collaboration and discussion with students. This has made the use of Class Notebook even more effective and easy to use for all our staff. Not to mention, through cross notebook distribution we can easily distribute pages from a shared staff planning book to students’ individual notebooks. With these new tools, it will make our move to using OneNote with younger students in our Nursery and Primary schools even smoother.

OneNote is making our vision of having “anytime, anywhere and any device” learning for our pupils a reality. It is cutting the workload of our teaching staff, reducing school costs as we move to becoming paperless and engaging our students within their learning. To make this journey a success, we have changed the culture and mindset of our schools. Moreover, the improvements in teaching and learning have made this investment in change even more rewarding. We now have a school of OneNote converts and are excited for what our future holds as we continue to develop and find new ways of utilizing Microsoft tools within our classrooms, including Office Mix, Sway, Skype and Yammer. We call ourselves a “OneNote school” as that is what we aspire to be. We use OneNote every day and the impact it has upon teaching and learning is astounding. We will continue to use OneNote daily across all age groups and know that with the constant support and updates from the Microsoft OneNote team it will continue to provide new opportunities in which our teachers can enhance teaching and learning and transform their pedagogy. I urge you, if you’ve yet to explore OneNote in your school or classroom, then do it now—you will certainly have no regrets and will be amazed at the endless possibilities this will create for your staff and students. Our journey may have begun with OneNote, but the opportunities this opened up for us as a school and for our students will take us much further, and we are excited about what the future may hold.

—Kristy Griffin

The post OneNote has revolutionized the way we work in our school! appeared first on Office Blogs.

What’s new: April 2016

MS Access Blog - Tue, 05/10/2016 - 09:00

Collaboration got a big boost this month with the initial release of the Skype for Business for Mac Preview, sharing and messaging updates to the Office 2016 desktop client, the ability to create external Yammer groups and more. So did mobility, with the new Calendar Apps for Outlook on iOS and Android, new Project Portfolio Dashboard apps, and support for mobile application management (MAM) and conditional access capabilities for Skype for Business mobile apps. Plus, a new home page is rolling out to all Office 365 users, Safety Tips for email are here, FastTrack is expanding, and Get &Transform in Excel 2016 and the Power Query add-in for Excel got a host of updates. For teachers, the OneNote Class Notebook add-in now includes LMS assignment and grade integration. And for developers, there are presentations on Office add-ins, 2016 Build, and authentication, Angular 2 and Cordova.

Leave us a comment to let us know what your favorite new feature is. If you missed last month’s updates, see What’s new: March 2016.

Office 365 Personal, Office 365 Home and Office 365 University updates

Introducing Wunderlist, Facebook and Evernote in Outlook on iOS and Android—Get a far better view of your day, week and months ahead with the newly launched  Calendar Apps for Outlook on iOS and Android. With Calendar Apps, you can connect your apps—Wunderlist, Facebook and Evernote to start with—to see all your tasks, events and notes from your digital life in one place: your Outlook calendar.

Outlook on the web makes going on vacations less stressful—Outlook on the web now makes it easier to head out for time away from the office. When you set an automatic reply in Outlook on the web, Outlook offers to: block your calendar so people know you’re away, clear existing meetings on your calendar by declining/canceling them, automatically send a response to incoming invitations while you’re away. These options are rolling out to Office 365 users of Outlook on the web and users of the new Outlook.com.

Add videos, choose your viewing experience and tell your story in more languages on Sway—With the newest features, you can create engaging Sways even more easily. You can now add videos stored in OneDrive, OneDrive for Business, YouTube and even your device to Sway. You can choose the way you view a Sway—horizontally, vertically or in the familiar mode. And Sway is now available in 14 more languages.

New to Office 365—Skype for Business Mac Preview, bringing collaboration to the forefront in Office and more—The Skype for Business Mac Preview has begun rolling out, with public availability planned for the third quarter of 2016. Updates to the Office 2016 desktop client enhance collaboration, with new core sharing capabilities, a new document activity feed, presence information and Skype for Business instant messaging available at a glance in documents you’re sharing. You can also now create external Yammer groups, and collaborate more easily with the editing, recording, inking and other improvements in Office Mobile apps on Windows Phone, iOS and Android.

OneNote and Office Lens updates—In OneNote, you can now insert and view content from YouTube, Vimeo, Vine, Sway and more, right alongside your notes. Updates to the work and school sign-in process in OneNote for Windows let you now sign in to OneNote for the first time using your Office 365 organization ID. Audio recording was added to OneNote for the Windows Phone. New features in OneNote on iOS make it easier to organize notes on the canvas, and Smart Lookup is now available in OneNote Online. Check out the new features of Office Lens, the popular pocket scanner, too.

Office 365 for Business and Education updates*

Take back your time with Delve Analytics—Get a deeper look at Delve Analytics, the Office 365 capability that delivers insights about how you work, helping you work smarter, not harder. Watch the video and read about your Delve Analytics personal dashboard for work, which gives you a summary of how much time you’ve spent in the current week in meetings, on email, in focused work time and working after hours. You can watch a Microsoft Mechanics show to learn about the future of Delve Analytics too.

Get & Transform in Excel 2016 and the Power Query add-in updates—Excel 2016 includes a new set of features that provides fast, easy data gathering and shaping capabilities and can be accessed through Get & Transform on the Data ribbon. Updates include two new or improved data connectivity features: ODBC Connector, support for selecting User/System DSNs; and CSV Connector, the ability to specify Column Delimiter in the Source dialog. These updates are available to Office 365 subscribers. If you have Excel 2010 or Excel 2013, you can get the updates by downloading the latest Power Query for Excel add-in.

New usage reports for SharePoint, OneDrive, Yammer and Skype available—New usage reports for SharePoint, OneDrive for Business, Yammer and Skype for Business are rolling out now. Along with the new reporting dashboard in the Office 365 admin center, the new usage reports make it easy to monitor your service and identify issues and opportunities. They also give you metrics to use in reporting to management. And they provide both aggregate and user-level information, so you can effectively plan training and communication that helps your users take full advantage of Office 365.

Office 365 security and compliance updates—Customer Lockbox is rolling out to SharePoint Online and OneDrive for Business. Office 365 third-party archiving is now available, and you can now reduce eDiscovery costs and challenges with Office 365 Advanced eDiscovery, which helps you investigate and meet legal obligations even more quickly. New security management capabilities are coming to Office 365 with Microsoft Cloud App Security, a comprehensive cloud access security broker (CASB) solution that will also power new advanced security management capabilities for Office 365 to improve IT visibility and control.

Office 365 administration updates—Improvements to the new Office 365 admin center make it faster, easier and more efficient to manage the service. The latest updates include expanded search, a new tile on the dashboard that makes it easy to see the status of your Directory Synchronization (DirSync), new usage reports and additional user list management functionality. With the new features added to the Office 365 admin mobile app, you can now protect your organization’s email, manage license count, manage groups, conference rooms, equipment and shared mailboxes and more.

Email Safety Tips in Office 365—Safety Tips are rolling out in Exchange Online Protection, an additional layer of protection that provides a warning to the user. The Safety Tips are displayed at the top of the email in one of four color-coded categories: Suspicious, Unknown, Trusted or Safe. All four types are included in Outlook on the web; in Outlook clients, desktop and mobile, only the Suspicious safety tip is displayed.

Announcing content viewing for Skype for Business on Android and updates to iOS—You can now view a presenter’s desktop and applications shared in a meeting on your Skype for Business app for Android, and content viewing on the Skype for Business app for iOS has been greatly improved.  iOS and Android users who have Enterprise Voice enabled now have the option to easily switch the meeting to your cellular line in case of weak Wi-Fi or data connection, so you can always stay connected to your meeting.

OneDrive for Business recognized as an EFSS leader and continues momentum with spring updates—OneDrive for Business was recently named a Leader by Forrester Research in “The Forrester Wave™: Enterprise File Sync and Share Platforms, Cloud Solutions, Q1 2016.” Not resting on its laurels, the OneDrive for Business team has added improvements and new capabilities in the sync, browser and mobile experiences, as well as new IT controls for administrators. Watch the video in the post for an overview of the updates.

Introducing a new home page experience for Office 365 users—A new, more intuitive home page experience is rolling out, providing more consistent and unified experiences for work, education and home users across every device and new features for administrators and users. The new home page experience includes a simplified, responsive design, tool tips that highlight new and unused features and easier installation of Office. Check it out.

Updates for the OneNote Class Notebook add-in, including LMS assignment and grade integration—Teachers can now create and grade assignments in their Class Notebook that show up in their Learning Management System (LMS) or the new Microsoft Classroom. Learn how to connect OneNote and your Class Notebook to your Learning Management System (LMS), create assignments and push grades from OneNote to LMS. To see these and other new improvements working together, watch an Office Mix by a teacher.

Announcing new experiences for teachers and students in Office 365 Education—New experiences and updates are coming in the U.S. this summer. Microsoft Classroom provides a single experience for managing all classes and assignment workflow—with teacher and student views. Microsoft Forms lets teachers or students quickly create custom surveys, quizzes, questionnaires, registrations and more. School Data Sync (SDS) enables class creation and updates in Microsoft Classroom. Learn about these new experiences and the updates to OneNote Class Notebooks and OneNote Staff Notebooks on the way.

FastTrack expanding to help Office 365 customers with end-user adoption—FastTrack, the customer success service for Office 365, is designed to help you move to the cloud and realize business value faster.  User adoption services are being added, providing comprehensive guidance, content and best practices for a successful rollout. End-user awareness kits and end-user training are also being introduced for the most fundamental usage scenarios. Read how the Mott MacDonald Group and the Richland Police Department used FastTrack to help with Office 365 adoption and find out how you can engage with FastTrack.

New Office 365 Project Portfolio Dashboard apps now live—The Project Portfolio Dashboard apps are now available in the Apple and Office app stores. The apps come pre-configured with powerful dashboards that allow business leaders, portfolio managers and project managers to gain insights into resource utilization, project portfolio performance, costs, active risks/issues, key milestones and more. Find out how to download the Project Portfolio Dashboard web app and Project Portfolio Dashboard for the iPad.

First step to the all-new Skype for Business for Mac—The release of the Skype for Business Mac Public Preview has begun. Commercial customers can request an invite to test the Mac client at www.SkypePreview.com. Invitations are being issued to IT administrators to download the client. In the coming weeks the preview will gradually be expanded in three stages leading to public availability, planned for the third quarter of 2016. The initial release lets you see and join meetings. Instant messaging, presence and contacts will be added in Phase 2, and telephony and related features in Phase 3.

Introducing Yammer external groups—You can now include people outside your company in a Yammer group, making it easier for extended teams to work together. External groups allow team members with appropriate permissions from outside your organization to fully participate in projects by providing access to all the conversations and content in the group. Yammer helps maintain the security of your network data by listing all external groups in a distinct section under the Groups menu and using clear indicators in the UI that alert users to the presence of external team members.

More updates for Get & Transform in Excel 2016 and the Power Query add-in—New or improved data transformation features include: the ability to append multiple tables within a single Append operation, one-click Percentage transform and more. New or improved data connectivity features include: support for jagged CSV files, Exchange connector—OAuth support, SharePoint List Connector—URL validation and more. Improvements to previews were also made. These updates are available to Office 365 subscribers. If you have Excel 2010 or Excel 2013, you can get the updates by downloading the latest Power Query for Excel add-in.

Mobile application management and conditional access now available for Skype for Business Online with Intune—Support for mobile application management (MAM) and conditional access capabilities for Skype for Business mobile apps for online customers is here. These capabilities are delivered through integration with Intune. With the core Intune MAM and conditional access capabilities, you can manage and prevent data loss from Skype for Business apps. Support for conditional access policies with Intune for the Skype for Business iOS and Android apps enables IT to restrict access to the apps from compliant iOS and Android devices only.

Office 365 developer updates

New in Office add-ins, plus IT admin and deployment updates—Get a look at what the updates to the Office extensibility model and Office add-ins mean for IT admins. Watch Jeremy Thake and Jeremy Chapman highlight new capabilities announced at 2016 Build for both developers and users, while demonstrating new deployment options to get add-ins to users directly from the Office 365 admin portal. They also show new capabilities with Office 365 Connectors and how you can integrate your team collaboration experience with third-party services

Episode 090 on the 2016 Build Conference—Office 365 Developer Podcast—In this episode, Jeremy Thake and Richard DiZerega discuss the exciting announcements from the 2016 Build Conference, Jeremy’s transition to Azure Marketing and the future of the show. Listen to the podcast and get the list of weekly updates (code snippets, release notes, developer webcasts and instructions for creating Office add-ins) and show notes.

Episode 091 on Angular 2 with Sahil Malik—Office 365 Developer Podcast—In this episode, Richard DiZerega talks with Sahil Malik about what it means to be a developer with Office 365 and the Office 365 work Sahil has been doing with authentication, Angular 2 and Cordova. Listen to the podcast and get the list of weekly updates (getting started with the Dialog API in Office add-ins, working with Outlook Tasks API, deploying Office add-ins through the admin center and more) and show notes.

The latest news for devs—For the latest dev news, code samples, resources and documentation, as well as help getting started with Office 365 APIs, Office add-ins and more, follow this site.

Please note that some of the updates may take time to show up in your Office 365 account, because they’re being rolled out to customers worldwide.

—Andy O’Donald, @andyodonald

——————————————————————————–

*Not all updates apply to every Office 365 plan; please check the individual post for specifics.

The post What’s new: April 2016 appeared first on Office Blogs.

DBCC DBREINDEX

MSDN Blogs - Tue, 05/10/2016 - 05:00

Esse é mais um artigo da série “Saga da otimização com comandos antigos”

No último artigo, comparamos o INDEX SCAN e HEAP SCAN e mostramos que o Heap Scan tem melhor desempenho.

Impacto do Clustered Index

O exemplo do artigo anterior, criamos uma tabela de produto e adicionamos um índice clustered sobre o campo “nome”.

Adicionamos 10.000 registros aleatórios:

No final, temos uma tabela com 15MB.

O resultado final foram 1828ms e 1.900 leituras em disco.

Podemos resolver o problema rodando o comando DBCC DBREINDEX (obsoleto) ou sua nova versão ALTER INDEX REBUILD:

ALTER INDEX nome_indice ON produtos REBUILD

A tabela desfragmentada fica em 10MB e o tempo de execução da query é de 900ms.

Organizando a Tabela

A heap consumia os mesmos 10MB, pois não fragmentava. A query executava em 892ms e realizava 1257 leituras em disco. Então, se o Heap Scan tem melhor desempenho, então por que criar um Clustered Index?

Como vimos no artigo anterior, não vale a pena criar um índice clustered apenas por criar.

É essencial que a escolha da chave para Clustered Index siga as recomendações:

  • Pouca alteração (UPDATE) – mais importante!
  • Campos pequenos (até 8 bytes)
  • Valores sequenciais
  • Valores distintos

No nosso exemplo, há dois problemas em criar um índice clustered usando a chave “nome”: 1) valor não-sequencial, causando a fragmentação natural da tabela. 2) campo longo (800 bytes), que causará futuro problemas com índices non-clustered.

Vou citar 3 motivos para criar um Clustered Index:

1. Evitar problemas da Heap

Embora o heap scan tenha melhor desempenho, a heap esconde alguns problemas:

Por isso, recomendamos criar um clustered index evita esses comportamentos exóticos da Heap.

Campos Identity são boas escolhas porque são campos pequenos (tipo INTEGER), sequenciais e distintos.

2. Período de Dados

Frequentemente encontramos consultas com filtros de data. Quando é necessário ler uma grande quantidade de dados, o índice clustered pode agregar os dados próximos e facilitar as operações de scan.

SELECT * FROM tabela WHERE data_inicio between ‘2016-05-01’ AND ‘2016-05-10’

Campos de data são pequenos e normalmente inseridos sequencialmente. Ao criar um índice clustered, a tabela fica ordenada pela data e facilita as buscas com período de tempo. No exemplo acima, somente os dados do mês de maio serão lidos, sem a necessidade de consultar a tabela inteira e acessar dados dos meses de abril, março, fevereiro, janeiro.

3. Ordenação de Consulta

Quando encontramos consultas usando ORDER BY, podemos sugerir a criação do campo como clustered index.

SELECT * FROM tabela ORDER BY Data

Ao criar um índice clustered, deixamos a tabela pré-ordenada pelo campo chave. Dessa forma, economizamos o recurso de CPU e memória necessário para ordenar os registros em tempo de execução. Entretanto, é importante que a chave tenha pouca (ou nenhuma) alteração.

Exemplos ruins:

SELECT * FROM tabela ORDER BY ultima_modificacao

SELECT * FROM tabela ORDER BY preco DESC

Não adianta criar índices clustered para os campos “ultima_modificacao” e “preco”, pois esses são campos que sofrem UPDATE frequentes.

E as Primary Key?

Geralmente uma Primary Key deve adotar um índice Non-Clustered (NCL).

Entretanto, existem casos para adotar um Clustered Index (CL) em uma Primary Key (PK):

  • Se a Primary Key for um campo IDENTITY, então é uma boa escolha para índice CL.
  • Em banco de dados OLAP, operações de JOIN com grande volume de dados podem se beneficiar de índices CL

Por outro lado, há um incontável número de exemplos onde as Primary Keys são criadas como Clustered Index indevidamente, causando problema de fragmentação e impacto na performance.

Evite fragmentar o Clustered Index

A regra é simples: evite fragmentar o clustered index e tenha o desempenho igual a Heap.

Se essa regra for seguida, eliminamos os três problemas escondidos da heap:

No próximo artigo, vamos explorar um pouco mais sobre os índices. Até o momento, falamos apenas sobre o comparativo do Heap scan e Index scan. Entretanto, a vantagem do índice é usar algo muito mais rápido que o scan.

The Office 365 Education Roadmap is now available

MS Access Blog - Mon, 05/09/2016 - 09:00

Office 365 is available to students and teachers at no cost through their academic institution. Visit Office in education to check eligibility and to download onto multiple devices.

When you make any investment in technology you are investing in a living thing. The pace of development of technology in today’s world is such that improvements and alterations are seemingly continuously available to software, hardware and infrastructure. And with the increasing utilization of the cloud, platforms and tools can be upgraded “on the fly” by the providers without the end users having to break stride. This also enables product developers to be much more receptive to user feedback and incredibly agile when it comes to implementing features and functionality based on these suggestions.

Anyone investing in technology for their school, college or university has the added responsibility of building an environment that will shape the learning paths of hundreds or even thousands of young people. Therefore, it’s important to know not only what the current capabilities of technology are, but where it’s going in the future.

Office 365 Education Roadmap

We’re pleased to share the Office 365 Education Roadmap, which lists updates currently planned for applicable subscribers. Updates for the various stages—from in development to rolling out to customers, to being generally available for applicable customers worldwide—are easily accessible in the Office 365 Roadmap.

To see what’s coming up specifically for Education, simply do the following:

  1. Go to roadmap.office.com.
  2. Open Filters.
  3. Under Services, select Education.
  4. Click the launch status (i.e., in development) to see product/feature items.
  5. Click the item for a description and other information available.

If you don’t see a feature on this roadmap that you or your users would like to see, just add your request to our Education UserVoice.

The post The Office 365 Education Roadmap is now available appeared first on Office Blogs.

Pages

Subscribe to Randy Riness @ SPSCC aggregator
Drupal 7 Appliance - Powered by TurnKey Linux