You are here

Feed aggregator

SQL Server R Services を初めて使う人のための Tips 集 (環境構築・パッケージ管理編)

MSDN Blogs - Tue, 07/26/2016 - 08:00

 

Microsoft Japan Data Platform Tech Sales Team

倉重 秀昭 / Hideaki Kurashige

 

こちらの記事でもご紹介させていただいている通り、SQL Server 2016 では 新たに SQL Server R Services という R の実行基盤が加わりました。

この SQL Server R Services について、マイクロソフト米国本社の Customer Advisory Team ( 通称 CAT ) が 、彼らの Blog 上で SQL Server R Services を利用するにあたっての Tips をまとめています。今回はその中から特に役に立つと思われる項目を取り上げ、付加情報も加えて詳しく解説していきたいと思います。

(1) SQL Server R Services が正しくインストールされている事を確認する方法

SQL Server R Services を実際に業務で使う場合、環境構築担当者と実際にRを使って分析するデータ分析担当が別々というケースがよくあります。

このように環境構築担当と分析担当が異なる場合、ごくまれに環境構築の担当者はインストールが上手くいったと認識しているにもかかわらず、実際には環境構築が上手くいっておらず、分析担当の方が R を使おうとすると上手く動かないという事があります。
この様な事を防ぐために、環境構築の担当者は、以下の T-SQL を実行する事で SQL Server R Services が正しくインストールされているかを確認する事ができます。

■ SQL Server R Services のインストール正常性を確認するための T-SQL

EXECUTE   sp_execute_external_script @language = N'R' , @script = N'OutputDataSet <- InputDataSet' , @input_data_1 = N'SELECT 1 as Col' WITH RESULT SETS ((col int not null)); GO

SQL Server R Services が正しくインストールされていれば、結果として1が帰ってきます。
返り値がそれ以外の場合には、正しくインストールされていないという事になります。その場合は、トラブルシュートが必要になりますが、トラブルシュートには以下のページが参考になります。

Known Issues for SQL Server R Services

 

(2) インストール済みのパッケージを確認する方法

R を使って分析や開発を行う場合、CRAN 等で公開されているパッケージを利用する事が多いと思いますが
以下のスクリプトを実行する事で、既にインストールされている パッケージを確認する事が可能です。

 

【方法1】SQL Server Data Tools から T-SQL を使って確認する方法

-- T-SQL を使う場合には、sp_execute_external_script ストアドプロシージャーを用いてRスクリプトを発行します。

EXECUTE [sys].[sp_execute_external_script] @language = N'R',
@script = N'

-- installed.packages 関数を使ってインストール済みのパッケージを取得します。
packagematrix <- installed.packages();
NameOnly <- packagematrix[,1];
OutputDataSet <- as.data.frame(NameOnly);'
WITH RESULT SETS((PackageName NVARCHAR (250)));

 

【方法2】R Studio などの IDE から R を使って確認する方法

# SQL Server R Services に接続するための接続文字列を定義します。(以下は SQL Server 認証の場合)

con <- "Driver={SQL Server};Server=サーバー名;Database=データベース名;Uid=ユーザ名;Pwd=パスワード"

# SQL Server R Services に接続します。

sqlCompute <- RxInSqlServer(connectionString = con,autoCleanup = TRUE,numTasks = 8,consoleOutput = TRUE)

 

# rxInstalledPackages 関数をつかってインストール済みのパッケージを表示します。

rxInstalledPackages(computeContext = sqlCompute)

 

SQL Server R Services をインストールした直後の状態では、以下のパッケージがインストールされています。

base foreign mgcv RevoRsrConnector stats4 boot graphics nlme RevoScaleR survival class grDevices nnet RevoTreeView tcltk cluster grid parallel RevoUtils tools codetools iterators pkgXMLBuilder RevoUtilsMath translations KernSmooth RevoIOQ rpart utils datasets lattice revoIpe RUnit XML doParallel MASS RevoMods spatial utils doRSR Matrix RevoPemaR splines   foreach methods RevoRpeConnector stats  

 

 

各パッケージの詳細は以下のページから確認することが可能です。

※リンク先ページは、Microsoft R Application Network(MRAN)という弊社の公式ページで、Microsoft R に関する様々な情報を掲載したポータルサイトです。

https://mran.microsoft.com/rro/installed/

 

(3) インターネット接続の無い環境でパッケージをインストールする方法

SQL Server R Services を用いて実業務で分析等を行う場合、セキュリティーの観点から サーバーをインターネットに接続させない事も多いと思います。

インターネットに接続していない環境でパッケージを追加する場合は、インターネットに接続された別のマシンからパッケージのバイナリファイルをダウンロードし、SQL Server がインストールされたマシンにコピーしてインストールを行います。

ただ、あるパッケージをインストールしようとすると、そのパッケージが依存する別のパッケージのインストールも必要になる事がほとんどだと思います。手作業で依存するパッケージを調べ、そのパッケージを一つ一つダウンロードしてインストールする事も可能ですが、非常に手間がかかってしまいます。この様な場合には miniCRAN パッケージを利用すると、効率よくパッケージをインストールすることが可能になります( miniCRAN は、パッケージ間の依存関係を取得・可視化したり、ローカル上にパッケージのリポジトリを作成するための機能を提供しているパッケージです)。

 

次に miniCRAN を使い、インターネット接続の無い環境での追加パッケージのインストール方法について、簡単に紹介してみたいと思います。

miniCRAN を用いた、オフライン環境へのパッケージ追加方法は大まかに以下のような流れになります。

 

 

 

手順1 インターネットに接続可能な R 実行環境と IDE がインストールされた端末から、以下の R コマンドを実行して、インストール対象のパッケージと依存するパッケージをダウンロードして端末上にパッケージのリポジトリを作成します。

# miniCRAN パッケージをインストールします(パッケージはインターネット経由でダウンロードされます)

install.packages("miniCRAN")

# miniCRAN パッケージをロードします(※1)

require(miniCRAN)

