An Enthusiastic Programmer

Log Expensive Queries Into Files By Extended Events

|

SQL Server provides a functionality called Extended Events. You can measure SQL’s running time once it finished its query, and that is awesome. All that you need to do is to register an event, and SQL Server will do these dirty boring jobs for you automatically.

Find Slow SQL Queries With sys.dm_exec_query_stats View

|

This article will lead you to monitor SQL’s running time most simply. In a busy system, hundreds and thousands of SQLs are running, so It is necessary to find and fine-turn slower running SQLs.

Monitor And Analysis

|

MSSQL Tutorial

|

Welcome to this episode of discussing SQL Server performance issues. Through this series, you will learn how to monitor and fine-turn performance in a database. You may know that network traffic, disk I/O, and CPU usage are the key to peak performance. The upcoming blogs will introduce varieties of tools and snippets that will assistant you in troubleshooting the SQL server’s performance amicably. What are you waiting for! Let’s kick it off now!

Parallel Processing In VBA

|

Have you encountered the problem that you want to launch another thread to tackle other works when the current window is suspended(Such as, perform operations on the “Save As” window)? To be blunt, VBA doesn’t provide the multi-threads implementation.

UI Automation On Excel Macro

|

How to use the Microsoft UI Automation component. Microsoft UI Automation is a new accessibility framework for Microsoft Windows, available on all operating systems that support Window Presentation Foundation(WPF)

Caching Static Resources

|

Using Nexus3 as your repository - A Simple Guide(No Deep Shit!)

|

Using Nexus Repository Manager(NXRM) as your docker repository

|

This article guide you to set up a Nexus Repository Manager as your docker registry from scratch, and we will cover installation, SSL, and User management in the next articles. nexus3 vs Docker Registry

Deploying a Web App from a Command Line using MSBuild, MSTest, and WebDeploy

|

The Microsoft Build Engine(aka. MSBuild) is a platform for building applications. You can define an XML file, which guilds how the MSBuild behavior. The Visual Studio uses MSBuild to achieve the building process. However, the MSBuild doesn’t depend on Visual Studio, and hence you can invoke the MSBuild.exe without Visual Studio IDE installed. MSTest is a command-line command to run tests. Web Deploy (aka. msdeploy) is a command-line executable tool created by Microsoft, which simplifies the deployment of Web applications and Web sites to IIS servers.