Build a WordPress Application on an AWS EC2 Instance
Follow these steps to get WordPress up and running in AWS by installing Apache, MySQL, and WordPress and setting the necessary permissions.
Nai Biao Zhou has twenty years of experience in software development, with strong analytical skills and a broad range of computer expertise.
He has fifteen years of experience in development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environments.
He has a master's degree in Control Engineering and is pursuing a Master of Science degree in Predictive Analytics. Knowledge/Skills Advanced computer programming skills and well versed with C/C#, Java, ASP.NET, JavaScript, and SQL.
In depth knowledge of Solution Architecture, and Software Development Life Cycle (SDLC).
Microsoft Certified Application Developer (MCAD) since 2004.
- MSSQLTips Awards: Author of the Year - 2021 | Rising Star (50+ tips) - 2024 | Author Contender - 2020, 2023
Setup a WordPress Environment – Apache, MySQL and phpMyAdmin
Steps to create WordPress development environment including Apache web server, MySQL server, and walk through the phpMyAdmin interface.
Build a Multi-Node Apache Hadoop Cluster using AWS EC2 Step by Step
Step-by-step instructions to create a multi-node Apache Hadoop cluster for the distributed processing of large data sets across multiple computers.
Power Query M Language in Excel Tutorial
This article introduces M language concepts and examples of using M to manipulate data in Excel.
DAX in Excel Step-by-Step Tutorial
In this tutorial, learn how to use DAX to build Excel functions to build efficient data models for data analysis.
Combine Data from Multiple Sheets in an Excel file with Power Query
This article shows how to use Power Query to combine data from multiple sheets in an Excel file.
Pivot Tables in Excel – A Step-by-Step Tutorial for Beginners
In this tutorial, learn how to build a comprehensive pivot table in Excel using data from a SQL Server database.
Learn how to use Power Query in Excel to Transform Data
Learn how to use Power Query in Excel to transform data from SQL Server tables into useful data for Excel reporting and charts.
Data Warehouse Architecture for Small and Medium Businesses
Learn about the process and principal components of building a data warehouse and learn about the five predominant architectures.
Create MSI Installer for a Python Application for Easy Distribution
The article describes the steps to create an MSI installer for a Python application for easy distribution.
Build Standalone Python Executable Application
In this article, learn how to build a standalone Python application without the need to have Python installed for the application user.
Build Python GUI with Tkinter
Learn how to build a Python graphical user interface application in this step-by-step article.
How to Run a Python Script as a Windows Service using NSSM
In this article, learn how to build a Python application that runs as a Windows Service to handle ongoing routine tasks using NSSM.
Python as a Windows Service Example
In this article, we look at how to build a Python application that runs as a Windows Service to handle ongoing routine tasks.
Build a Web Crawler in Python for a Website Content Audit
In this article we look at how to use Python to build a web crawler and conduct a website content audit.
Python Web Scraping to Conduct a Web Content Audit
In this article we look at how we can use Python to scrape website content from a web page and then analyze the data.
How to Run a Python Script in Windows
In this article we look at how to use Windows Task Scheduler to run Python scripts on a scheduled basis along with examples.
Python Regex Explained with Examples
In this article we cover in depth how Regular Expressions (RegEx) works along with several examples using Python to explain RegEx.
Run Python Scripts in a SQL Server Agent Job
In this article we walk through how you can run Python scripts using SQL Server Agent, so you can setup scheduled jobs to run your Python code.
Download Data from an HTML Table to an SQL Server Database with Python
Learn how to do web scraping using Python and how to store the data into a SQL Server database.
SharePoint List CRUD Operations using Python
This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.
Multiple Linear Regression for Estimation and Prediction in SQL Server
Deep dive into multiple linear regression for estimation and prediction using real estate data and SQL Server and R for data analysis.
SharePoint File Management in a Document Library using Python
In this article we look at several Python script examples that all you to manipulate files within a SharePoint document library.
Time Series Forecasting Methods with R Examples
Learn about time series forecasting using R with Mean Method, Naive Method, Seasonal Naive method and Simple Moving Average Method.