The Helpdesk For I.T. Administrators
Windows will cache DNS resolution results for a period of time. You may need to clear this cache if you need to make sure the DNS value is up to date. The command below can be used to flush the DNS cache on a Windows machine. This can he useful if you are changing entries …
For some reason, the option to format a drive with the FAT32 filesystem was removed from the GUI format tool in Windows 7. Thankfully you can still do it from the command line format utility. This guide will step you through the process of formatting a drive using the FAT32 filesystem using the command line. …
Microsoft SQL Server 2008 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 Express Edition. (Note: This information is not for SQL Server 2008 R2. If you are after the …
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 …
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 …
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 …
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 …
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 …
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 …
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. Ubuntu comes with a handy tool called ‘lshw’ which is used to extract detailed information on the hardware in the PC. To view a listing of …