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


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…


Personalize what notifications you receive for releases

There are multiple stakeholders for a release. Whether the team is small or large, keeping the right stakeholders informed about how releases are progressing and what actions are required. Notifications, whether they arrive via email, Microsoft Teams, Slack, or some other system, push relevant information to recipients. Recipients don’t need to periodically check for new…


Debug your Arduino code with Visual Studio Code

Debugging Arduino application is a challenging task as the debugging feature has not been officially supported in Arduino IDE. Many modern IDEs have debug support that developers are used to, using Breakpoints, Steps, Call Stack, Watch, Local/Global Variables, etc. Arduino developers often have to explore many alternative methods and tools to debug Arduino code. If the board…


[Sample Of May. 27] How to get started for using Azure IoT Hub and DocumentDB

May. 27 Sample : https://code.msdn.microsoft.com/How-to-get-started-for-6fc891af This sample demonstrates how to use Azure IoT Hub and DocumentDB. 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…