Blog Archive
Tsql
- January 2024 - Several SQL function that saved me a lot of time
- December 2018 - Trick SQL Server to use the best Execution Plan
- July 2018 - Dynamic! Dynamic!
- June 2018 - Running Total Percentage
- April 2018 - Query Result side by side. Yes, finally!!
- April 2018 - query result side by side? NO!
- November 2017 - Buying My Own House, or Staying in a Friend’s House
- October 2017 - Sample Databases Download and Installation
- July 2017 - Install a SQL Server Virtual Machine in the Cloud
- June 2017 - First Thing First, Let’s Build Our Lab
Career
- May 2020 - Bridges between Excel and SQL
- February 2018 - Blogging and Personal Branding
- November 2017 - Career Transition Example 1
- October 2017 - Articles, books, and sites that I get encouragement from
- October 2017 - Meetings I highly Recommend You to Attend
- October 2017 - A very good article about Career Transition
YEAH!
Presentations
- October 2020 - Archive for Virtual PASS Group Meeting
- July 2019 - Charlotte SQL Server User Group Meeting presentation on 2019-07-19
Python
- November 2023 - How to connect to SAP HANA with hdbcli and windows authentication (or windows credential)
- March 2020 - When Python Meets SQL–part 5: read/write multiple sheets from one excel file
- March 2020 - When Python Meets SQL — part 4: writing multiple excel files into SQL server through loop
- March 2020 - When Python Meets SQL-part 3: load excel file data into SQL Server without creating table
- March 2020 - When Python Meets SQL –part 2: loop to ETL multiple tables
- March 2020 - When Python Meets SQL–part 1: move data between two SQL servers with fast load
pySpark
- November 2023 - How to use cache and broadcast to increase the code effeciency dramatically
- January 2023 - How to Distribute Effectively on a Hadoop Cluster
- August 2022 - Simplest PySpark Code for Data Engineer
- April 2020 - When SQL Meets Spark 1 –connect PySpark to SQL Server
Other
- March 2025 - Ask Copilot About How To Make A Webapp To An Internet Site
- November 2023 - A Space Designed For Testing
- August 2023 - About Aws Workshop Info
- March 2021 - Blog Post Title From First Header
Data-Engineer-and-Architecture
- November 2023 - How to connect to SAP HANA with hdbcli and windows authentication (or windows credential)
- March 2023 - How to turn Data Scientists’ python code to a Data Engineer PySpark code
- February 2023 - Best Online Resources for becoming a Data Engineer and Architecture
AI
- April 2025 - Let Github Copilot Teach Me Code That I Am Not Familiar
- March 2025 - Learn To Use Claude Api Key And Component Of Response
- March 2025 - Example Conversation I Had With Copilot On Github
- March 2025 - Example Conversion I Had With Copilot On Vs Code
- March 2025 - Create A Simple Webapp
- February 2025 - Ai Project Prompt Three Level