IT Knowledgebase Articles

Learn how to do a clean installation of Microsoft Office along with SP1/SP2 updates at the same time with this step-by-step article on slipstreaming Office 2007 by MVP Daniel Petri.

Brand new from the team at Train Signal and certified instructor Mel Haynes (MS) is SQL Server 2008 Administration Training. Whether you’re a beginner or an experienced administrator, this 10 hour video training course comes packed with everything you need to pass the Microsoft SQL Server 2008 Implementation and Maintenance Exam (70-432).

Download this document in full:  What is SQL Server® 2008 R2 Parallel Data Warehouse? SQL Server® 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance that delivers performance at low cost through a massively parallel processing (MPP).  SQL Server® 2008 R2 Parallel Data Warehouse is the integration of DATAllegro’s MPP Data Warehouse…

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.

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…

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,…

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…

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.

Microsoft SQL MVP Sean McCown outlines the steps to follow in order to uncover the queries causing SQL database slowness.