This Log Buffer Edition covers Cloud, Oracle, SQL Server and PostgreSQL.
Cloud:
Dynamic pivot in Amazon Redshift. Don’t blame databases for disappointing you, blame yourself for expecting too much from them.
Cloud. Cloud. Cloud. It is everywhere. Certainly by now, we all understand the advantages of accessing subscription-based software or software-as-a-service. With no more software to license or hardware to own and less resources used, what’s not to love?
Can Your Business Survive and Thrive in the Digital Age?
Amazon ElastiCache Update – Online Resizing for Redis Clusters
New – AWS PrivateLink for AWS Services: Kinesis, Service Catalog, EC2 Systems Manager, Amazon EC2 APIs, and ELB APIs in your VPC
Monitor and manage your costs with Cloud Platform billing export to BigQuery
Oracle:
Easy(lazy) way to check which programs have properly configured FetchSize
Playing with RAC Voting Disks
SOASuite 12c: keep running instances using ANT
Extended Statistics und dynamic sampling
Regular database restore tests are important
SQL Server:
Vagrant and SQL Server 2017 on Linux
Dynamically Create Warehouse Dimensions
Historical CRUD and Application Business Events
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
PostgreSQL:
First of all, the most important latest news is the point release on November 9th with security and major bug fixes for all supported major
versions of PostgreSQL.
Who still has one of those big posters on the wall with all the Oracle catalog views? The practice of making them seems to date back decades and I still occasionally see them in people’s offices! So for a bit of nostalgia, check out this article by Alexey Lesovsky from Data
Egret. He packs a lot of information on PostgreSQL views and internals into one picture!
Speaking of Alexey, he has a second article from just a few weeks ago that’s worth highlighting: exploring PostgreSQL’s equivalent of
v$instance and v$lock. Pay close attention to pg_stat_activity in particular – this is the foundation of ASH-style wait event analytics
on PostgreSQL.
As long as we’re going deep, it’s worth reaching back in the archives a little bit and revisiting an older article written by Madusudanan
B.N from Zoho in Chennai. He gives an excellent and thorough treatment of caching in PostgreSQL.
Finally, lets mention two recent articles that go deep on specific types of indexes in PostgreSQL. Robert Haas from EnterpriseDB
discusses Hash Indexes and Sven Kunze from TBZ-PARIV writes about GIN indexes (with a little humorous discussion about RUM too).
No comments