Infrastructure at your Service

Category Archives: Database Administration & Monitoring

David Barbarin

SQL Server 2016: new database-scoped configuration parameters

By | Database Administration & Monitoring | No Comments

Do you remember new capabilities shipped with SQL Server 2016 CTP2 about tempdb? In this blog post, I talked about well-known trace flags 1117 and 1118 that become useless for tempdb because their related effects are automatically applied to tempdb. Another interesting news that comes from the new SQL Server 2016 RC0 is the use of new database-scoped parameters AUTOGROW_SINGLE_FILE / AUTOGROW_ALL_FILES as well as MIXED_PAGE_ALLOCATION that will replace respectively the effects of the 1117…

Read More
Oracle Team

RMAN 12c Push and Pull duplicate explained

By | Database Administration & Monitoring | 2 Comments

By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can do all the job. Let’s see how it works by comparing the RMAN log of the two methods.

Read More
Daniel Westermann

Getting started with Ansible – Preparations

By | Database Administration & Monitoring, Operation systems | No Comments

When your infrastructure landscape becomes larger and larger you definitely need a tool which helps you in managing your servers, no matter if pḧysical or virtual, running in the cloud or not. One tool (many others are around) which assists you in provisioning, configuration management and mass deployment is Ansible. If you look at the man page you can find this sentence: “Ansible is an extra-simple tool/framework/API for doing ‘remote things’ over SSH.”. What is…

Read More
Stéphane Savorgnano

Windows Containers: Migration

By | Database Administration & Monitoring | No Comments

In my last blog post (here), I explained how to configure a host for Windows Container as well as how to use some Windows Container cmdlets. Finally I demonstrated how to create a container with a SQL Server 2014 instance. In this blog post, I will continue by explaining how to migrate the container I just created. First of all, let’s remind the context: I have a Container named Test that runs on the top…

Read More
Oracle Team

12c Multitenant: PDB spfile parameters for standby database

By | Database Administration & Monitoring | 2 Comments

By Franck Pachot . In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason to get Active Data Guard option, you may want different optimizer settings suited for reporting. In non-CDB it’s easy: the standby has its own spfile where parameters can be changed. But for a pluggable database,…

Read More
Stéphane Savorgnano

Windows Container: installation and utilization

By | Database Administration & Monitoring | No Comments

Some weeks ago, I did a general presentation about Windows Server 2016 and the new Container feature (here). Today, I will go through the installation and utilization of Windows Containers. I will use a Virtual Machine, under Hyper-V, during this blog. First of all, I have to set the environment to be able to use Windows Containers as it requires the Container OS Base Images. Microsoft has prepared a script in order to configure a…

Read More
Stéphane Haby

SQL Server 2016: new upgrade advisor

By | Database Administration & Monitoring, Technology Survey | 2 Comments

I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package is 10 MB and is named SqlAdvisor. Run the msi and follow the steps like every time… After the installation, it is easy to search the upgrade advisor tool in the search bar Like all useful tools, you…

Read More
Daniel Westermann

Feeding blogs/rrs items directly into your PostgreSQL database

By | Database Administration & Monitoring | No Comments

There are many foreign data wrappers available for PostgreSQL. One of them can be used to query rss feeds. In this post I’ll show you how you can feed summary information of a blog into your PostgreSQL database. The foreign data wrapper you’ll need to download and install is called multicorn. This foreign data wrapper in fact brings more than a rss wrapper which is documented here. Installation is quite easy: postgres@oel7:/var/tmp/ [PG8] unzip multicorn-1.3.2.zip…

Read More