Bot Framework と Office Graph で DevOps その 1 : ユニットテスト概要

Bot 開発してますか?DevOps 取り入れてますか?ということで今回からしばらくこのテーマに沿って考えてみます。 具体的に Office Graph を利用したアプリを作りながら作業を進めますが、初回の今回はテストの概念をまず。 – DevOps についてはメソッド屋のブログにある 「DevOps スタータキット」を参考にしてください。 – Bot Framework を利用したボットアプリ開発は多く記事があるので検索してみてください。例えばSecretaryBot 開発チーム Blog などは分かりやすいです。 Bot Framework とユニットテスト概要 DevOps で一番大事なことはカルチャーですが、技術的な面に限定すると、個人的にはテストです。テストの自動化ができないと継続デリバリーできません。Bot Framework で作るボットアプリの場合テストは UI が無い分簡単ですが、MVC 等他のアプリとは異なるアプローチが必要です。以下ブログはユニットテストにおいてその点の考察がよくまとまっています。翻訳は機械に任せて理解すべきところを意訳してみます。かなり抜粋して意訳しているので原文も是非。 参考元 https://www.microsoft.com/reallifecode/2017/01/20/unit-testing-for-bot-applications/ Thanks to Catalyst team and Mor Shemesh who shared their precious knowledge and allow me to re-use your contents. ちなみにブログは Node.js での例ですが、私は C# メインなので、後半で…


Connecting Power BI to your Visual Studio Team Services Account

I have this question often enough i wanted to walk through the experience myself and the fact that Anthony Borton (an ALM MVP was spending the weekend with me seemed like the right time!) This is also documented in the VSTS and the Power BI docs: https://www.visualstudio.com/en-us/docs/report/powerbi/connect-vso-pbi-vs https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-visual-studio/ The steps to get started: 1. Login…


SQL Server Managment Studio default locations

SQL Server Managment Studio default locations SQL Server Managment Studio 執行檔預設路徑與位置 SQL Server 2014 C:Program Files (x86)Microsoft SQL Server120ToolsBinnManagementStudioSsms.exe SQL Server 2012 C:Program Files (x86)Microsoft SQL Server110ToolsBinnManagementStudioSsms.exe SQL Server 2008 R2 C:Program FilesMicrosoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe SQL Server 2005 C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe


Visual Studio ALM Rangers – Champion of Champions 2017 award

We are pleased to announce the nominees and winner of the Champion of  Champions Award 2017, selected by their peers for impact over the past 12 months. The champion of champions is the brightest star amongst all ALM Rangers, who we admire and respect. Reviewing the nominations is always an amazing experience. It’s humbling to…


TFS automation – User management

In this post, Sr. Application Development Manager, Nandu Muralidharan introduces the TFS API set to help automate administrative tasks associated with managing users in Team Foundation Server. He also shares a set of helper components that he authored to assist developers in this space.   You can check out Nandu’s blog here.  This is part 1…


Web API with Docker and Kubernetes

Context As companies are continuously seeking ways to become more Agile and embracing DevOps culture and practices, new designs principles have emerged that are more closely aligned with those aspirations.  One such a design principle that had gained more popularity and adoption lately is Microservices.  By decomposing applications to smaller independent components, companies are able…


Evento Windows Platform Bridge Tour

  Nos próximos dias 29 e 30 de maio, teremos o evento Windows Platform Desktop Bridge Hackathon no escritório da Microsoft São Paulo. Esse evento será apresentado pelo time de produto do Windows e pelo time de suporte Microsoft Premier. No evento, iremos discutir como converter e evoluir aplicações legadas Desktop (VB6, Delphi, .NET Windows…


How to reset forgotten sa password

How to reset forgotten sa password 如何重設sa密碼  或 忘記sa密碼的情況下加入一個SQL管理員帳戶 如果忘記sa密碼,有2個方法解決 方法一 不需要重啟SQL Server服務,但Login裡面必須要原本就有NT AUTHORITYSYSTEM帳戶,且此帳戶要有sysadmin Role 1.下載Sysinternals的psexec.exe工具 https://technet.microsoft.com/en-us/sysinternals/bb897553.aspx 2.啟動命令提示字元,用psexec.exe來啟動SSMS,就可以用NT SERVICESYSTEM身分Windows驗證登入 PsExec.exe -s -i “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe” SQL Server Managment Studio default locations 方法二 處理過程會有downtime,因為需重新啟動SQL Server服務。 1.停止SQL Server服務 2.啟動第1個命令提示字元,以Single user mode啟動SQL Server Start the SQL Server instance using single user mode (or minimal configuration which…


Data Cleansing Tools in Azure Machine Learning

Today, we’ll discuss the impact of data cleansing in a Machine Learning model and how it can be achieved in Azure Machine Learning (Azure ML) studio. It is an important part of the Data Science Process as I discussed in my previous blog post. In this example, I’m using a credit scoring data set which has the…


Bad relationship meaning no Free/Busy

TL;DR – if you have a bad personal relationship then you will lose free/busy 🙂 I’ve recently worked with one of our o365 customers to investigate a free/busy issue not working across forest in one direction from X1@contoso.com —–x> to Y1@datum.com It’s working for everyone else, even X1 is able to see the f/b of…