用 WMI 查詢一個服務是否執行, 若不是把它執行

以 SQL Server Agent 為例, 服務名稱可以自行替換 Option Explicit Dim objWMIService, objService, strComputer,strService strService=”SQLSERVERAGENT” strComputer = “.” Set objWMIService = GetObject(“winmgmts:” _ & “{impersonationLevel=impersonate}!\” & strComputer & “rootcimv2”) For Each objService In objWMIService.ExecQuery(“Select * from Win32_Service Where Name = ‘”_ &strService&”‘”) If objService.State <> “Running” Then objService.StartService End If Next WScript.Quit   Enjoy. Jacky


How not to write Xamarin UI Test !

Here in this blog, i will discuss about the experience that i had while using Xamarin UI Test for iOS apps. What is Xamarin UI Test? Xamarin UI Test is an automation framework based on Calabash, C# and NUnit. This can be used to automate mobile applications like iOS/Android. Why? For an engineer who is…


Use Azure Policy to help enforce compliance standards for your Azure deployments

Scenario: You need to allow researchers the flexibility to create storage accounts in Azure but you want to ensure they’re using security best practices.  Specifically, you would like to require that secure transfer (HTTPS) be required as they transfer data in & out over the network as well as Server Side Encryption (SSE) be enforced…


SSL Cert Renewal Issues Solved On Azure Service Bus and Relay

To our Azure Relay and Azure Service Bus customers, Some of you might have seen the below error whenever the Relay and Service Bus service updated its SSL certificate chain. Unhandled Exception: System.IdentityModel.Tokens.SecurityTokenValidationException: The X.509 certificate CN=servicebus.windows.net is not in the trusted people store. The X.509 certificate CN=servicebus.windows.net chain building failed. The certificate that was…


Diagnosing common memory leak patterns in the browser

Abstract : This is a memory leak oriented session for Internet explorer and Edge browsers. In this session, we will discuss on various examples to identify the memory leak patterns and how do we resolve them. We will see how to analyze the memory leak using f12 memory profiler and Windows performance analyzer (WPA). This…


Say Hi to Process Monitor, Process Explorer and Fiddler!

Abstract : This session would shed some light on the tools which are used by our Support Engineers on daily basis. It has always been a mystery that what exactly an application or a process is trying to access on the machine. Even if we know, there comes a question again, what tools should we…


Browsers: Proxy Configurations, Scripting and troubleshooting them using different tools

Abstract : This is a Proxy oriented session, that starts with introduction to proxy servers. We will discuss about various configurations of proxy with reference to the browsers IE11 and Microsoft Edge. Focus would be mainly on tools such as “Winhttpdiag”, “AutoProx” and “PAC-DBG”, which helps us understand proxy set up and aid in troubleshooting….


EDGE Extension and Microsoft’s open-source SONAR tool

Abstract : EDGE Extension:  Quick intro into the world of extensions. What is the need of extensions? Simple demo using the extension API’s and the roadmap of extension API’s for Edge browser. Microsoft’s open-source SONAR tool: What is this tool all about, demo on how to use it as a command line utility. How to…


Importing a .dbf (dBase) file into Power BI

How can I import data from a .dbf (dBase) file into Power BI? Today’s Power BI Mailbag Question comes from a friend who often works with geospatial data and, as a result, ends up with several different shapefile formats, including .dbf (dBase) database table files. There are several blog articles around shapefile mapping options in…


Cost Optimization on Azure

Cost is always a concern with customers when it comes to the cloud. I’ve had a number of conversations with customers lately around how they can take advantage of various offers and benefits on Azure to reduce their costs, and I thought I’d share some of them here as well. There are many things you…