OSX show used ports or listening applications with their PID
This post was originally published on this siteOn OSX you can display applications listening on a given port using the lsof the commands described below will show listening applications as well as the PID for each application lsof -nP -i4TCP | grep LISTEN lsof -nP…
Midsummer Midsomer SQL Winner
This post was originally published on this siteIn June I launched the Midsummer Midsomer Murder SQL Challenge and Book Competition. I promised to announce a winner within a week of the deadline – that was yesterday, so I’m afraid I’m one day late, sorry about…
Last Week in Stream Data Integration & Stream Analytics – 29.6.2020
This post was originally published on this site This is the 194th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations…
How to get the Data Guard broker configuration from a SQL query?
This post was originally published on this siteEverybody knows that you can get the Data Guard configuration in dgmgrl with the command: show configuration; but few know that this information is actually available in x$drc: SQL> desc x$drc Name Null? Type ————— ——– ————— ADDR…
Awk to format the files .ora (listener.ora, tnsnames.ora, etc)
This post was originally published on this siteTired of formatting the tnsnames.ora to make it more readable, I have taken the nice awk examples from Jeremy Schneider: https://ardentperf.com/2008/11/28/parsing-listenerora-with-awk-and-sed/ and created a function to format all files .ora (lisp-like config files). Example, before: $ cat tnsnames.ora…
Names Matter
This post was originally published on this siteThis is one of my favorite quotes: There are only two hard things in Computer Science: cache invalidation and naming things. — Phil Karlton IT is my daily live. And this quote is so true. Lately I’ve been…
Azure Tip 7: Bulk Deleting and Purging Azure Resource Groups
This post was originally published on this siteDuring the delivery of my Azure training sessions, I often end up with a lot of resource groups. Deleting many resource groups at once would be a good tool. Here are 3 solutions: Delete multiple resource groups with…
Last Week in Stream Data Integration & Stream Analytics – 17.6.2020
This post was originally published on this site This is the 193rd edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations…
Midsummer Midsomer Murder SQL Challenge and Book Competition
This post was originally published on this siteIt’s getting close to Midsummer, where in Denmark we traditionally burn witches on Saint John’s Eve. If we misspell it slightly to Midsomer, we have the Midsomer Murders series with loads of dead. So let’s have a little…
Social Media @trivadis