Cheat CodeTransferwise.com Just another non IT cheat here… I’ve been sending money to support my family member and over years I’ve tried various remittance services. From super bloody fee sucking banking backed service, to super annoying P2P transfer. It revolves around either reliable but super expensive fees with bad exchange rate, on the extreme endContinue reading “Send money overseas with cheaper fees!”
Author Archives: Feivel
Azure SQL – Super fast string wildcard search with pagination
Cheat CodeIndex on column Today mission is to allow user to run super fast query on Azure SQL table.Not any kind of query, it’s a string search query… something like: The table is not too big, just 80 Millions rows (that’s freaking big actually).Why the query written that way is beyond this post (we needContinue reading “Azure SQL – Super fast string wildcard search with pagination”
Cheating Financial – RoboAdvisor!
Cheat Codesyfe.com I don’t usually like to expose my personal financial journey.but I’m trying to cheat here… not in bad way… So as many of you know, I’m super busy everyday with my IT life. While I have some sort of investment all over the place, I keep hearing about RoboAdvisory from various sources, Web,Continue reading “Cheating Financial – RoboAdvisor!”
Linux – List Folder Size, sort it, and display in human readable format
Cheat Code du -h | sort -hr As usual something disturbing my lovely day.There’s a notification sent to my usually empty mailbox.And it said “Low Disk Space” on one of my Linux server named “LOVELY”. Then I think “That’s no way it can happen… I shower the server with lots of LOVE”, sigh…Okay time toContinue reading “Linux – List Folder Size, sort it, and display in human readable format”
Azure Bastion – How to Change Password/Send CTRL+ALT+DEL
Cheat CodePress CTRL+ALT+END Another day another story.We are using Azure Bastion to access our Windows VM, it’s a super cool service! Allowing users to RDP to VM without needing to open 3389 on firewall. And as of now like the rest of the world, most people are working from home. I don’t mind to getContinue reading “Azure Bastion – How to Change Password/Send CTRL+ALT+DEL”
Azure SQL – Where the heck is SQL Profiling?
Cheat Code (this is combo cheat, so pay attention!)> Azure SQL Audit + Blog Storage + XEL File + SSMS! I’m puzzled, cursing, banging my head, almost throw my laptop (lucky I didn’t do that, so bloody expensive if I did that – My company charge full laptop replacement to our paycheck if we brokeContinue reading “Azure SQL – Where the heck is SQL Profiling?”
Python – Read PyODBC to Pandas Data Frame
Cheat Code Another day another Python learning.Today I tried to read the table from Hive which connected using PyODBC into Pandas Data Frame.The idea is, once data available on Pandas Data Frame, I can run my queries and run my exploratory. Python FTW!
pyodbc – Connecting to HDInsight
So…. recently I’m exploring Python as it’s COOL!What other reason you need to learn new things except that when it’s COOL! Anyhow, I want to try to compare data between my HDInsight Hive External Table vs CSV using Python.Because I can, so why not 🙂 First challenge in this journey is how the heck canContinue reading “pyodbc – Connecting to HDInsight”
Windows 10 – Start menu search not working
Cheat CodeREG ADD HKCU\Software\Microsoft\Windows\CurrentVersion\Search /v BingSearchEnabled /t REG_DWORD /d 0 REG ADD HKCU\Software\Microsoft\Windows\CurrentVersion\Search /v CortanaConsent /t REG_DWORD /d 0 tskill searchui Another blunder of Microsoft… My laptop start menu search function was stop working, I can’t search anything using the box.Apparently according to the article it’s due to Bing integration (Thanks Microsoft for giving meContinue reading “Windows 10 – Start menu search not working”
User can’t connect to hive with Kerberos because of http header size too big
Cheat CodeAmbari-> Hive -> Custom hiveserver2-site hive.server2.thrift.http.request.header.size=65536 hive.server2.thrift.http.response.header.size=65536 Our Azure HDInsight is secured with Enterprise Service Package/ESP (a fancy name saying the cluster is join domain to AD for authentication). Some of the users said they are having difficulties trying to logon from their beloved, most powerful, most flexible BI tool – Excel. After troubleshootingContinue reading “User can’t connect to hive with Kerberos because of http header size too big”
My IT Cheat Code 