OPENTech Guides
How-To Articles
- MOST RECENT
- MOST POPULAR
How to select random records from a databaseLearn how to select random rows from a database table in MySQL, Oracle and MS SQL Server. Also learn how to retrieve random documents from a MongoDB collection.
How to setup a FTP server on Windows 10FTP server enables the transfer of file between computers. This article describes how to install and configure a FTP server on a Windows 10 machine.
- Creating local user accounts in Windows 10
This article describes how to add a local user account in Windows 10 without a Microsoft account or email id. Local user accounts can be administrator account or standard account
Interacting with Jira using Python and REST APIDevelopers can create scripts/programs using Python and Jira REST API to access resources such as projects, issues, comments, users etc., from Jira Cloud and Server Platforms.
Restricting Management Access on Juniper SRXThis article describes how to restrict management access on Juniper SRX device to specific network addresses by setting up a firewall filter
Reading and Writing JSON data in PythonThis article demonstrates how to read data from a JSON string or file and similarly how to write data in JSON format using json module in Python.
- Using Dialects when reading and writing CSV in Python
A dialect is a group of parameters used to define the format of a CSV file.Here are examples of operations on dialects such as list, get attributes, register, unregister, sniff,
- Reading and Writing CSV files in Python
Python CSV module contains functions to read and write CSV data. Here are some examples of how to read from and write to CSV files in a Python program.
Using SQL statements to query information from OTRS databaseSQL Box allows administrators to run SQL statements to query OTRS database. Here are a few SQL statements to query information about tickets, queues, agents and customers.
Using .htaccess to restrict access to Files and DirectoriesRestrict access to files and directories using .htaccess. Disable directory browsing and prevent access to certain files or filetypes
- Changing user accounts in Windows 10
How to change user account names in Windows 10 using Advanced User Accounts (Netplwiz) and from control panel.
How to get the display settings right on Raspberry PiHow to get the TV/Monitor display resolution right on Raspberry pi running Raspbian
- Auto Login and Auto Start in Raspberry Pi
How to automatically login to Raspberry Pi, how to run a script at startup and how to automatically start the desktop in Raspberry Pi
- Change network type from Public to Private in Windows 10
How to change a network location from Public to Private or Private to Public in Windows 10 in a few easy steps
How to check Fibre Channel HBAs in LinuxStep by step guide on how to check FC HBAs are installed correctly to get the HBA card details like number of ports, WWN, type, status etc.
C program to count lines, words and characters in a fileThis is a C program to count the number of lines, words and characters in a file
How to install Whatsapp on your Wifi only Android TabletHow to install WhatsApp on WiFi only Tablets and how to use whatsapp web client to mirror your conversations on phone and pc.
- Using .htaccess to restrict access to Files and Directories
Restrict access to files and directories using .htaccess. Disable directory browsing and prevent access to certain files or filetypes
How to add a Favourite Icon to your websiteLearn how to add a favicon or shortcut icon to your website.
How to disable Telnet on Cisco Switches and RoutersTelnet lets you manage Cisco switches and routers remotely however it is not very secure. This article explains how to disable Telnet on Cisco devices
How to search within Java,C++,PHP and other projectsTools such as Notepad++, Windows Explorer and SeekFast enables users to search for text in text-based files without opening each result in a text editor.
Setup your online store in less than 30 minutesStep by Step guide to setting up your own online shop in less than 30 minutes using shopify. It is really quick and easy. No payments or credit cards required!!
- Publish your article here
TUTORIALS
Follow Us
