Cheat Code https://decoder.link/sslchecker So we migrate our WordPress to Azure Web Service. After configuring the usual stun we want to enable SSL for our URL.We purchase our SSL from NameCheap after all those steps like creating CRS and stuff we manage to get the cert approved.But we want to ensure that all is great andContinue reading “Checking if SSL Cert is properly Configured”
Category Archives: Uncategorized
Using CURL to get Microsoft Graph API
Cheat Codecurl -v -X GET -H “Authorization: Bearer ey[removed]” -H “Content-Type: application/json” https://graph.microsoft.com:443/v1.0/users?$filter=startswith(displayName,’someone’) –trace-time -v So I have web API hosted in Azure App Service which returning a result from Microsoft Graph API about some user. This API is somehow bloody slow… it took almost 8 seconds to return result.I’m puzzled! I want to knowContinue reading “Using CURL to get Microsoft Graph API”
Digging the .ETL file – network packets file for TCP connection
Cheat CodeTCP.port==1433 So we have .ETL file from previous netsh session, what can we do with it?I installed Microsoft Network Monitor 3.4 (download here) – Microsoft why Archive such amazing tool!? 😦 –Once it’s installed I launch itThen the usual File -> Open -> Capture… and select the .etl fileSet the “Parser Profile” Once that’sContinue reading “Digging the .ETL file – network packets file for TCP connection”
Journey to uncover hidden Logic on StoredProc
Cheat CodeApexSQL Analyze I’m working with amazing data warehouse project where all ETL is done in Stored Procedure and being documented in WORD document! It’s just 7MB and 194 pages, good reading material for couple of hours flight, hope I don’t fall a sleep… My objective here is to get the dependency between tables (oh,Continue reading “Journey to uncover hidden Logic on StoredProc”
Capture Network Packet without Wireshark
Cheat Code> netsh trace start persistent=yes capture=yes tracefile=c:\temp\capture.etl > netsh trace stop There are too many time we need to troubleshoot issue all the way to network level.Unable to connect, strange application error, etc.Nothing beats the capturing network packets to know at the lowest level.Use the above cheat code to capture the packet for analysis.NextContinue reading “Capture Network Packet without Wireshark”
Refresh Hive Partition
Cheat CodeMSCK REPAIR TABLE mydatabase.table_name We added partitions to our external table to manage our data easily. Multiple folders are set on our data lake.How can we refresh the hive to know new partitions are added? Quite Simple! run the cheat code above and voila the hive partition is updated!don’t worry it wont messed upContinue reading “Refresh Hive Partition”
My IT Cheat Code 