透過 Powershell 部署 SQL 腳本到多個網站的資料庫![Mark Ku]()
問題 有一套系統，卻克隆 ( Clone )了很多個網站，每個站都是獨立的資料庫，因此部署資料庫時，過去需要人工去每一部部署腳本，此篇則要透過 Powershell 將一個週期開發的 sql…
June 04, 2021
1 min
近期文章
使用 Windows Docker 來建立ASP.NET 網站容器![Mark Ku]()
安裝 windows Docker 相關軟體 1.power shell 安裝 docker 需要的相關軟體 (需系統管理員方式執行) 2.重新啟動電腦後，開啟Docker Desktop…
June 04, 2021
1 min
用Power shell 及 chocolatey 撰寫自動化安裝應用程式及工具腳本![Mark Ku]()
用Power shell 安裝 Docker with chocolatey 為什麼要用 chocolatey Chocolatey…
June 03, 2021
1 min
用 Power shell 跳窗指定複製的資料夾![Mark Ku]()
用 Power shell 跳窗指定複製的資料夾 問題 目在開發階段，不同網站的樣式 ( Theme )資料夾，經常需要手動覆蓋，用Powershell 將其自動化。 作法 複製採用 windows…
May 03, 2021
1 min
優化開發流程系列，再也不用人工撰寫 Release Notes，本篇用Powershell 搭配 git log![Mark Ku]()
優化開發流程系列，再也不用人工撰寫 Release Notes，本篇用Powershell 及 git log…
April 15, 2021
1 min
用Qnap Nas 的 Container Station 架設自己的 Jekyll Markdown Blog![Mark Ku]()
用Qnap Nas Container Station 架設自己的 Jekyll Markdown Blog 問題 現行團隊中每個人都有自己的Markdown…
April 14, 2021
1 min
Nuget CLI 常用指令![Mark Ku]()
Nuget CLI 常用指令 自動化更新nuget 將目前專案檔的 nuget 還原 nuget restore Build.sln 將目 Nuget update 到Nuget 網站下載nuget…
April 14, 2021
1 min
SameSite Issue![Mark Ku]()
關於SameSite Cookie Issue 起緣 因為GDPR法規關係，各大瀏覽器會限縮網頁的第三方網站，去寫入Cookie，對使用者進行廣告追蹤，
而我們的產品端常常會被客戶鑲嵌(iframe…
December 21, 2020
1 min
防範WebShell Attack![Mark Ku]()
資安問題處理 在調查某次資安的事件中，發現駭客在伺服器留下了後門腳本，網站的js也被竄改過，導到假的flash 網站，經調查，我懷疑遭到Web shell attack。 什麼是Web shell…
December 21, 2020
1 min
文章分類
Tags
百岳玉山interviewResourcesJekyllnugetrelease notes powershellironman kentingtriathlon 70.3鐵人三項三鐵opendialogrobocopypowershellfrpfrp-creverse proxychocolateydockerwindowsaspnetwebsiteautomateddatabasedeploymentsqlmulti-sitedatabase-deploymentnet-coredocker-containeri18n語系檔googlesheet直播streamingwebp converterseo googlevueintellisensessr prerenderdynamicrender Rendertronstylelintscssloadingvuexfrontend-large-data-renderingsvgsvg-spritenodeJscliWebpackplugin Vscode 除錯 debugger 筆記Couldflarecdnstylelintdowngradeuptime-kumanode jsUptime Robottelegram botmonitoring toolrenderseorendertroninobounceiOSbouncelottieJavascriptinteractiveAdobe After EffectAEAdobe AfterEffecttranslatechineseSimplifiedChineseconvertlog serverELKExceptionlessSeqSplunkqnapnlognet coresslcertbotContainer Station deploydeployedlinemessaginguptimekumanotifyyarpload balanceddospreventreal ipproxy protocolnginx-certbothttpsletsencryptraspberry pioslinuxmemory leakgameanimationrunweb site4Blabel-printerreceipt-printerironmanpnehu 226triathlonprepareexternal linkblackhatquerystringinjectpnehu226firstlastracingdayfacebooksmessagejsenhancechatsdkkeep alivecleardisposeincludelet encryptfreechallengeCertificateAuthorityCAgodaddycloudflarecicdgitlabpipelinerunnerdotnetauto buildautodeploygithubpageblogdnscachephotographya74A7M4α7IV微距鏡頭微物攝影微距攝影mongodbtoolsbackuprestoreverifyblockrolling updateReactget startresize imageImageflowquery commandgetLearn ReactNextimage loaderimagetoo bigdevinitenvenviormentfiddlernetwowrkrecordApple PayCybersourceintegrateFontendNET MVCusaecommercenoteinsuranceUSAsignifydcreditauthorizecapturega4analysistagmangergtmintegrationsearch keywordheadlesscmsstrapiswaggerfaqGoogle Paytrendselfquicklybuildbindingnon-wwwvercelbindalwaysnullredisautomatically syncs redisDDoSfridayperiodthanksgivingupgradeplaywrightVscodeGithub actionend to end testjenkinsManagementcareerdevelopermiddle3Dagileabandonmentcartabandoned cartJestbankers-roundingclarityheatmapssession recordingsAmazon payAmazon pay v2reactapp routeremote buildincrease websit trafficmanual deploymentbinary comparedocker image buildDocker Desktopgithub sshsalesholidayhyte y40gaming海景機殼機箱career development互惠互利雙贏project managercareer bundry邊界職場abnormal-leave-request海外自助單車旅遊嘉明湖wiki.jsknowledge base systemRustDeskremote toolteam-viewertailwindboostrapECommercediscover-and-optimize-high-value-pageswebsite-trafficThree.js3d3d-showroomnext jsnexthelping each otherteam workMariaDBmysqlWake on lanwol-go-webwolBlack fridayleadbingtrustperformancenginxftp serversftpgomilitary-salesinsight-vietnam-ecommerceenhancing the search experienceworking-from-home-rulesecurityPaymentPaypalcheckoutKuberneteswidnowsAmazonAb testFeatureprobeemployee benefits and fairteam ruleai-english-assistanttalk-about-promotioncommunication-deadlockgenerate-seo-metadata-by-azure-aiaicomputexai pcyour-dream-standing-tablequiet-quittingbuild-your-own-low-code-cmsspecial-technical-problemsOllamamindsetestimatewbstimetableset-up-llama-factory-enviormentllama factoryTrade offCBOAlanguage schoolfine-tunee-commerce-and-real-storellamalangchainiiiclassmate reunionqdrantnestoautharchitecture-designgermanye-commerceconcurrency-websiteUbuntuDockerGoogle CloudArtifact RegistryGCPkubernetesGKEgoogle kubernetes engineubuntudocker registryingressIngressGoogle Kubernetes EngineCI/CDJenkinsNext.jsAutomationDocker MonitoringcAdvisorPrometheusGrafanaContainer MonitoringResource UsageCloud NativeVisualizationServer MetricsOpen Source ToolsDevOpsObservabilityMetrics CollectionDashboardMonitoringNginxCloudPerformance TestingK6MetricsOpenVPNVPNNetwork ConfigurationLinuxSystemdreviewingtasksmanagementmarkkuexperienceremote accessMetrics ServerCluster ManagementResource MonitoringKubernetes MetricsInfrastructureSambaWindowsFile SharingMSSQLCloudflareUFWsystemicproblemacceleratingcollaborationwiresharkwormwhy-learn-englishgdprconsent-moderoosterbaguiocam-john-haypineslearningtravelingviganunescoheritagephilippinespines academystudy abroadfunny roommatesenglishspeakingsan-juan-surf-tripurbiztondo-beach-guidesan-juan-travel-notesmy-first-surfing-tripbaguio-to-san-juanenglish-learning-journeypractical-english-skillsself-improvementcommunication-skillsstudy-abroad-tipscareer-developmentbanaue-travelsagada-tripenglish-through-experiencelearning-outside-classroomrice-terracestravel-journalmotion-sickness-survivorlanguage-learning-adventurescultural-discoveryagentmcpoutlinekongapi gatewayrate limitingplugin developmentluacustom pluginOpenRestyKongAPI Gateway除錯oracle cloud免費雲端frpsrest api架站雲端主機vmLuaVSCodeEmmyLuaAPISIXetcdRate LimitingUptime KumaRESTful API監控省錢Rocket.ChatOmnichannelMulti-ChannelLivechatCustomer ServiceMongoDBAICodingDevelopmentVibe CodingSoftware EngineeringProductivity