# miniCRAN パッケージの pkgDep 関数を使い、インストールしたいパッケージ(この場合は ggplot2 )が依存するパッケージ名を出力し、
# 変数「 plgList 」に格納します。

plgList<-pkgDep("ggplot2")

# パッケージのダウンロード先を変数「 local_repo 」に格納します。 
local_repo <- "C:\miniCRAN"

# makeRepo 関数を使って、必要なパッケージの Windows 用バイナリ―をダウンロードしローカルにリポジトリを作成します。(※2)
makeRepo(pkgList, path=local_repo,type="win.binary")

 

(※1) 以下の様なエラーメッセージが表示された場合には、install.packages(“stringi”) を実行してstringi パッケージを追加でインストールします。

Error in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]) :
‘stringi’ という名前のパッケージはありません

 

(※2) パッケージファイルを一括ダウンロードする方法として、download.packages 関数を使う方法もありますが、この場合はリポジトリは作成されずに単純にパッケージファイルがダウンロードされるだけです。そのため SQL Server R Services にパッケージをインストールする際には、依存するパッケージを一つ一つ指定してインストールする必要があります。一方 makeRepo を使用するとパッケージリポジトリが作成されますので、パッケージをインストールする際に、install.package 関数の引数に dependencies=TRUE と記載するだけで、関連するパッケージも自動的にインストールされるようになります。

 

手順2 手順1で作成したリポジトリをディレクトリ(今回の例では C:miniCRAN ディレクトリ)ごと、 DVD-R・USB メモリ等の媒体を使って、SQL Server R Services サーバにコピーします。

 

手順3 SQL Server R Services サーバーで R の IDE を起動して、以下のRスクリプトを実行して パッケージをインストールします。

# install.packages 関数を使って、ローカルのリポジトリから ggolot2 パッケージをインストールします。

#  引数:libには、SQL Server R Services のライブラリパスを指定します。
#  (lib引数を明示的に指定しないと、SQL Server R Services に正しくパッケージが追加されません)

#  引数:repos に手順2でコピーしたリポジトリのパスを指定します。

# 引数に dependencies=TRUE を指定すると、依存するパッケージが自動的にインストールされます。

