Jul 01 2020
I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database?
There are two different parameterization options that one can use in SQL Server. Simple parameterization and Forced parameterization. Let’s discuss each one in a little more detail. Continue reading
Jul 01 2020
My company uses a vendor purchased application to process orders. Lately, one of the vendor’s application queries has been running very slowly and is starting to cause problems. My testing has determined that the SQL statement can benefit from a query hint. Is there a way I can apply this query hint though I don’t have access to the vendor’s application code? Continue reading
Jun 05 2020
A new day started from ORA-28002 The Password Will Expire in 7 Days message from an Oracle DB.
Let’s dig a bit how can we avoid this situation and manage our Oracle DB passwords. Continue reading
Jun 04 2020
Suddenly “Error during SonarQube Scanner execution” began to appear during at the end of Jenkins build. The full text in Jenkins console output looks like this:
|
1 2 3 4 5 6 7 8 9 |
ERROR: Error during SonarQube Scanner execution ERROR: Unable to load component class org.sonar.scanner.bootstrap.ScannerPluginInstaller ERROR: Caused by: Unable to load component class org.sonar.home.cache.FileCache ERROR: Caused by: Unable to load component class org.sonar.scanner.bootstrap.GlobalConfiguration ERROR: Caused by: Error 500 on http://10.10.10.10:9000/api/settings/values.protobuf : {"errors":[{"msg":"An error has occurred. Please contact your administrator"}]} ERROR: ERROR: Re-run SonarQube Scanner using the -X switch to enable full debug logging. ERROR: SonarQube scanner exited with non-zero code: 1 Finished: FAILURE |
May 26 2020
Default LVM partitioning in Linux may not be optimal for some tasks. For example, root partition can be too small and filled up after some time while home partition is large and almost unused. In this case one obviously would want to transfer some amount of space from /home to / partitions.
Consider the following example: Continue reading
May 07 2020
GRUB (Grand Unified Bootloader) is the most widely used bootloader among Linux operating systems (OS) but it can boot any OS.
GRUB main functionality is to allow users to select between different operating systems to boot. As bootloader GRUB is installed on the MBR (Master Boot Record) and additionally to allow us to select different OS it also allows us to select between different kernel or kernel parameters and to boot in rescue mode if our kernel was damaged or if we lost our root password as explained in a previous article in which on how to restore CentOS root password editing GRUB’s booting parameters. Continue reading
May 07 2020
A situation where the system has no kernel to boot from maybe because all the kernel are removed from the system or due to a corruption, Kernel installation from rescue mode is required. You can still install a new kernel from rescue mode and make the system up and be running again. Continue reading
May 06 2020
This post covers how to list and extract the contents of a Debian package. There will be examples used to show how to list the contents of debian packages that are installed and not-installed on a system, as well as, how to extract the debian control information and program files.
A debian package is a Unix ar archive that includes two tar archives: one containing the control information and another with the program data to be installed. Continue reading
May 06 2020
This article will cover basics of the RPM package architecture and show how we can see RPM package content and extract it. There will be examples how to extract RPM package files from Linux command line.
An RPM package is simply a header structure on top of a CPIO archive. The package itself is comprised of four sections: a header with a leading identifier (magic number) that identifies the file as an RPM package, a signature to verify the integrity of the package, the header or ‘tagged’ data containing package information, version numbers, and copyright messaging, and the archive containing the actual program files.
Apr 27 2020
There is a SQL Server Availability Group (AG) on a Windows Server Failover Cluster (WSFC) with 3 nodes using Node Majority quorum configuration. In an unforeseen circumstance, 2 nodes went completely offline at the same time causing the WSFC to go down.
This caused the Availability Group to go into a Resolving state and all the databases in the AG and the AG Listener to be inaccessible. How to recover the WSFC cluster node to start without a quorum and later fully re-establish HA for AlwaysOn AG I’ll show below. Continue reading
