Databases – Practical PostgreSQL – The pg_hba.conf file
Databases – Practical PostgreSQL – The pg_hba.conf file
I recently had a job to do in which I was required to connect to a Postgresql server and run some queries to find some critical data for the team. I wasn’t provided with a logon or any other information about the tables or schema.
Well thank goodness for my old friend google or I wouldn’t have stood a chance against this problem.
What I learned is that without some modifications to a conf file, you will never, ever connect to a database remotely. You may have success connecting from the command line and might be wondering why you can login to the postgres console, but the exact same creds are failing constantly when trying to connect any other way.
Turns out remote connections require the connection mode to be set to ident or trust to either identify or allow the connection based on the user connection manner and credentials used. Without this knowledge you can easily spend a lot of time troubleshooting something that is actually very straight forward.
I didn’t completely understand the issue until I actually setup and installed Postgresql for myself on my vmware homelab.
These two sources were indispensable in my training:
Once I actually set everything up for myself the first it all made a lot more sense. I was able to try all the different scenarios without the fear of breaking production. All in all this was a great learning experience.
These articles are for setting up Postgresql on Centos 7 but there are many other articles out there with similar information for debian or earlier releases.
So get up in them guts and have a poke. I hope you go mildly insane with your new found sql query power.
Programmatic Helps Brands Make the Most of Micro-Moments – Think with Google
It’s hard to plan for nonlinear purchase paths, but programmatic advertising can help, enabling brands to reach the right person with the right message in the moment of opportunity. Brands can use programmatic to assemble a consumer’s micro-moments in just the right way—like joining puzzle pieces together—to see a detailed blueprint of consumer intent
83% of all display buys will be programmatic by 2017. That’s what Google has to say about programmatic on their google+ page. What that tells me is that if you’re not able to harness the power of the tools to deliver relevancy then you might as well not even bother.
The proliferation of devices means that people are connecting their experience across tabs, workstations and devices while on the way to the store to buy the product in person. This makes the marketers job so much more difficult when trying to understand the patterns of their buyers. Fortunately Google has mostly solved the problem for you.
Some say programmatic is the death of creative. I liken it to the death of folk music. The music never died, just it’s audience. It just means creatives have to be.. well …more creative. For those who are inclined to set and forget their campaigns, they will find that Google does a very decent job of managing the interactions for them. However those that are accustomed to squeaking into the first page with lower scores will always be obliterated by those who can generate killer ad copy.
Good luck on your programmatic journey. Please let me know what tips and tricks you’ve discovered that make or break your campaigns.
Google AdWords Essential Training | Lynda.com
Download the Lynda.com app to enjoy on-the-go learning.
This is a quick follow-up to the article I posted recently about the Top 100 Most Expensive Search keywords of 2015. In this article I commented on the total lack of willingness most Adwords marketers have for optimization which can result in a lot of waste and very poor ROI. Yes we want the clicks, but we want the right clicks.
I was really impressed by the candor Brad Basteole used in discussing how to do the job well. I think it’s very important to note that although all the topics of the Adwords certification were covered, it’s incredibly valuable to learn this from an outside perspective other than Google.
So if you’re trying to pass an exam, or just want to be better at your Adwords marketing job, I highly recommend you check these videos out.
Google’s Top 100 Most Expensive Keywords in 2015 [Infographic]
Out of necessity I’ve recently had to learn more about how the google search ranking and pay per click auction works. What I’ve learned, and it’s fairly alarming, that due to knowledge gaps and in some cases greed, most search marketers waste a lot of money. Being clever about keyword refinement and targeting, as well as optimizing for quality score can drastically drop cost per click by 200-300% on average. The savings reinvested into more clicks has an incredible compounding effect. When I learned that most marketers are happy to just generate traffic, aka spend click budgets, I really couldn’t believe it. So I looked a little deeper into it and what I found is that there is absolutely no incentive for marketing agencies to put any effort into optimizing. The industry benchmarks for click through and quality score is so abysmal that any minimal effort returns fairly decent results so everything is perceived as successful. PPC generates leads so marketing budgets are happily renewed. Everyone spends so much time patting themselves on the back that no one ever bothers to take a closer look. $2 clicks could easily be $.50 with just a few tiny tweaks. Theoretically that’s 400% improvement in revenue generating leads completely wasted. In truth the whole industry is set to be turned on it’s head. Now that google has dropped the right margin ads, the top 4 spot will become incredibly in-demand. If you aren’t taking great care to refine campaigns with extreme target prejudice then you better be prepared to drop a bank on buying pointless clicks.
The modules are pretty short. Usually around 20 minutes and nothing over 30. The presenters are some of the best in the field and are celebrities if you follow certain circles.
I had no idea that all apps built for the Microsoft Store will use these simple languages. I’m not necessarily a big MS fanboy, but you can see why they are so successfully in their strategy. They empower the workforce to use their tools and win market dominance because of it.
I had fun.
Microsoft also offers a complete beginner’s course here:
And an advanced app store course here:
Learn to code | Codecademy
Learn to code interactively, for free.
Source: Learn to code | Codecademy
A few years ago Lifehacker had a “coding bootcamp” series that would frequently refer their audience to codeacademy and I always had it in the back of my mind that If I needed some coding skills, that would be the first place I turn. Well as luck turns even after 15 years of solid IT admin/engineer experience I’m finding my skills becoming obsolete and I absolutely do need to learn how to code in order to work with the modern DevOps toolkits like Puppet and Chef.
The cool thing about codeacademy is the learning interface. It splits the screen in two with one half showing you the instructions like a cookbook and the other half showing you the terminal or browser output. It’s very similar to working in a development environment where you can split your screen to see the interpreter and output at the same time. The flow is so smooth because the errors they’ve coded are way more intuitive that what you’d see in your interpreter. So you’re constantly learning from the error instead of trying to avoid them at all cost.
They also make learning fun by awarding you with badges for achievements like completing a module or logging in for a 3 day streak. It’s all very fun an encouraging and not intrusive at all. It’s actually quite addictive.
I can’t say enough good things. I now have around 80 examples of sites I’ve coded in my github here. I intend to use this as my portfolio to get a job. I encourage everyone to give it a try and you may find a new talent that was hidden away. Please let me know if you have any recommendations for languages or tools I should learn next. Have fun!
List of Google Now voice commands
Google Now can do tons of great stuff using nothing but voice commands. The list is more longer than you might think!
Google Now isn’t new but the feature is getting more rich all the time. That’s because it’s learning.
The learning computer has been the dream and destination since Charles Babbage and Ada Lovelace worked together on their invention the Analytical Engine computational device which is the first ancestor to the modern computer. Even in the early infancy the two debated voraciously if the device they invented which only performed the computations they programmed, could one day learn on it’s own and be interacted as though it were not a machine.
Alan Turing knew of this philosophical debate and created a test known as the Turing test which consisted of three questions for being able to tell the difference between a response of a human being from that of a computer. Turing is an incredible man worth study and recently the topic of the movie “The Imitation Game” which chronicled his work on the Enigma machine which he designed to crack the cipher being used by the German’s in World War II. He was able to foresee the power of computers and knew how easily they could be programmed to deceive as much as find truths.
This fantasy which seems like it’s part of a science-fiction novel is incredibly real. Jarvis from Iron Man is here and it’s call Google Now. Apple came out with Siri a few years back and people had a lot of fun at parties showing off the tricks they’d learned to make Siri perform.
Google Now is backed by the Google search algorithms which makes it a little different. Unlike Apple who’s core business is hardware, Google’s core business is about knowing you. They are inventing artificial intelligence that does a better job of demonstrating empathy than an actual human being is capable of doing. Coupled with Moore’s law, the Google AI is expected to be smarter than the smartest man in just a few years. Meaning we indeed will no longer be able to tell the difference between a computer that needed us to program them, and one that does not.
So Google Now may seem like a novelty, and for now it’s function is limited to that which the programmers allow. Rest assured, while we’re “playing” and “trying” Google is learning and their destination is clear. They are making the technology we really need; the technology that doesn’t need us.
Can a computer really think on it’s own? Or are some problems only built for the human brain, no matter how much computational brute force you can throw at it?
Manifesto for Agile Software Development
We are uncovering better ways of developing software by doing it and helping others do it. These are our values and principles.
As a 15 year IT professional I’ve had the great pleasure of encountering many technologies and aspects of the industry. My work is a great joy to me.
It wasn’t always that way and I think many people feel the same way. When we first entered the working world we were just relieved to have employment. We never dreamed a whole entire organization of mature employees could ever grow to depend on someone so inconsequential as ourselves. In other words, we had no idea how to make an impact.
Fast forward a few years and some trends in the IT industry have really shifted the paradigms. IT is a core competency of the business. Even if you think your business has nothing to do with technology, chances are computers still run everything behind the scenes. Use a mobile smart phone? thoughts so 🙂
This means that we technical people go to work everyday knowing we’re absolutely relied upon to help make the business operation run smoothly.
Does that mean we’re actually achieving anything to help move the business forward?
The answer is, all the firefighting and back slapping we do most often does nothing to advance the strategic mission.
What’s the mission?
If the mission is to make money and turn a profit, then I’m sorry to say but most of my peers have failed in in this test. They’ve come to equate being busy with being important. Their bosses however, continue to recognize and reward them for the late nights and quip “Couldn’t have done it without ya!”
Well chances are the late nights are caused by the IT pros to begin with because they work in silos and concoct monstrous apps and environments that don’t play nicely and outsiders don’t stand a chance of understanding to troubleshoot. Is this what success looks like?
More recently the concept of DevOps which links the notion of throughput (think automotive manufacturing) has made IT professionals reconsider their importance and value to the firm.
We hear it all the time now. Unplanned is the enemy of planned. IT pros shouldn’t be going to work to fix what’s broken. They should have built in security, self-healing and fault tolerance so their time is spent advancing the business mandates instead of attending to unplanned emergencies.
Technologies and frameworks like Cloud and Agile are paving the way for a true DevOps revolution and it may leave many the legacy IT pros wondering where their industry has gone. Chances are all their friends went into other strategic and operations roles that didn’t have the word Microsoft, Cisco, admin or engineer in the title. The people who know how to truly use tech do so as a tool to help them run their companies, not just run the rest of the tech.
The Agile manifesto is one the biggest pieces of this puzzle. It addresses a fundamental psychology flaw in IT pros, the problem always resides with the user. “So and so broke such and such”. Agile shifts the focus directly on the needs of the user (user story) to create the perfect products for them. It relies on self-organizing cross functional teams to be creative and provide the next solutions with greatest business value.
If you have the discipline to apply the principal (ie: don’t fill idle time with clandestine project) then you can’t help but put down your tools and get connected with the business before you pick the tools up again.
The main take away is I see IT pros doing as much harm as they do good. If they would apply the Agile Manifesto to their career they would never had the problem of feeling disconnected from the business ever again.
As my dad ALWAYS says, “If you’ve dug yourself into a hole, put down the shovel.”
Here’s a Tesla in Autopilot mode zipping in and out of NYC traffic – KnowTechie
Remember as kids when we used to dream of cars that drove themselves? Well, we all know it’s already happening with Google’s self driving car. But Tesla is going to blow your mind because they recently
This is very exciting to me. I’ve been paying attention to Elon Musk for many years as someone who personifies the exponential thinking manifesto. The Tesla is a beautifully designed piece of engineering and I want, I want.
After seeing this video I now want a Tesla even more.
The most recent over-the-air update has added driver-less capabilities to the already extremely cutting edge vehicle. This puts the Tesla years ahead of any of the other makers in terms of innovation.
I think I may be waiting a while for the over-the-air driver-less update for my truck.
Solving the world’s transportation and supply chain challenges with alternative energy solutions may sound like geek talk. The sheer delight in this driver’s expression demonstrates you don’t have to be a scientist or engineer to understand the future is going to be a fun place.
The future is happening right… …now!
BOLD: Peter Diamandis
Source: BOLD: Peter Diamandis
This is the book where I encountered exponential thinking.
What is exponential thinking?
Well… It isn’t linear thinking. It doesn’t seek the solve the next increment one user at a time.
Exponential thinking is about creating wealth and abundance by harnessing rapidly expanding technology to solve a problem plaguing a continent or better, the entire planet.
This book gives some great prescriptive advice about navigating this golden age we’re experiencing today. It covers topics like the Internet of things and crowd-sourcing seed investment for your idea.
The opportunities are ever present for anyone creative who can synthesize and converge seemingly unrelated concepts.
Go big or go home as they say.