Visual Studio Code Extension Leaderboard

In previous post, I have introduced the initial release of Visual Studio Code Extension Download Count. And now, the Visual Studio Code Extension Leaderboard is coming! From now, you could see the leaderboard by day, week or month. Enjoy it!


Why “SQL Server Configuration” section on my Azure Virtual Machine is not available?

If you created an SQL Server VM via azure portal, there will be a section called “SQL Server Configuration” which was introduced via blog “Introducing a simplified configuration experience for SQL Server in Azure Virtual Machines”. Here is a screenshot of that setting.  It allows you to configure various things like auto backup, patching or…


The Power of JSON Templates

Creating templates is a powerful way to quickly deploy environments in Azure.  There are many use cases including student labs, environments that need to be duplicated across testing, QA, and production, and in the example outlined below, an environment to support a specific solution or application.  Benefits of deploying templates include the speed of deployment,…


Power BI Webinar 10/4: Getting started using R in Power BI by Stacia Varga

The R programming language is among the most widely used programming languages by statisticians, data scientists, and business analysts.  Power BI service recently started supporting viewing and interacting with visuals created with R scripts. In this week’s Community Webinar Stacia Misner will show us how to get started taking advantage of this amazingly powerful visualization…


Issues with Search feature on Visual Studio Team Services – 9/28 – Resolved

Final Update: Wednesday, 28 September 2016 20:17 UTC We have applied the mitigation and confirm that all systems are back to normal as of 28 September 2016 18:48 UTC. Customers should not see any issues rendering VSTS extensions now. We understand that customers rely on VS Team Services as a critical service and apologize for…


Secure Time Seeding – improving time keeping in Windows

What year is it? <Insert Robin Williams’ Jumanji meme here> (http://i1.kym-cdn.com/entries/icons/original/000/007/784/what-year-is-it-robin-williams.jpg) Most network security protocols rely on the use of keys that expire after a certain amount of time. This appears to be a plain vanilla statement until you think more about it. Timekeeping over long periods of time is a critical for tracking lifetime…


New Mobile Samples using Web API

I’m pleased to announce we have published two new mobile samples to GitHub. Both of these samples demonstrate the same ActivityTracker functionality provided by earlier samples. They have been updated to use the Dynamics CRM Web API and they support iOS9 and Android 6 platforms. The iOS application is written using Swift 2, rather than…


TFS 15 RC2 is available and ready for production use

We have now released TFS “15” RC2. We are using it in production internally. It is fully supported for production use. You can upgrade from TFS 2012 or newer to RC2. You can also upgrade the RC1 release to RC2, and you will be able to upgrade from RC2 to RTM (that should be a…


Team Foundation Server (TFS) 15 RC2 is available and ready for production use

We have now released TFS “15” RC2. We are using it in production internally. It is fully supported for production use. You can upgrade from TFS 2012 or newer to RC2. You can also upgrade the RC1 release to RC2, and you will be able to upgrade from RC2 to RTM (that should be a…


Database Corruption Challenge – Steve Stedman

2016年9月13日 PASS Database Corruption Challenge – Steve Stedman Presented by Steve Stedman https://www.youtube.com/watch?v=5oBA5nL0uRc&feature=youtu.be&a 1.備份資料庫,還原至測試機來進行修復工作(確保還原程序遭遇問題時,可以重頭再來修復一次) 2.如果決定用allow data loss,嘗試先找出可能遺失的資料並事先嘗試SELECT INTO保留下來 3.執行之前尋求是否有其他人的意見   定期執行 osql -E -Q”DBCC CHECKDB (AdventureWorks) WITH ALL_ERRORMSGS, NO_INFOMSGS” -oC:outputfile.txt sqlcmd -E -Q”DBCC CHECKDB (AdventureWorks) WITH ALL_ERRORMSGS, NO_INFOMSGS” -o C:outputfile.txt   PS.WITH NO_INFOMSGS只顯示錯誤訊息,一般的information不顯示   基本流程 1.將有損毀的資料庫備份檔還原到測試機,切換成single_user mode。 ATLER DATABASE AdventureWorks SET SINGLE_USER WITH ROLLBACK_IMMEDIATELY; 2.取得錯誤訊…