Database Administration & Monitoring The same MAC address for two interfaces on the same host? 27.03.2018 by Daniel Westermann Yes, sounds strange, but exactly this is what we faced today. In the end it is clear and not strange anymore but for a moment we really thought we are hitting a bug in the operating system, which was RedHat(…)
Database Administration & Monitoring ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4 27.02.2018 by David Hueber To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was(…)
Database Administration & Monitoring Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version 25.02.2018 by Daniel Westermann Almost every PostgreSQL I get in touch with is not configured to use huge pages, which is quite a surprise as it can give you a performance boost. Actually it is not the PostgreSQL instance you need(…)
Database Administration & Monitoring ODA 12.2.1.2.0 – VLAN Management 20.02.2018 by David Hueber Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and(…)
Database Administration & Monitoring My personal journey with Linux on the desktop 18.02.2018 by Daniel Westermann My Linux experience started back in 1999 when we needed a router for our ISDN connection in our shared apartment when we were students. I don't remember the hardware we used for that but I am sure at(…)
Database Administration & Monitoring SQL Server on Docker and network bridge considerations 14.02.2018 by Microsoft Team Let’s continue with this blog post series about SQL Server and Docker. A couple of days ago, I was in a customer shop that already implemented SQL Server 2017 on Linux as Docker containers. It was definitely a very interesting(…)
Database Administration & Monitoring Introducing SQL Server on Docker Swarm orchestration 02.02.2018 by Microsoft Team SQL Server 2017 is available on multiple platforms: Windows, Linux and Docker. The latter provides containerization features with no lengthy setup and special prerequisites before running your SQL Server databases which are probably the key success of adoption for developers.
Database Administration & Monitoring SQL Server on Linux and logging 19.01.2018 by Microsoft Team On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events(…)
Database Administration & Monitoring No journal messages available before the last reboot of your CentOS/RHEL system? 05.12.2017 by Daniel Westermann As you probably noticed RedHat as well as CentOS switched to systemd with version 7 of their operating system release. This also means that instead of looking at /var/log/messages you are supposed to use(…)
Database Administration & Monitoring Changing the LOCALE in CentOS/RedHat 7 06.10.2017 by Daniel Westermann What I really don't like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger(…)