Hi! I’m Joann Hsu. Thanks for stopping by.
I started this blog to share my knowledge and experience of SQL Server and business intelligence several years ago. But technology and tools around us are changing rapidly and my learning has been more diverse than my initial imagination and plans. So, the blog is almost my notebook of what I have learned and found useful in our daily work about data analytics. I hope the readers of this blog will find the content here is useful and informational. I am here cheering for my readers on their own learning journey. Have FUN!
Posts
-
My Ai Study Journal
-
What Is The Most Practical Way To Create My Personal Knowledge Bank
-
Conversation With Gpt O1 Pro
-
A Simple Example Of Using Api Key In Python Code
-
Let Github Copilot Teach Me Code That I Am Not Familiar
-
Learn To Use Claude Api Key And Component Of Response
-
Ask Copilot About How To Make A Webapp To An Internet Site
-
Example Conversation I Had With Copilot On Github
-
Example Conversion I Had With Copilot On Vs Code
-
Create A Simple Webapp
-
Ai Project Prompt Three Level
-
Several SQL function that saved me a lot of time
-
How to use cache and broadcast to increase the code effeciency dramatically
-
A Space Designed For Testing
-
How to connect to SAP HANA with hdbcli and windows authentication (or windows credential)
-
About Aws Workshop Info
-
How to turn Data Scientists’ python code to a Data Engineer PySpark code
-
Best Online Resources for becoming a Data Engineer and Architecture
-
How to Distribute Effectively on a Hadoop Cluster
-
Simplest PySpark Code for Data Engineer
-
Move My Old Blog from Paid WordPress to GitHub
-
Blog Post Title From First Header
-
Archive for Virtual PASS Group Meeting
-
Bridges between Excel and SQL
-
When SQL Meets Spark 1 –connect PySpark to SQL Server
-
When Python Meets SQL–part 5: read/write multiple sheets from one excel file
-
When Python Meets SQL — part 4: writing multiple excel files into SQL server through loop
-
When Python Meets SQL-part 3: load excel file data into SQL Server without creating table
-
When Python Meets SQL –part 2: loop to ETL multiple tables
-
When Python Meets SQL–part 1: move data between two SQL servers with fast load
-
Charlotte SQL Server User Group Meeting presentation on 2019-07-19
-
Trick SQL Server to use the best Execution Plan
-
Dynamic! Dynamic!
-
Running Total Percentage
-
Query Result side by side. Yes, finally!!
-
query result side by side? NO!
-
Blogging and Personal Branding
-
I got the MCSE title!
-
Buying My Own House, or Staying in a Friend’s House
-
Career Transition Example 1
-
Sample Databases Download and Installation
-
Articles, books, and sites that I get encouragement from
-
Meetings I highly Recommend You to Attend
-
A very good article about Career Transition
-
Install a SQL Server Virtual Machine in the Cloud
-
First Thing First, Let’s Build Our Lab
subscribe via RSS