Tips

Tips

• SQL language crash course (just enough to be dangerous)

  You can't get far in the SQL Server world if you don't speak the language. Check out the basics of SQL language with examples of common SQL Server queries.  Continue Reading

• Working with IntelliSense in SQL Server 2008 Management Studio

  IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can simplify coding in a big way.  Continue Reading

• Troubleshooting Distributed Transaction Coordinator errors in SQL Server

  Microsoft Distributed Transaction Coordinator enforces transactional consistency over multiple systems in SQL Server. Learn how to solve common errors and properly configure MSDTC.  Continue Reading

• Achieving high availability and disaster recovery with SharePoint databases

  Failover clustering and database mirroring are two useful SQL Server technologies that offer automatic failover within MOSS-related databases.  Continue Reading

• 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