Howtos / Articles

Microsoft SQL Server 2012 Express Limitations

Microsoft SQL Server 2012 Express Edition is a great database engine that is more than capable of handling most small business database requirements. There are however some limitations. The details below outline the main limitations in SQL 2012 Express Edition. CPU: 1 CPU (based on a socket) or 4 cores. The lesser of the two is used. Eg: If you have 1 CPU that contains 8 cores, it will only use 4 cores. or If you have a system with…

Read more [...]

Restore Microsoft SQL Database Using T-SQL

This guide will show you how to restore a Microsoft SQL database using T-SQL commands rather than using the wizards in SQL Management Studio. This has the added benefit of being able to be scripted if needed. Restoring a Microsoft SQL database: RESTORE DATABASE [database_name] FROM DISK=’c:\path\to\backup\file.bak’ Replace ‘database_name’ with the name of the database you want to restore to. Eg: RESTORE DATABASE [testing] FROM DISK=’C:\temp\testing.bak’ Sample output: Processed 312 pages for database ‘testing’, file ‘Testing’ on file 1. Processed…

Read more [...]

Backup Microsoft SQL Database Using T-SQL

This guide will show you how to backup a Microsoft SQL database using T-SQL commands rather than using the wizards in SQL Management Studio. This has the added benefit of being able to be scripted if needed. Backing up a Microsoft SQL database: BACKUP DATABASE [database_name] TO DISK=’c:\path\to\backup\file.bak’ Replace ‘database_name’ with the name of the database you want to backup. Eg: BACKUP DATABASE [testing] TO DISK=’C:\temp\testing.bak’ Sample output: Processed 312 pages for database ‘testing’, file ‘Testing’ on file 1. Processed…

Read more [...]

Check the reverse dns hostname for a IP on Linux

This guide will step you through how to take an IP address, and find out what its reverse dns host name is. This is useful for checking mail server DNS setup, etc. The DNS system works two ways. It is used to convert host names to IP addresses, but it can also convert IP addresses to host names. Two handy programs to perform DNS queries on Linux are ‘dig’ and ‘host’. If either of these aren’t installed on your system,…

Read more [...]

List all hard disks connected to a CentOS system

You often need to know what physical drives are attached to a system, how many drives are connected, or even what device names match up with which physical drive. There is a handy tool called ‘lshw’ which is used to extract detailed information on the hardware in the PC. Unfortunately this doesn’t come pre-installed on CentOS. The details below will go through installing lshw, and how to run it to list all the hard drives. Prerequisites This guide requires the…

Read more [...]