Showing 207 Result(s)

Find a column from all tables in a database on SQL Server

I recently have needed to find a column but could not remember what table it was in the database. You can run this query on your SQL Server to find a specific column in the whole database: SELECT COLUMN_NAME,  TABLE_NAME FROM  INFORMATION_SCHEMA.COLUMNS WHERE  COLUMN_NAME LIKE’ %ColumnName%’ You will need to replace the ColumnName(that is in …

Introduction to network scanning with NMap

NMap(stands for network mapper) is a small utility that has both a command line option called NMap and also a graphical option called Zenmap. It is a free and open source program that is licensed under the GNU GPL(more details on the GNU GPL license can be found in my introduction to Linux). Why do …

How to install Linux

As I went over in the introduction to Linux there are many different distros of Linux which means there is no one way to install Linux, in fact if you want to use Linux you do not even need to install it you can use what is called ” Linux Live”, people often use Linux …

Introduction to RDP – Remote Desktop Protocol

RDP or Remote Desktop Protocol is used to get a remote session into a Windows or Windows Server operating system. This unlike other tools like telnet gives you a graphical session to your remote computer, this means you can log in and get your normal Windows desktop environment. Microsoft have released official Remote Desktop applications …

Introduction to Linux terminal

What is the terminal? The terminal(which is also known as the shell) is basically a program that takes the commands that you type on your keyboard and and passes them through to the operating system to complete them. Back in the old days this was the only way to interact with computer, there was no …