
What does StreamInsight mean for customers? While OLTP databases have matured and are capable of processing thousands of transactions per second; they are not optimized for processing continuous high volume, low latency streams of data. Microsoft’s innovative StreamInsight™ platform allows customers to use their own proprietary algorithms to build custom real-time applications, ISVs to build…

Last Update: Dec 03, 2024
In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves so you can have what you need to perform your desired backups.

A summary of the possible upgrade paths from previous versions to the Windows 7 operating system.

Last Update: Dec 03, 2024
Microsoft SQL MVP Sean McCown outlines the steps to follow in order to uncover the queries causing SQL database slowness.

Last Update: May 21, 2025
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.

Last Update: Sep 04, 2024
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.

Last Update: Dec 03, 2024
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.

Last Update: Sep 04, 2024
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.

Last Update: Sep 04, 2024
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.

Last Update: Sep 04, 2024
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 .