Alex Joh's Blog

Creating Blog for Google Blogger using Visual Studio, Markdown, and Syntax Highlighter Introduction Prequistics Reference Steps 1. Download markdown-it components 2. Add JS and CSS to google template 3. Result Summary Introduction I used StackEdit to convert a Markdown document to html and the format has some problem with recent template from Blogger. The steps I used were; 1. Create Markdown document from local computer using Visual Studio Code to store it to my Git Repository 2. Copy it to StackEdit to convert to HTML 3. Paste it to Blogger admin page. I wanted to simply to eliminate StackEdit process and tried to generate HTML document directly from Visual Studio Code, but had lots of problems. The problem was that No extension to generate proper HTML document. There is pandoc component, but not working well with Blogger Set up Highlighter cdn to Blogger template I wish this approach saves time to generate html document from Blogger Prequistics Nodejs: ...

During developing Product dimension, I had one challenge about linking between product and category. The challenge was that our ERP product model has multiple categories. It allows to link 10 categories to one product which causes lots of issue during building snowflake type connection. Reference FTDW(Fast Track Data Warehouse Reference Gudie) FTDW Sizing Tool Getting Currency History Updating data using Stored Procedure CRUD Stored Procedure Generator toolkit for SSMS(Trial) AdventureWorks DW Tutorial AdventureWorks Entire Files What is problem AdventureWorks model for the product As you see from the above picture, Product is linked to the subcategory and the subcategory linked to category with only one foreign key. During adding this foreign table to the main dimension table, most time, users will click Key field from foreign key field and move to dimension attribute pane to add it. If you think that you have two categories for one product, you can’t add usi...