Infrastructure at your Service

Linux Archives - Blog dbi services

David Barbarin

SQL Server on Linux and logging

By | Database Administration & Monitoring | No Comments

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 that occur globally on the Windows operating system. Thus, regarding the encountered issues taking a look at such event logs – by using either the Windows event viewer or the Get-EventLog PowerShell cmdlet – may be very helpful to figure…

 
Read More
Daniel Westermann

No journal messages available before the last reboot of your CentOS/RHEL system?

By | Database Administration & Monitoring | No Comments

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 journcalctl to browse the messages of the operating system. One issue with that is that messages before the last reboot of your system will not be available, which is probably not want you want.  

 
Read More
Daniel Westermann

Changing the LOCALE in CentOS/RedHat 7

By | Database Administration & Monitoring | No Comments

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 cat: /proc/sysrq-trigger: Permiso denegado It is not that I don’t like French or Spanish but usually (well, not in that simple case) I am not able to translate that without the help from others. So…

 
Read More
Daniel Westermann

udev rules for ASM devices on RHEL 7

By | Database Administration & Monitoring | 2 Comments

Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this. As the order/naming of the devices in the device tree is not guaranteed (e.g. dm-1 is not guaranteed to be the same device after a reboot of the system) you need a way to fix this and that is what udev…

 
Read More
Daniel Westermann

Going from SLES12 SP2 to SLES12 SP3, online

By | Database Administration & Monitoring | 3 Comments

SLES 12 SP3 was released some time ago and as we have customers running on that I thought it might be a good idea to test the upgrade from SP2 to SP3. Actually it turned out this is quite easy and can be done online. The supported methods for doing this is either by using YaST or Zypper directly. As I wanted to stay on the command line I’ll use Zypper for the scope of…

 
Read More
Stéphane Savorgnano

SQL Server 2017 on RHEL first installation

By | Database Administration & Monitoring | No Comments

Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise Linux offer, more information here. It looked for me like the good time to do my first installation of SQL Server 2017 on Linux. My first concern was to download an ISO of the Red Hat Enterprise…

 
Read More
David Barbarin

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

By | Technology Survey | No Comments

#SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this kind of event would not be possible). As promised, here the slide deck of my session “Introduction to SQL Server on Linux for DBAs“. It was for me a great moment of sharing. Thanks to all!    

 
Read More
David Barbarin

SQL Server on Linux: Introduction to DBFS experimental tool

By | Database Administration & Monitoring, SQL Server | 2 Comments

A couple of months ago, Microsoft announced two additional command line tools for SQL Server that are mssql-scripter and DBFS. The latter has drawn my attention because it exposes live data from SQL Server DMVs as virtual files in a virtual directory on Linux operating system. Microsoft has probably taken another positive step in the SQL Server’s adoption on Linux. Indeed, in a Linux world, we may get Kernel’s performance and configuration data either directly…

 
Read More
David Barbarin

24 HOP French edition 2017 – Session videos are available

By | SQL Server, Technology Survey | No Comments

The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If you did not attend to this event, you now have the opportunity to watch the videos of the different sessions. From my side, I had the chance to present SQL Server and High Availability on Linux. Hope to…

 
Read More