Tom Swartz: Tuning Your Postgres Database for High Write Loads from Planet PostgreSQL
As a database grows and scales up from a proof of concept to a full-fledged...
Bruce Momjian: Thirty Years of Continuous PostgreSQL Development from Planet PostgreSQL
I did an interview with EDB recently, and a
blog post based on that interview was published yesterday.
It covers the Postgres 13 feature set and...
Hans-Juergen Schoenig: pg_squeeze: Optimizing PostgreSQL storage from Planet PostgreSQL
Is your database growing at a rapid rate? Does your database system slow down all the time? And maybe you have trouble understanding why...
rob sullivan: Using pg_repack in AWS RDS from Planet PostgreSQL
As your database keeps growing, there is a good chance you're going to have to address database bloat.
While Postgres 13 has launched with some...
Jonathan Katz: PostgreSQL Monitoring for App Developers: Alerts & Troubleshooting from Planet PostgreSQL
We've seen an example of how to set up PostgreSQL monitoring in Kubernetes. We've looked...
Daily Coping 28 Oct 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Azure Databricks and Azure Key Vault from Blog Posts – SQLServerCentral
The key vault should always be a core component of your Azure design because we can store keys, secrets, certicates thus abstract / hide...
Using Write-Debug from Blog Posts – SQLServerCentral
I wrote a post about PoSh output recently, noting that in general we ought to use Write-Output or Write-Verbose for messaging. In there, I...
T-SQL Tuesday Retrospective #002: A Puzzling Situation from Blog Posts – SQLServerCentral
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we were asked one of three options, and I elected to...
DAX Logic and Blanks from Blog Posts – SQLServerCentral
A while back I was chatting with Shannon Lindsay on Twitter. She shares lots of useful Power BI tips there. She shared her syntax...
Must Read in Cloud & Networking
Top life hacks for prepping for your IT certification exam
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed up for a class that lasted one week, per...
Must Read in Data
Learn Transformers for Natural Language Processing with Denis Rothman
Key takeaways
The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today.
Artificial intelligence is...