install.packages("ggplot2",

  lib="C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\R_SERVICES\library",
  repos=paste0("file:///","C:\miniCRAN\"),
  type="win.binary",
  dependencies=TRUE)

 

今回は、SQLServer R Services を初めて使う人のための Tips 集として、環境構築やパッケージ管理に関する事項について紹介いたしました。

次回はデータの可視化についての Tips をご紹介する予定です。

Service Bus client 3.3.2 is now live

MSDN Blogs - Tue, 07/26/2016 - 07:53

Check out our newest release for the Service Bus client library!

The NuGet package can be found at https://www.nuget.org/packages/WindowsAzure.ServiceBus/3.3.2.

Below are the release notes:

  • EventHub/Messaging: fixed a bug where a race condition in Amqp management code (AmqpServiceClient) can cause thread to spin. This mainly affect EventProcessorHost scenario.
  • EventHub: fixed a bug in send code path where if user modified a batch event data list during send operation the send path can throw exception due to collection being modified.

 

We have also increased the version on our other EventProcessorHost NuGet package to be compatible with 3.3.2. The EPH is available here.

Happy messaging!

[Service Restored] Service Interruption for AX in Europe

MSDN Blogs - Tue, 07/26/2016 - 07:49

Final Status: An error occurred during a recent upgrade, preventing some users from signing in. Engineers have re-enabled access for all users for affected organizations.

User Experience: Affected users would receive an “Unable to Authorize” error when attempting to sign in and would be redirected to the sign in page.

Customer Impact: A subset of customers hosted in Europe.

Incident Start Time: Tuesday, July 26, 2016, 2:05 PM UTC

Incident End Time: Tuesday, July 26, 2016, 3:10 PM UTC

Next Steps: A Post Incident Report will be published within five business days.

SSH support for Git repos is now available

MSDN Blogs - Tue, 07/26/2016 - 07:34

A few months ago, Jeremy mentioned that SSH support for Git repos was in private preview. I’m happy to announce that it is now available to everyone in both TFS and Team Services. You can now connect to any Team Services repo using an SSH key, which is particularly helpful if you develop on Linux or Mac.

Learn more about SSH, or continue below for instructions on how to upload your public SSH key.

To upload your public SSH key

1. Open your user profile in the upper right-hand corner of the Team Services interface and select My security.

2. Navigate to SSH public keys in the left-hand menu.

3. Click +Add to add your public key. Give the key a description, and then copy and paste the contents of the public key file to the Key Data field. Avoid adding whitespace or new lines into the key data field—they can result in Team Services saving an incorrect public key.

 

As always, please leave your feedback in the comments, on UserVoice, or using the smiley face in the top right of your Team Services account.

Friends dont let friends miss out on free upgrades – Windows 10

MSDN Blogs - Tue, 07/26/2016 - 06:47

The Windows 10 free upgrade offer ends on July 29th. If you haven’t updated to Windows 10, then your time to take advantage of the free offer is almost up. I know you probably love your current OS, but please do upgrade to Windows 10 and take advantage for a much more safer and secure OS, Always Up to Date, and the most productive OS by Microsoft ever.

http://windows.ca

 

 

 

Outlook helps you focus on what matters to you

MS Access Blog - Tue, 07/26/2016 - 06:00

We are being inundated with more information, more communication and more email vying for our attention. It is more critical than ever to have tools that help us cut through the noise and focus on what matters most. Today, Outlook is expanding the availability of two new experiences to do just that—Focused Inbox and @mentions.

These new experiences add to several recently released features, all aimed at helping you take control of your mailbox. In December, Outlook began automatically adding events from your email to your calendar. And last month we added simplified summary cards in your inbox and calendar for travel reservations and package deliveries. Combined, these features help deliver on Outlook’s core mission: Keeping you connected, focused and on top of what matters.

Focused Inbox—focus on the emails that matter most

For many, the inbox is the command center for their day. It’s the way to keep track of what is going on and what needs to get done. Outlook’s Focused Inbox makes this process easier by helping you focus on the emails that matter most to you. It separates your inbox into two tabs—Focused and Other. Emails that matter most to you are in the Focused tab, while the rest remain easily accessible—but out of the way in the Other tab. You’ll be informed about email flowing to Other, and you can switch between tabs at any time to take a quick look.

You’re in control

Focused Inbox is not meant to take control of your mail, but rather work with you to prioritize what is important to you. What lands in your Focused Inbox is determined by an understanding of the people you interact with often, and the content of the email itself (e.g., newsletters, machine generated mail, etc.). If you need to fine tune your Focused Inbox, just use the “Move to Focused” or “Move to Other” options.

What this means for Clutter

Focused Inbox is a refinement and improvement of a previous feature called Clutter. Clutter’s purpose was also to help you focus on the most important items in your inbox, but it did so by moving “Other” email to a separate folder. Focused Inbox makes it easier for you to stay on top of incoming email without having to visit another folder.

As Focused Inbox rolls out, we’ll stop moving messages to the Clutter folder. See the “Frequently asked questions” below for more details on how this will work.

Rollout of Focused Inbox

Focused Inbox was first released on Outlook for iOS and Android and is being used daily by tens of millions of users. Now, it is coming to all versions of Outlook to give you one consistent view of the important items in your inbox. It begins rolling out this week for users of the new Outlook.com and will soon start rolling out for Office 365 customers in our First Release program in early September. Office 365 admins will have mailbox and tenant level control of the feature to stage the rollout in a manner that works best for their organization.

@mentions—get someone’s attention and focus your own

@mentions make collaborating on email fast and easy. Simply type the @ symbol anywhere in the body of your email and start typing to pick the person you want to address. Once you pick the person you want to address their name is highlighted in the message in blue, helping them know they are being asked to take an action in your message. In addition, if the person isn’t part of the email conversation already, they will be automatically added to the To… line so they receive a copy of your email.

@mention someone by typing the @ symbol, followed by their name in the body of your email.

Focus on what needs your attention

In addition to helping you get other people’s attention, @mentions also helps you be aware of what you’ve been asked to do. Outlook adds an @ symbol in the message list for the messages you’ve been mentioned in, so you can see at a glance which emails require your action before you open them. Outlook also includes a filter so you can sort to see only the messages where you’ve been mentioned. Once you’ve opened the email, the blue highlighting of your name in the body of the email helps you quickly find where you’ve been mentioned.

Pro tip—For messages where you’ve been mentioned, Outlook also updates the preview text of the message. Instead of a preview of the first words of the email, Outlook shows you a preview of the text immediately following your mention.

The @ symbol appears in the message list for emails in which you’ve been @mentioned.

Rollout of @mentions

@mentions is already available in Outlook on the web. Today, @mentions is available for Office Insiders using Outlook 2016 for Windows and Mac and is coming soon for Outlook for iOS, Android and Windows 10 Mobile.

Let us know what you think!

If you’re an Office 365 Home or Personal customer, you can try these new features today by signing up for the Office Insider program. If you have any feedback on these features or new ideas, please share them with us at Outlook.UserVoice.com. Stay tuned for more to come!

—The Outlook team

Frequently asked questions

Q. When will I see the Focused Inbox feature in my version of Outlook?

A. Focused Inbox was first released on Outlook for iOS and Android. All versions of Outlook that receive updates will soon become Focused Inbox capable, including Outlook 2016 for Windows and Mac as well as Outlook on the web and Windows 10. Users will begin seeing the feature turn on once their Office 365 or Outlook.com mailbox is enabled for Focused Inbox. Mailboxes on the new Outlook.com will begin becoming Focused Inbox enabled this week, and will continue over the coming months. Office 365 users in the First Release program will become Focused Inbox enabled in early September. Regular Office 365 mailboxes will follow after First Release availability.

Q. What will the experience be for users of Clutter moving to the Focused Inbox?

A. Active Clutter users will have to opt-in to Focused Inbox and will be able to do so from an in-app prompt in Outlook. After they opt-in, they will no longer receive less important email in the “Clutter” folder. Instead, email will be split between the Focused and Other tabs in their inbox. The same machine learned algorithm that moved items to the Clutter folder now powers Focused Inbox, meaning that any emails that were set to move to Clutter will now be moved to Other.

Read this help article for more details on the prompts users will see and how to turn Focused Inbox on and off.

Q. Can I keep using Clutter instead of Focused Inbox?

A. You can keep using the existing Clutter experience through the transition. However, after the transition period, Clutter will be completely replaced by Focused Inbox.

Q. If I turned off Clutter, will I still be able to try Focused Inbox?

A. Yes, you’ll receive a prompt to try the Focused Inbox when your mailbox is ready.

Q. What controls will I have available as an IT admin for controlling this rollout in my organization?

A. Office 365 admins can manage the rollout of Focused Inbox for their users with tenant and mailbox level controls using PowerShell. More details for admins will become available in August via the Office 365 Message Center, prior to Office 365 First Release customers being enabled for Focused Inbox in September.

Q. I’m using Focused Inbox already on Outlook for iOS or Android; does anything change for me?

A. Nothing will change in Outlook for iOS and Android. As our other Outlook apps are updated to include Focused Inbox, you will now see the same set of items in both the Focused Inbox and Other across all your Outlook clients.

Q. Is it possible to turn off Focused Inbox?

A. You can turn Focused Inbox off or on at any time from any version of Outlook. However, we hear from our Outlook for iOS and Android users that they love Focused Inbox, and we hope you give it a try as it rolls out to all of our other Outlook clients.

Q. What email accounts will @mentions work for?

A. The sender features of @mentions will be available to all—regardless of the type of mailbox or email service you are using in Outlook. The recipient features of @mentions (message list improvements, blue highlighting in reading pane) are only available for recipients using Outlook with Office 365 or the new Outlook.com accounts. We will add support for the recipient features of @mentions in Outlook when connected to other emails account (e.g., Gmail, Yahoo) later this year.

The post Outlook helps you focus on what matters to you appeared first on Office Blogs.

New to Office 365 in July—new intelligent services Researcher and Editor in Word, Outlook Focused Inbox for desktop and Zoom in PowerPoint

MS Access Blog - Tue, 07/26/2016 - 06:00

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office team.

This month, we are releasing a new set of cloud-powered intelligent services in Office apps designed to save you time and produce better results. These features help you improve your writing in Word, deliver dynamic presentations in PowerPoint and prioritize the emails that matter most to you in Outlook.

Introducing Researcher: accessing credible sources and cited content just got easier

Researcher is a new service in Word that helps you find and incorporate reliable sources and content for your paper in fewer steps. Right within your Word document you can explore material related to your topic and add it—and its properly-formatted citation—in one click. Researcher uses the Bing Knowledge Graph to pull in the appropriate content from the web and provide structured, safe and credible information.

We’ll continue expanding Researcher’s body of reference materials to also include sources like national science and health centers, well-known encyclopedias, history databases and more. We’ll also soon bring Researcher to mobile devices so you can start creating a quick outline for that term paper no matter where you are or what device you’re using. Researcher is available today for Office 365 subscribers using Word 2016 on Windows desktops.

Introducing Editor—your new digital writing assistant

While Researcher helps you start a paper, Editor assists you with the finishing touches by providing an advanced proofing and editing service. Leveraging machine learning and natural language processing—mixed with input from our own team of linguists—Editor makes suggestions to help you improve your writing. Initially, it will help you simplify and streamline written communications by flagging unclear phrases or complex words, such as recommending “most” in place of “the majority of.”

Editor will start with writing style suggestions to improve clarity, and expand over time.

As a cloud-based service, Editor will get better with time. This fall, it will expand upon Word’s current spelling and grammar tools to inform you why words or phrases may not be accurate—teaching at the same time it is correcting. In the same release, Editor will overhaul Word’s visual proofing cues so you can distinguish at a glance between edits for spelling (red squiggle), grammar (blue double underline) or writing style (gold dotted line). Stay tuned for these and other updates to Editor.

Editor will provide context on why certain words or phrases may be incorrect.

Focus on what matters in Outlook with Focused Inbox and @mentions

Two updates to Outlook this month help you work smarter and take control of your email. Customers love using Focused Inbox in Outlook on iOS and Android. Now we’re rolling it out to Outlook on Windows, Mac and Outlook on the web. Focused Inbox helps you focus on the emails that matter most to you, as it automatically separates your inbox into two tabs. Emails that matter most to you are in the “Focused” tab, while the rest remain easily accessible—but out of the way in the “Other” tab. As you move email in or out of your Focused Inbox, Outlook’s intelligence learns from your behavior to become even more tailored to your priorities going forward.

This release on desktops and web means you now have one, consistent view of the important items in your inbox across all your devices. Read today’s Outlook blog for more details on Focused Inbox, including timelines and what to expect if you currently use Clutter.

We’re also bringing @mentions to Outlook on Windows and Mac for Office 365 subscribers, making it easy to identify emails that need your attention, as well as flag actions for others. To flag someone, just type the @ symbol in the body of the email and pick the desired person. Their name will automatically be highlighted in the email and their email address automatically added to the To: line. If you are mentioned, the @ symbol will show up in Outlook, and you can filter to quickly find all emails where you are mentioned. Within the emails, your name is highlighted in blue, helping you find where you’ve been flagged. @mentions are available today for Office Insiders using Outlook 2016 on Windows and Mac. They’re already available in Outlook on the web and are coming soon for Outlook for iOS, Android and Windows 10 Mobile. Read more in today’s Outlook blog.

It’s easy to scan for emails you’re mentioned in with the @ symbol in the message list and an inbox filter.

The continued evolution of PowerPoint—introducing Zoom

In November, we introduced PowerPoint Designer and Morph, helping anyone create polished slides and captivating motion with just a few clicks. Today, we’re excited to introduce Zoom, which lets you easily create interactive, non-linear presentations. Captivate your audience with smooth, effortless navigation in and out of any slide or section, starting from a single interactive summary slide. Present your slides in whatever order makes sense based on your audience, without exiting slide show mode and interrupting the flow. Office Insiders using PowerPoint 2016 on Windows desktops can now incorporate Zoom in three easy ways to build summary slides, depending on the depth of content and your use of sections. For example, a Summary Zoom for a presentation that has dedicated sections, or a Slide Zoom for a deck that has a few slides.

We’ll continue building more intelligence into Office apps, as well as expanding the capabilities announced today. Read about additional Office 365 updates this month at: Office 2016 | Office for Mac | Office Mobile for Windows | Office for iPhone and iPad | Office on Android. If you’re an Office 365 Home or Personal customer, be sure to sign up for Office Insider to be the first to use the latest and greatest in Office productivity. Commercial customers on both Current Channel and Deferred Channel can also get early access to a fully supported build through First Release. Thanks for your continued feedback and support!

—Kirk Koenigsbauer

The post New to Office 365 in July—new intelligent services Researcher and Editor in Word, Outlook Focused Inbox for desktop and Zoom in PowerPoint appeared first on Office Blogs.

Unable to deploy EDI bridges for MABS

MSDN Blogs - Tue, 07/26/2016 - 05:48

Recently we had a customer who wanted to update one of his EDI bridges. However, surprisingly the Deploy button on the BizTalk Services portal was disabled. Actually this is by design. If you follow BizTalk Services releases, you will notice that we made a new release at August 2014, which changed how EDI bridges were configured. After the August 2014 release, old EDI bridges can still work in runtime, but the design time change is disabled due to incompatibility. Then how can we make changes to Edi bridges older than August 2014?  We will need to delete and recreate the bridge.

Also we have the PowerShell command Clear-AzureBizTalkTrackingStore to remove tracking data. One thing to be careful is that if you have some custom blob containers in the storage account, they may get removed. We suggest using a dedicated storage account for your BizTalk Service deployment.

Written by

Xuehong Gan

File limitation on NFS share

MSDN Blogs - Tue, 07/26/2016 - 05:40

Issue: Error while creating Receive location: “Zero (0) bytes is needed to copy this item

In a recent past, I had a user who was trying to create a new “Receive location” and while trying to provide the path for configuration and selecting the file drop location from File Share we got below error:

“Zero (0) bytes is needed to copy this item”

We see similar problem when we tried to check for the send port which is trying to copy a file to same file share location:

Ideally, this is not a BizTalk issue but we can see that error is generating for BizTalk source. So we tried to look into the problem and found out that this is a File share provided by external vendor and it has its own limitation of files in a directory or folder.

And we see that there was send port enlist backup of files to a folder located here: (in file share) \filer01ecmexternalTransportIntegrationPROD_IN_BACKUP.  Every week or so the service dehydrates because it cannot create any more files in the directory.

Ø  We tried to check if we can create/copy files on same location but was negative and got same error like above.

Ø  Now we found out that user is using NFS file share and 4000 million files can be created in a NTFS folder

Ø  It can be an issue in with the NFS file share limitation

Ø  Check with user to confirm with the NFS share vendor and check which NFS share he is using ?

Ø  Customer is using CIFS SMB version 3 for the share. Max directory size can contain about ~100k files as a CIFS limitation.

Ø  Folder already has 91759 files and can see still it can hold 9K files inside same folder

Ø  Now when we verified and asked user to increase the limit on folder, NetApp being vendor increased the file size limit and can see that we can copy the items now in same directory.

Ø  Now tried to create receive location and it worked fine and user able to enlist the send port backups and start them as well.

Please let us know in case of any questions.

 

Written By

Rajshekher Reddy

Reviewed By

Shailesh Agre

Microsoft GTSC

Code 2016 in 定山渓温泉 に参加します

MSDN Blogs - Tue, 07/26/2016 - 03:36

早くも 8 月が見えてきている今日この頃、夏休みモードの方もたくさんいらっしゃるのではないでしょうか。私も半分夏休みを兼ねて、昨年に続いて札幌は定山渓温泉でプログラミング合宿してきます。

Code 2016 in 定山渓温泉 ~ 湯ったり温泉とプログラミング漬けの二日間

http://codejp.connpass.com/event/34473/

場所は、温泉と大きいプールのある定山渓ビューホテルです。のんびりしてきます。どなたでも参加 OK ですので、よろしければ皆さんもぜひ!

※私は完全プライベート参加です~。なので、普段の仕事では話したことがない Web MIDI API をネタに、半分趣味のお話しをしてこようかと思います。(でも Visual Studio は使いますよw)

 

[Sample Of Jul. 26] How to get text font in PowerPoint by using OpenXML SDK (C#)

MSDN Blogs - Tue, 07/26/2016 - 02:47
Jul. 26

Sample : https://code.msdn.microsoft.com/How-to-get-text-font-in-13ee8627

This sample demonstrates how to get text font in PowerPoint by using OpenXML SDK.

You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage http://1code.codeplex.com/.

日本語入力(IME) の知っておくと便利な機能(2)

MSDN Blogs - Tue, 07/26/2016 - 02:26

皆さま、こんにちは。Windows & Devices 開発統括部です。

Windows 10 をご使用頂きありがとうございます。皆さまから、貴重なフィードバックや改善のご提案をして頂き、大変感謝しております。

前回に引き続き、日本語入力(IME)の知っておくと便利な機能をご紹介いたします。

 

●変換候補の拡張表示

「せいしん」や「こうしょう」など、同音異義語が多いときに、変換候補一覧から目的の変換候補を見つけるのが難しいことがあります。そのような場合、変換候補を拡張表示に切り替えることで変換候補が見つけやすくなります。変換候補一覧を拡張表示に切り替えるには、読みを入力してスペースキー(変換キー)を2回押して変換候補一覧を表示した状態で、 Tab キーを押すか候補一覧右下の [≫] をクリックします。

ちなみに、Microsoft IME の辞書で同じ読みに対する登録語数が最も多いのは「こうじ」で、人名を含めて約 400 語あります。

 

●予測入力の設定

より早い段階で予測候補を表示したい、または予測候補を表示したくないといった場合には、予測入力の設定を変更してください。以下、設定方法をご紹介します。

 

手順:

    1. タスク バーの右側にある IME モード アイコン(画面右下の「あ」または「A」のアイコン)を右クリックします。
    2. [プロパティ] を選択して、Microsoft IME の設定を開きます。
    3. [詳細設定] をクリックして、Microsoft IME の詳細設定を開きます。
    4. [予測入力] タブをクリックして、予測入力の設定画面を開きます。
    5. 設定項目の中で、必要な個所を変更してください。
      例えば、より早い段階で予測候補を表示したい場合は、[予測候補を表示するまでの文字数] に小さい数字を入力します。予測候補の表示を遅らせたい場合には、[予測候補を表示するまでの文字数]に大きい数字を入力します。既定の設定は3文字となっております。

 

 

Windows 10 Anniversary Update のリリースが秒読み段階となりました。

皆さまからお寄せ頂いているフィードバックは品質向上に大きく貢献していただいております。改めて感謝申し上げます。

引き続き品質の向上に努めて参りますので、今後もWindows 10をお使いいただき、フィードバックをよろしくお願いいたします。

Loading Data to SQL Data Warehouse with the .NET SqlBulkCopy class

MSDN Blogs - Tue, 07/26/2016 - 02:00

The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL Server for large scale relational data warehouse workloads. By leveraging SQL Server as the core relational component, customers are able to quickly take advantage of the large ecosystem of solutions and partner products to build their data story. Having a strong set of integrations with Azure Services such as Azure Data FactoryAzure Data Catalog, and Azure Stream Analytics as well as a growing number of Data Management and Data Integration partners, the SQL  Data Warehouse service offers a vast solution set to migrate to the cloud. 

For customers that need to build custom pipelines, the SQL Data Warehouse service offers support for bulk data loading through the .NET SqlBulkCopy class. This is a .NET class that “lets you efficiently bulk load a SQL Server table with data from another source.” Practically, this means you can get data from whatever source you’d like and then insert it into SQL Data Warehouse using a standard .NET framework library. For example, you could create an HDInsight Bolt to pull data into SQL Data Warehouse from Hadoop. 

Let’s build out a sample to try this out.

Database Design

In this example, let’s imagine we have a set of data that describes our products managed in a file (I know it simple but just illustrative).

1,Cables & Power, 2,Camera & Photo, 3,Cell Phones, That latest mobile devices. 4,Computers, 5,GPS & Navigation, 6,Headphones, 7,Home Audio, 8,Office Electronics, 9,Security & Survelliance, 10,Software, 11,Tablets, All of your tablet needs. 12,Televisions, The latest in LCD/LED and 4K. 13,Wearable Technology,

We can model this file in our database by creating a simple Products table:

CREATE TABLE DimProducts ( [ProductID] INT NOT NULL, [Name] VARCHAR(50) NOT NULL, [Description] NVARCHAR(256) NULL ) WITH ( HEAP, DISTRIBUTION=ROUND_ROBIN ); Code Sample

Now that we have our table, let’s start loading it from .NET. I’ve created a simple Windows console application that reads a file, creates a System.Data.DataTable, loads the DataTable with data,  connects to SQL Data Warehouse and then bulk inserts the data. The main body is encapsulated in the Load method:

static void Load(string path) { // Load the file var reader = new StreamReader(path); // Get the Data Table to hold the rows var datatable = GetDataTable(); // Setup our SQL Connection to our SQL Data Warehouse var connection = GetConnection(); // Iterate through the file string row; while ((row = reader.ReadLine()) != null) { // Split the row by comma var values = row.Split(','); // Add the row values to the Data Table datatable.Rows.Add(values[0], values[1], values[2]); }; // Open the connection to SQL Data Warehouse connection.Open(); // Create a Bulk Copy class var bulkCopy = new SqlBulkCopy(connection); // Define the target table bulkCopy.DestinationTableName = "dbo.DimProducts"; // Write the rows to the table bulkCopy.WriteToServer(datatable); ... }

The key steps are the last four – simply connecting to SQL Data Warehouse just like SQL Server, creating a new SqlBulkCopy class, defining the target table, and then inserting the data via the WriteToServer method.

To verify your results, simply Connect to SQL Data Warehouse and run the following query:

SELECT * FROM DimProducts;

You’ll see our 13 rows added:

Download

You can download the SQL Bulk Load sample from the SQL Server Samples GitHub repo.

test twitter count

MSDN Blogs - Tue, 07/26/2016 - 01:56

Junior Years – Building Skills and Habits for Success

MSDN Blogs - Mon, 07/25/2016 - 23:17

Guest Post by Matthew Jorgensen, Microsoft Teacher Ambassador Queensland

Technology is often hard to implement in Primary Years. The touch screen, drag and drop device wave has catered for technology integration in our young students, but they need to be able to use a more productive ecosystem of hardware, operating systems and apps as their work gets more sophisticated. There is evidence that a reliance on easy-to-use touch screen devices, as opposed to those with keyboards, can be detrimental to a child’s development. The earlier we can enable student confidence with this more productive ecosystem, the better equipped our students will be to complete advanced tasks such as programming and multimedia creation.

iPads are often used with younger students because of their ease of use. However, this can be a negative if they are the only devices that our young students use. Literacy expert Sue Palmer explains  ‘we are giving our kids instant gratification all the time … and it makes it harder for them to persevere with something that takes a while to learn. There is a real fear that too much engagement with this quick-fix technology is making it more difficult for some children to read and write.’ (Source: Daily Mail)

Microsoft’s Windows 10 operating system has some great accessibility features that can assist students to perform those rudimentary tasks that our littlies sometimes struggle to execute. One such feature is the array of sign in options. If typing a password with a keyboard is beyond the age group, students can use a simple PIN (Personal Identification Number) to gain entry to the computer.

Even better than using a pin, students can use a picture log in. This works by choosing a picture and then performing 3 gestures on the picture that will act as a sequence which will allow access to the computer.

Edward C. Baig notes that ‘people will still need a more traditional computer. And the virtual onscreen keyboard that pops up when needed is fine for e-mails or scribbling notes, but I wouldn’t want to regularly write articles using it.‘ (Source: USA Today)

Windows 10 allows for an attachable keyboard for longer typing sessions, and a number of touch screen input options to use without the keyboard. To use the Surface in touch mode, simply remove the keyboard and choose Tablet Mode. The user then has a range of input methods to add text which customises the experience for the child.  Those options include:

Touch Keyboard – Standard The default layout provides a simple typing experience Touch Keyboard – Full-size This layout gets you closer to a standard, hardware keyboard Split Screen Keyboard The split screen layout is great for those that grip a tablet with a hand on either side Pen Layout The Pen layout keyboard allows those with supportable hardware pen devices to add handwritten notes that Windows 10 automatically turns into text

Windows 10 is built for the touch generation, and when the touch device has a pen, young students can develop their tactile and fine motor skills. Students can use OneNote to practice their handwriting by tracing over the top of a template. Take that a step further, they can then press ‘Ink to Text’ and see how neat their writing is!

Sticking with OneNote, many of us will be familiar with the Learning Tools Add in. This awesome feature can help students improve their reading and writing skills. This includes gifted learners, students with learning differences or a combination of any of the broad range of unique student abilities.

Feature Proven Benefit Enhanced dictation Improves authoring text Focus mode Sustains attention and improves reading speed Immersive reading Improves comprehension and sustains attention Font spacing and short lines Improve reading speed by addressing “visual crowding” Parts of speech Supports instruction and improves writing quality Syllabification Improves word recognition Comprehension mode Improves comprehension by an average of 10%

 

Apps are an ever-growing element of the Microsoft in Education mission. One easy to use app is Kids Story Builder. Students can use the device camera to take a photo and then record audio over the top. This is a great tool that allows students to demonstrate their learning and vocabulary without the constraints of time an accuracy associated with writing tasks.

So as you can see, there are a number of ways that teachers can cater for younger students inside the Microsoft in Education world. Young children love using technology and may surprise you with their ability to perform tasks that might be considered challenging. Balancing the easier to use tools with more complex hardware, applications and processes is simple with Microsoft in Educations tools.

Froggy goes to Seattle: Tiba dan Istirahat

MSDN Blogs - Mon, 07/25/2016 - 22:03
Tiba di Seattle

Tepat pukul 07.12 waktu Seattle, rombongan Froggy mendarat di Seattle. Ya, setelah penerbangan panjang selama 14 jam dari Dubai ke Seattle, yang penerbangannya melewati daerah Kutub Utara Sungguh perjalanan yang melelahkan. Tapi ketika mendarat di Seattle, seluruh rombongan langsung bersemangat kembali, walaupun masih capek dan kurang tidur.

Setelah melewati imigrasi dan mengambil bagasi, kami semua meluncur ke University of Washington (UW) dengan menggunakan jasa transportasi bandara.

Lokasi tempat tinggal kami selama di Seattle adalah di Alder Hall, salah satu gedung asrama di kompleks University of Washington. Di sinilah Froggy akan tinggal selama seminggu ini. Selain asrama, ada beberapa lokasi lain di UW yang digunakan seperti untuk lokasi makan, lokasi briefing, dan lain-lain.

 

Sementara itu …

Sementara itu, dua anggota tim yang tersisa juga sudah dalam perjalanan dari Jakarta ke Seattle, dengan menggunakan maskapai Korean AIr dan transit di Seoul. Karena transit yang sangat lama (11 jam lebih), maka anggota tim menyempatkan diri untuk tidur di airport

Mereka diperkikaran akan tiba di Seattle besok siang pukul 12.30 pagi.

 

Menghilangkan Jet Lag dan Istirahat

Salah satu cara paling efektif menghilangkan jet lag adalah dengan langsung mengikuti ritme dan kebiasaan orang setempat. Karena kami tiba pagi hari, maka rencana selanjutnya adalah berkeliling kota Seattle sambil memaksa tubuh tidak tidur walupun sudah sangat lelah. Setelah sudah jam 8 malam baru semua anggota tim kembali ke asrama untuk beristirahat.

 

Demikianlah cerita perjalanan #FroggyGoesToSeattle hari ini. Besok adalah hari pertama Imagine Cup 2016 World Finals, yang akan diisi dengan banyak coaching dan briefing. Stay tuned!

Customer Service Collaboration and Swarming

MSDN Blogs - Mon, 07/25/2016 - 21:31

Many Customer Service teams struggle to find the most effective way to use their top skilled and knowledgeable resources.

Traditionally, Support teams have implemented a tiered approach for problem resolution, allowing a case to be routed and reassigned to individuals or queues with the appropriate level of expertise. Leveraging skills-based routing and escalation workflows, Microsoft Dynamics can facilitate the tiered model as well as any enterprise case management solution.

Many organizations are looking to shake up the traditional tiered model and, instead, leverage a collaboration-based approach in order to increase CSR engagement, share knowledge and increase problem solving skills. This collaboration-based model is often known as “Swarming.” The following post will explore the ways in which Swarming can be accomplished using Microsoft Dynamics and some of the benefits that Customer Service teams can glean from such a model.

Intelligent Swarming methodology has been defined by the Consortium for Service Innovation and we will be leveraging their definition to explore how to implement swarming to facilitate collaborative problem solving using Microsoft Dynamics.

Who is the best person to help? Defining User Profiles and Skills

Microsoft Dynamics allows for user profiles to be defined with custom attributes that can be used to facilitate collaboration and to help identify the best resources to solve challenging problems.

Information to build into a robust user profile includes:

  • Language(s) spoken
  • Channel preference (email, phone, chat)
  • Competencies and Skills
  • Product Specialization or Certification

Fields and attributes can be easily configured in Microsoft Dynamics by an administrative or business user without the need to deploy code or IT resources!

Defining Teams

Microsoft Dynamics supports the concept of teams which allow users from different business units in an organization to collaborate on an issue or record. Users can belong to multiple teams and membership to a team can give a user additional rights and permissions, providing necessary visibility and accountability on relevant issues.

For example, a user who has the right to read and update cases they own can also read and update relevant cases for collaboration when associated to a team that user belongs to.

Microsoft Dynamics differentiates between owning teams and access teams. Owning teams allow a record such as a case to be assigned and owned by a group of users as opposed to an individual. This can be especially beneficial for reporting purposes and allows for a CSR to reassign an issue to a team for resolution. While this can be an effective escalation path, swarming is most impactful when ownership and responsibility for a case or issue does not transfer hands.

This is where access teams come in. Access teams in Microsoft Dynamics are temporary, created and dissolved as needed. This allows for users to swarm a problem, collaborate and then disband once the swarm has completed. Since different types of issues may require teams comprised of different skills and resources, access teams allow for the most relevant users to be tagged to help for specific problems.

As the image above shows, an access team allows different users from different business units and roles to be temporarily linked together in order to collaborate and solve a problem. The access team can be disbanded once a resolution has been reached.

Access teams can be created manually by users who need assistance as well as leveraging team templates to auto-create access teams with necessary permissions when appropriate.

Capturing Reputation and Metrics

User profiles support Subgrids and Charts to show historical collaboration data and reputation information in an easily readable graphical format.

As with all fields on a Microsoft Dynamics form, user permissions can be defined for visibility and read/write access to these data points as appropriate.

Requesting Help

One of the most important aspects of Swarming is making it simple and seamless to request help. The user who needs assistance should be able to very quickly ask a question or raise their hand to engage a Swarm.

Asking Questions of Teams

Sometimes, a CSR working on an issue encounters a question or problem they want Swarmed. Using Microsoft Dynamics Activities directly within the case form, a question can be posed to a Swarm Team and assigned with defined priority, resolution date and other configurable information.

Once the activity has been created, the team and/or user(s) are notified of the request for help and any actions taken against the activity and case are logged.

If an organization leverages Microsoft Yammer, questions can be posed and shared directly within the case form as well and different groups, teams and people can be tagged to assist.

Assign to Teams

As described above, Microsoft Dynamics allows for the creation of Owning Teams to which cases and problematic records can be assigned. This transfers ownership of the record to a team to swarm and resolve. Security Roles for users on the Owning Team are applied as though they are the owner of the case or record . Once the problem has been addressed, the team can reassign the case back to the original owner or return the case to a queue.

When an organization does not want to transfer ownership of the case to a team, an Access Team can be defined to share the record with a team to swarm and resolve. As we saw before, Access Team Templates can be defined for specific entities. A CSR can use views to search for users with particular skillsets or characteristics to add to an Access Team in order to Swarm.

You can also leverage workflow in Microsoft Dynamics to assemble Access Teams automatically when the CSR who owns the case needs help. For example, a CSR changes the status of the case to “Hand Raised” to indicate that the case needs Swarming assistance as seen in the screen shot above. The status change can trigger a workflow that shares case access to individuals or teams which meet specific criteria. Then, when the status of the case changes, and the CSR’s hand is no longer raised, the sharing can be removed and Access Team automatically dissolved.

// Grant a team read/write access to a case.
var caseReference = new EntityReference(Incident.EntityLogicalName, _incidentId);
var teamReference = new EntityReference(Team.EntityLogicalName, _teamId);
var grantAccessRequest = new GrantAccessRequest{


PrincipalAccess = new PrincipalAccess{


AccessMask = AccessRights.ReadAccess | AccessRights.WriteAccess,
Principal = teamReference


},


Target = caseReference

};
_serviceProxy.Execute(grantAccessRequest);

Offering Help

List Views and Dashboards can be configured to help Subject Matter Experts and Resources identify areas where they can be of assistance. Users who can proactively offer help and collaboration assistance should be assigned SME Resource security roles that allow them to monitor cases owned by other users.

Some ideas of criteria to define for list views and dashboards include:

  • Cases related to SME product that have been open for more than X hours/days
  • Cases close to violating resolution SLA
  • Cases in the “hand raised” status
Microsoft Office Groups within Microsoft Dynamics

Customers with a Microsoft Office 365 Subscription are able to leverage the power of Office 365 Groups directly within Microsoft Dynamics.  Office 365 Groups are a shared workspace for email, conversations, files, and events where group members can Swarm to collaborate.

You can use groups to Swarm with people across your company, even if they don’t have access to Microsoft Dynamics. For example, you can create a group for a software defect Swarm and invite other Office 365 users to join the group, and then share documents, conversations, meeting notes, and OneNote information related to that specific issue, defect or product.

test archive

MSDN Blogs - Mon, 07/25/2016 - 20:40

The next platform: conversation

MSDN Blogs - Mon, 07/25/2016 - 20:33

Forget the GUI. The Conversational User Interface, CUI, is here. Language is the new way we engage with computers and bots are the tech that’s modernizing our services. The quirks of current user experiences will be replaced with a more natural, sticky UX with a low barrier to adoption: conversation. For users, who spend 80% of their time on mobile in messaging apps, language is more intuitive, faster and accurate than an app interface that requires clicks, downloads, and scrolls. Language is how we get things done. Browsing the web will become a user simply shouting into the internet, while bots work in the background to connect the fragmented services that proliferated under the app store model to return just the right information.

The big (data) picture
This next wave of intelligent tech feeds on data, so, naturally the tools you need to build modern experiences are in the Cortana Intelligence Suite: a monthly subscription to big data, machine learning, and advanced analytics tools.

The Microsoft Bot Framework is one of these intelligent services. It’s a toolkit that provides developers with what they need to build and connect clever bots. Also under the Cortana Intelligence Suite sits a bevy of 20+ Cognitive Services that can be integrated with bots to give them special abilities to recognize human interactions and intent in vision, speech, language, and more.

Begin building brilliant, boast-worthy bots with these Bot Framework features

  • Get access to everything you need to build bots that are based on .NET / C#, Node.js or REST API via the open source Bot Builder SDK in GitHub which includes automatic translation to 30+ languages, user and conversation state tracking, and pre-built models to recognize common entities and requests.
  • Move beyond a command line style UI with rich interactions such as images, Skype calling, cards, and buttons. Where not supported natively these features are text-rendered.
  • Determine a user’s likely intent based on a model created and trained by you via integration of the LUIS (Language Understanding Intelligence Service) API.
  • Debug and test your bots locally in the emulator with easy to use JSON.
  • Configure your bot to supported channels including SMS, Office 365 mail, Slack, GroupMe, Telegram, Messenger, and Kik.
  • Use your Microsoft account to register and create a profile for your bot in the Bot Framework Developer Portal. All bots registered are auto-configured to work with Skype and the Web.
  • Have your bot discovered and used by others by submitting it for review to be registered in the public Bot Directory.

Cool, huh. Lost for words? The Murphy Bot will help you find an image when a picture will say it better. Interested in reading more on bots? There’s a bot for that too: Summarize gives a quick overview of any web page. And if you’re still a little unclear, there’s even a bot to explains bots!

Join the 30,000 developers using the Microsoft Bot Framework. We’ll keep an eye out for your Loebner prize entry!

Anna (@anna_christo), and The NZ MSDN Team (@msdevnz).

testblogpost_cqiyp

MSDN Blogs - Mon, 07/25/2016 - 20:29

Pages

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