March 2007

SQL Server:New Tools to Diagnose Index Health

To get the best performance out of SQL Server, you need to oversee and maintain healthy indexes. New dynamic management views and functions give you a window into SQL Server to help you better understand how your indexes are functioning and discover potential performance issues. Randy Dyess

SQL Server:Achieve High Availability for SQL Server

SQL Server 2005 offers a number of options to improve database availability, from replication to clustering to log shipping. We’ll take a closer look at the various options for configuring SQL Server and help you find out which ones are right for your environment. Zach Nichter

SQL Server:Simplify Database Maintenance with Table Partitions

In the past, working with partitions and very large tables was a burdensome and tedious task, but with SQL Server 2005, table partitioning has gotten much simpler. Now you can easily create multiple partitions, move those partitions around, drop old partitions, and even change the way data is partitioned. Here’s how. Noah Gomez

SQL Server:Top Tips for SQL Server Clustering

A server cluster provides failover capabilities, ensuring more uptime for your critical operations. But for a cluster to be effective, it must be implemented properly. Here are some key tips that will help you get your cluster up faster and keep it functioning reliably. Tom Moreau, PhD

Windows Administration:Inside the Windows Vista Kernel: Part 2

This month we continue our in-depth discussion about what’s new in the Windows Vista kernel. In this issue, we review some advancements in how Windows Vista manages memory and explore the areas of system startup, shutdown, and power management. Mark Russinovich

https://technet.microsoft.com/en-us/library/bb978519(v=msdn.10)
https://technet.microsoft.com/en-us/library/cc135917(v=msdn.10)

Columns