Tips

Tips

• Clearing the Windows page file and its effect on server performance

  Before enabling the Windows page file setting, consider your server size, hard drive speed and the security of your Windows environment.  Continue Reading

• Deploying a SQL Server virtual appliance for Microsoft Hyper-V

  Deploying a virtual appliance is simple, and can come in handy when you need to install updates to Microsoft SQL Server.  Continue Reading

• Recommended practices for SQL Server Analysis Services aggregations

  Aggregations produce faster queries, but they also increase the size of your Analysis Services database. See how to make the most of aggregations and what tools to experiment with.  Continue Reading

• Optimizing SQL Server indexes -- even when they're not your indexes

  When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.  Continue Reading

• How to create SQL Server virtual appliances for Hyper-V

  Creating a private SQL Server VAP will reduce the time it takes to deploy additional SQL Server machines in your environment.  Continue Reading

• Push vs. pull: Configuring SQL Server replication

  Learn the difference between push and pull subscriptions and how to determine the best placement for SQL Server replication's Distribution Agent.  Continue Reading

• Creating and managing SQL Server Analysis Services partitions

  Learn everything you need to know to build SSAS partitions from the ground up, with advice on binding, merging, and selecting partition data.  Continue Reading

• How to 'do' SQL Server disaster recovery

  Understanding how backups really work in SQL Server can save you a lot of time and trouble. Learn where most SQL Server newbies get lost during the backup and recovery process.  Continue Reading

• Protect virtual databases through SQL Server database mirroring

  Learn how database mirroring provides cost-effective protection for critical databases running on virtual machines.  Continue Reading

• Setting up SQL Server Service Broker for secure communication

  Securely sending Service Broker messages from instance to instance requires a somewhat complex configuration. This tip walks you through the proper methods.  Continue Reading

• Top tips and tricks for SQL Server database development

  Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.  Continue Reading

• A first look at Microsoft SQL Server 2008 R2

  Get details on the new features and improvements that are expected to be apart of Microsoft's upcoming SQL Server release, set to launch in early 2010.  Continue Reading

• Top load balancing methods for SQL Server

  There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.  Continue Reading

• Performance implications of transaction log autogrowth in SQL Server

  Take a closer look at the performance implications of shrinking transaction log files in SQL Server.  Continue Reading

• The keys to database backup protection for SQL Server

  There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.  Continue Reading