Howtos / Articles

Microsoft SQL Server 2008 R2 Express Limitations

Microsoft SQL Server 2008 R2 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 2008 R2 Express Edition. CPU: 1 CPU (based on a socket). No limit on cores. Memory: Maximum of 1GB for the database engine. (Note: SQL 2008 R2 Express Edition with Advanced Services includes reporting features, and has a limit of 4GB for…

Read more [...]

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 [...]