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
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