Infrastructure at your Service

Category

Database Administration & Monitoring

Microsoft Team

SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios

By | Database Administration & Monitoring, Development & Performance | 6 Comments

Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about data oldest than 2 years. Usually in this case, I use a method that consists in dropping data by switching first the oldest partition to a staging table and then truncate it. Finally we may…

Read More
Daniel Westermann

Fun with PL/SQL code reviews – Part 1

By | Database Administration & Monitoring | One Comment

For quite a long time I did not work anymore with PL/SQL and was quite happy when I had the chance to review some code at a customer. The status today: I am not that happy anymore 🙁 Let me explain why and show you some examples on what was discovered. Of course all of the identifiers have been obfuscated and this is not to blame anyone. It is more to make people aware of…

Read More
Daniel Westermann

How to patch Postgres Plus Advanced Server

By | Database Administration & Monitoring | 2 Comments

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no 🙂 The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This is pretty much the same as with My Oracle Support where you need a customer support identifier mapped to your…

Read More
Oracle Team

Oracle 12c and RMAN switch datafile to copy, is it really so easy?

By | Database Administration & Monitoring | 2 Comments

By William Sescu Oracle incrementally updating backups are used quite often because they are easy to setup and restoring a datafile is very fast. It is very fast because you are not really restoring a datafile, you are switching to the copy, in case something happens. But how do I switch back to the original destination with minimal downtime and with minimal impact on the system? A quite common scenario is that we have 3…

Read More
Oracle Team

Oracle 12c and RMAN automatic datafile creation

By | Database Administration & Monitoring | No Comments

By William Sescu A lot of new features popped up with RMAN 12c, like  Expansion of Multi-section support, or Simplified cross-platform migration and many many more. However, in this post I would like to highlight a small, but very helpful new feature which I demonstrated during my session at the SOUG day. The automatic datafile creation In earlier versions of Oracle, you might run into situations where you create a new tablespace, and some objects…

Read More
Daniel Westermann

Running PostgreSQL on ZFS on Linux

By | Database Administration & Monitoring | No Comments

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement for ZFS being production ready was back in 2013. So why not run PostgreSQL on it? ZFS provides many cool features including compression, snapshots and build in volume management. Lets give it a try and do an initial setup. More details will follow in…

Read More
Daniel Westermann

Connecting your PostgreSQL instance to an Oracle database – Debian version

By | Database Administration & Monitoring | One Comment

Some time ago I blogged about attaching your PostgreSQL instance to an Oracle database by using the oracle_fdw foreign data wrapper. This resulted in a comment which is the reason for this post: Doing the same with a Debian system where you can not use the rpm versions of the Oracle Instant Client (at least not directly). Lets go …

Read More