techzamin

Solution 1: Use the sp_removedbreplication stored procedure to remove all the replication objects on the publication and subscription databases. Make sure to change the database name “Test_db” with your database name. After executing the above T-SQL statement, you can remove your database. Solution 2: Create a database with the same name on another SQL server instance. Then create a full backup of the database. Now restore the database to this server forcefully....

This tutorial will help you to auto-renew Let’s Encrypt SSL certificates automatically. The certbot script will take care of certificate renewal before expiration. How to Renew Let’s Encrypt SSL Certbot command-line utility provides users the option to renew SSL certificates before expiration. Before running the actual renewal process, you can do a dry run to verify that certbot is working properly. Run the following command on the terminal to verify: On successful execution of the above command....

A number can be an integer number, a floating point number, or a positive/negative number that prefixes with a “+ and -” symbol. In this tutorial, we have discussed a few methods to verify that the variable contains only digits, integers, and double or float values, not alphabets. Using Equal Tilde (=~) Operator The regular expression is a quick and easy way for checking if a value is a number....

The default certbot stores all the client certificates under the below-mentioned directories. We are not recommending you delete files manually. In this tutorial, we will discuss deleting unused SSL certificates using the Certbot command line. /etc/letsencrypt/live /etc/letsencrypt/renewal /etc/letsencrypt/archive Delete a Let’s Encrypt SSL Certificate The Certbot also provides you an option to delete certificates automatically for you. To delete an SSL certificate, run the following command. This command will show you an index from which you can select the domain name to delete the associated certificate....

Method 1: Generate Random String with Custom function This is a custom function to generate a random string of a defined length. Using this you can limit the characters, and symbols to be used in the random string. Output: Method 2: Generate Random String Using uniqid() function The uniqid() function generate a Unique id based on the current time in microseconds. This function has a limitation, the result string has a fixed length of 13 characters....

The TigerVNC is a free, open-source and high-performance VNC server used to control or access Linux based desktop remotely. It is a client/server application that allows you to interact with graphical applications on remote machines. This tutorial help you to how to install and configure VNC server on Debian 10 Buster Linux system using the TigerVNC server. Prerequisites First, update and upgrade all installed packages on your system with the following command: Once your system is updated, follow the next instructions....

This tutorial will help you to install DHCP Server on Ubuntu, Debian, and LinuxMint systems. Step 1 – Install DHCP Server Debian based systems provides package ‘isc-dhcp-server’ for installing DHCP server. Open a terminal on your system and install DHCP using the following command. Step 2: Configure DHCP Server Follow the below steps to configure your DHCP server. 2.1 – Setup Interfaces to Listen First of all, edit /etc/default/isc-dhcp-server to specify the interface to listen by dhcpd....

Facebook is available as a web application as well as provides mobile applications like Android and iOS. You can easily find the mobile applications from the respective play store. But none of the official applications are available for Desktop systems like Ubuntu. Even you can access it in the web browser, but sometimes we need a desktop application that provides easy to use interface. In this tutorial, we will help you with installing Facebook Messenger on Ubuntu 21....

This tutorial will help you to install the latest Gimp on macOS using Homebrew. Step 1 – Prerequisites Before starting the installation of GIMP using this tutorial you must have the following prerequisites Terminal: You must have Mac Terminal access and little knowledge about working with the terminal application. Homebrew: Homebrew is a popular package management tools used for installing most open-source software like Node. Here is the Homebrew installation tutorial...

1. Prerequisites To install Nginx on Debian 9, you must have root or sudo privileged user access to your system. For the remote systems can use ssh command or putty for Windows user to login. 2. Install Nginx on Debian 9 The Nginx latest packages are available under default repositories for all Ubuntu’s versions, You can directly install them by running following commands After installation of Nginx service, run below command to check the status of Nginx service....

This article has been tested on CentOS Linux release 7.5 Step 1 – Configure Yum Repository Firstly you need to configure the PostgreSQL repository in your system. Use one of the below commands as per your operating system version. For more details visit PostgreSQL repositories link page where you can get repository package rpm for various operating systems. Step 2 – Installing PostgreSQL on CentOS 7 After enabling PostgreSQL yum repository in your system use following command to install PostgreSQL 11 on your system with yum package manager....

Skype Features The latest version of Skype have a number of of features, Useful for a small office as well as large corporate. Audio Calling (Free Skype to Skype) Video Calling Video conferencing File sharing Screen sharing Group screen sharing Calls to mobiles and landlines And many more features… Step 1 – Download Skype Debian Package First of all, download the Skype package for the Debian system from its official download page....

This article will help you to install and configure Webmin on CentOS, RHEL, and Fedora systems. Kindly go through the below steps. At the time of the last update of this article Webmin 1.941 is the latest available version to download and install. Prerequsities The following are the optional dependencies for the Webmin. You can install them using below command: Disable SELinux It is a good idea to disable the SELinux in your system....

Zabbix Agent is required on the systems, you need to monitor through the Zabbix server. This tutorial will help you to install Zabbix Agent on Ubuntu 20.04 LTS Linux system. Requirements You must have shell access with sudo privileged account access to your Ubuntu 20.04 LTS system. Step 1 – Configure Zabbix Repository The Zabbix team provides apt repositories for the installation of Zabbix packages. Then add the repository to your system, which is required packages for Zabbix agent....

It is important to set the correct timezone on your Linux system, as this ensures that the system clock is displaying the correct local time. If the timezone is not set correctly, the system clock may be off for several hours, which can cause issues with scheduling tasks, logs, and other applications. In this article, we will walk through the process of setting or changing the timezone in Linux. We will cover two methods: using the timedatectl command and directly modifying the /etc/localtime file....

Assessing Your Own Needs The first thing you need to do is make clear what you need in a host. This is mostly determined by the character of your website, and any special software you may need. Now, 26 percent of all internet is built on WordPress, which makes it into a quite popular choice. Furthermore, your particular line of work may require some special software that needs to be included and if it is vital to your business you should check it with the host....

This command comes under software-properties-common debian package. Which is not available under the minimal Ubuntu installation, but this package can be installed from default system repositories. If you found apt-add-repository command not found error on your system, Follow this article to add this command to your system. On Latest Ubuntu & Debian Version’s The latest version of Ubuntu 20.10, 20.04, 18.04, 16.04 and Debian 10/9/8, apt-add-repository command utility is available under the software-properties-common package....

This tutorial helps you to create a new user with Sudo privileges, allow sudo access to the existing accounts or remove sudo privileges from any account. Create User with Sudo Access The adduser is the default system command to create new users on your Fedora system. In Fedora systems, a default group is created with the name “wheel” having sudo privileges. So we can assign sudo privileges to any user by adding them to the wheel group....

This tutorial will described you to uses of date command on Linux system. Syntax: View Current Date The default date command displays the current date and time on standard output. This date/time will be in default system time zone. Open a terminal (CTRL + ALT + T) and type: The above command shows current time in EST timezone, which is the default timezone of my Linux system. date Command Examples If you like this post, please od share this with your social network....