Deploy SQL Server Log Shipping as a Report Database Solution
Learn in which cases you can deploy SQL Server log shipping as a low-cost solution for production reporting.
Read MoreMost Popular
Deploy SQL Server Log Shipping as a Disaster Recovery Solution
Learn how to deploy SQL Server log shipping to a secondary server to protect your organization from a power grid failure or local disaster.
Read MoreDeploy SQL Server Log Shipping to Create a Warm Standby Server
Learn about deploying SQL Server log shipping to create a warm standby server.
Read MoreSQL Server Clustering Alternative Options
Learn about SQL Server active/active clustering, multi-node clustering and how to cluster multiple instances on the same server.
Read MoreHow SQL Server Clustering Works, Part 2
Learn about how SQL Server clustering works, including how a failover works.
Read MoreHow SQL Server Clustering Works, Part 1
Learn how SQL Server clustering works, including active and passive nodes, the shared disk array, the quorum, public and private networks, and the cluster server.
Read MoreAlternatives to Clustering for SQL Server
Review options for SQL Server high availability beyond clustering, from least expensive and easy-to-implement to more expensive and more difficult-to-implement options.
Read MoreWhat SQL Server Clustering Can and Cannot Do
Learn what SQL Server clustering can and cannot do in terms of high availability and performance.
Read MoreImproving SQL Server Query Performance with Indexes
Learn how to use SQL Server 2012 Dynamic Management Views (DMVs) to fine-tune SQL queries.
Read MoreCleaning Up SQL Server Indexes
Learn how to perform SQL Server Index cleanup tasks on a regular basis to prevent excessive fragmentation.
Read MoreMonitoring SQL Server Index Fragmentation
Learn how you can monitor SQL Server 2012 index fragmentation through the provided DMVs.
Read MoreWhy Use Both Partitioned Tables and Indexes?
Learn how to use SQL Server 2012 partitioned tables to spread a single table over multiple partitions.
Read More