IT Knowledgebase Articles

Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown, Microsoft SQL MVP, takes the readers through the “best” practices to follow.

Microsoft SQL MVP, Sean McCown, takes us through the pros and cons of using Windows authentication vs SQL and Windows Authentication when installing an SQL server 2008.

Important insight on managing large numbers of files in SQL from Microsoft SQL MVP, Sean McCown.

One of the most handy tricks in Windows Vista (and previous operating systems) is the My Computer shortcut. In this article, MVP Daniel Petri shows you how to quickly access any folder on your computer through a cool toolbar shortcut.

Windows 7’s Backup and Restore tool allows you to backup and restore individual files, groups of files, or all of the files that you have backed up. One possible use for it is when something goes terribly wrong with your operating system, causing you to have to either format and re-install, or use the System Image backup you created. In this article, MVP Daniel Petri will show you how to successfully restore your Windows 7 computer to working status.

By using the new Windows 7 Backup and Restore tool you can restore individual files, groups of files, or all of the files that you have backed up. Hopefully, one will never need it. But in case they do, in this article, MVP Daniel Petri explains the process.

When using the Backup and Restore tool in Windows 7, an important aspect of the backup job is the proper selection of backup target. In this article, MVP Daniel Petri continues the Windows 7 backup series with important information to help you choose where to save your backup.

In Windows Vista, the Backup Status and Configuration tool was the place where one could (at least try to) backup pictures, music, media and documents on their computer. However, as many users found, it just didn’t allow for some key configuration options. In Windows 7 this has changed, and it seems quite likely that we’ll finally get a good backup tool. In this article, MVP Daniel Petri takes you inside Windows 7 Backup & Restore .

One of the things that makes server virtualization so enticing is virtual machine portability. If a host server starts to become overloaded, or you need to upgrade to newer hardware, you can move virtual machines to another host server via the Import and Export function. In this article, Brien Posey explains the import/export process and how to avoid some common pitfalls of moving your virtual machines.

A comparative overview of BitLocker and Encrypting File System (EFS) in Windows 7 and how they can be leveraged to improve the security of your data.