SQL Server to Elasticsearch using Logstash

 # MSSQL-ELK

Loading data from SQL Server to ELK stack

SQL Server AG primary database file movement

Script to get SSRS reports start and end time

MariaDB Galera Cluster on Centos 7

Duplicate document in Elasticsearch

Kubenertes for MongoDB on Azure

mssqlctl and mssql-tools error on ubuntu

When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools”

MSSQLCTL ERROR : written on pyton below are the steps to install.

1. Install the necessary Python packages:

sudo apt-get update && / sudo apt-get install -y python3 && / sudo apt-get install -y python3-pip

2. Upgrade pip3:

sudo -H pip3 install --upgrade pip

3. Install mssqlctl with the following command:

pip3 install -r https://private-repo.microsoft.com/python/ctp-2.3/mssqlctl/requirements.txt --user

MSSQL-TOOLS ERROR : 

1. Import the public repository GPG keys used by apt to authenticate packages from Microsoft.

2. Add Microsoft to the apt repository.

3. Update the apt-get.

4. Install the mssql-tools now.

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

sudo apt-get update

sudo apt-get install mssql-tools 

SQL Server on Kubernetes with Ubuntu OS

RabbitMQ delayed messages exchange plugin

Sql Server monitoring current status

Job to Auto start remote SQL Service if stopped in automatic mode

TDE Enabled Log shipped backup compression

SSRS installation failure on existing cluster node

Rule “Existing clustered or clustered-prepared instance” failed’ error while adding new features to an existing instance of SQL Server Failover Cluster

To overcome the cluster installation rule we need to perform a skip rule installation. below command is used to add feature of SSRS to the existing cluster node. This successfully installs reporting services on the node.

Setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /ACTION="install" /ERRORREPORTING=1 /UPDATEENABLED="False" /INSTANCENAME="MSSQLSERVER" /FEATURES="RS" /RSINSTALLMODE="DefaultNativeMode" /SQLSYSADMINACCOUNTS="xyz\mo.adil"