Blog

Hyper-V in SCVMM 2008 “Needs Attention”

Last Update: Nov 19, 2024

System Center Virtual Machine Manager (SCVMM or VMM for short) 2008 is Microsoft’s management tool for Hyper-V and Virtual Server 2005. In this article by MVP Daniel Petri, learn how to resolve a persistent “Needs Attention” Hyper-V status with two quick downloads.

View Article

What is PowerPivot?

What is PowerPivot? PowerPivot (formerly known as Project Gemini) is our latest and hottest business intelligence innovation and intended to finally make BI accessible & easy to the masses using the #1 BI tool in the world: Microsoft Excel. PowerPivot actually consist of a client add-in for Excel 2010 called PowerPivot for Excel and a…

View Article

What is Application and Multi-server Management in SQL Server 2008 R2?

What is Application and Multi-server Management? Microsoft’s investments in Application and Multi-server Management will help organizations manage database environments more efficiently at scale with visibility into resource utilization for consolidation and improved efficiencies across the application lifecycle. These improvements will offer DBAs increased visibility and control, resource optimization, and efficiencies, ultimately leading to a healthier,…

View Article

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
Go to page