Log Buffer #529: A Carnival of the Vanities for DBAs

Posted in: Log Buffer, Technical Track

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).

email

Interested in working with Fahd? Schedule a tech call.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *