Blog

What is StreamInsight?

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…

View Article

SQL Server Recovery Models

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.

View Article

Windows 7 Upgrade Paths

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

View Article

Troubleshoot a Slow Database in SQL Server 2008

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.

View Article

How to Design a Backup Strategy in SQL Server

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.

View Article

How to Choose a SQL Server Authentication Mode

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.

View Article

How to Manage SQL Server Database Files

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

View Article

Quickly Access your Folders in Vista

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.

View Article

Working with System Image Backups in Windows 7

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.

View Article

Restoring Files with Backup and Restore in Windows 7

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.

View Article

Choosing the Best Storage Desination for your Windows 7 Backup

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.

View Article

Windows 7 Backup & Restore – What it should have been in Vista!

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 .

View Article
Go to page