#PGSQLPhriday 006: What I Wish I Knew While Learning PostgreSQL

PostgreSQL
Well, for those who don't know me, I'm just barely started on my PostgreSQL journey. So, what the heck can I contribute to this conversation? Not much, but I do have one tip. It's about the official documentation and search engines. YaDuBiGo When you use Yahoo, DuckDuckGo, Bing, Google, or whatever search engine you use, what you don't get is a simple, "here are the pages you asked for". All the search engines use various mechanisms to surface you "here's the BEST and MOST POPULAR pages you asked for." What defines best in these circumstances? Most accurate? Maybe, maybe not. I've never worked for one of these organizations and they tend to keep their algorithms to themselves, for obvious reasons, both good & evil. However, I do know one thing…
Read More

“Applies To…” in the MSDN Documentation

Azure, SQL Server 2016, T-SQL
Quick little post. I just wanted to share how happy I am with the new "THIS TOPIC APPLIES TO" infographic. An example here: I think it makes things much more clear when you're attempting to figure out what's up with some T-SQL syntax. Well done Microsoft and thank you. Side note, this only exists in documentation that has been updated recently. I first saw it in some documentation that was updated January 11, 2016. It's not there in another piece of documentation I saw that was updated October 15, 2015. Here's hoping it gets put everywhere. It works.
Read More