Best Practices

Tools and Information to Make Your Job Easier

Applying best practices can greatly streamline and simplify systems management and upgrades. As long-time technology partners, Dell and Microsoft have accumulated massive amounts of learning that we put at your fingertips so you can avoid unexpected downtime and costs.

Keeping an Eye on Things

Deploy, monitor and update your entire database stack, from server to operating system, database to applications, with a single set of systems management tools from Dell.

Dell™ OpenManage™ Integration Suite for Microsoft® System Center provides IT administrators with a portfolio of free-of-charge software tools designed to simplify and automate essential IT tasks, including server provisioning and updates of BIOS drivers and firmware.

Seamless integration of OpenManage functionality in System Center delivers:

  • Faster deployments, less time required for testing and no additional infrastructure requirements
  • Fewer management consoles to monitor
  • Optimized control of your IT environment — hardware, software and IT services

Learn more about Dell and Microsoft Systems Management Solutions.

  1. Consolidating Dell PowerEdge 6650 Servers on a Dell PowerEdge R905

    Save hardware, software and operational costs by consolidating multiple SQL Server 2000 and SQL Server 2005 databases on Dell PowerEdge 6650 servers to a single 2008 Dell PowerEdge R905 server with Dell PowerVault MD1000 storage array.

  2. Consolidating SQL Server 2000 and Databases to SQL Server 2008

    Ensure you receive cost savings by educating your system administrators and database administrators on effectively consolidating Microsoft SQL Server 2000 and 2005 databases to a single SQL Server 2008 server system.

  3. Consolidating SQL Server 2008 to PowerEdge R900 and R905 Using Hyper-V

    Configure your Dell PowerEdge R900 or R905 server and consolidate your Microsoft SQL Server 2008 database from multiple machines to a single Windows Server 2008 system using Microsoft Hyper-V.

  4. E-guide: Best Practices to Maximize SQL Server Performance

    20 Apr 2012

    Learn about best practices for maximizing the memory, disk storage, processor and network adapter capacity of your existing servers, as well as tips on how to effectively scale out a Microsoft SQL Server environment across multiple systems.

  5. Achieve a High-Performance OLTP Database With SQL and PowerEdge R720

    10 Mar 2012

    Optimize your data center efficiency and achieve a high-performance OLTP database using Microsoft SQL Server and a Dell PowerEdge R720 server with onboard PCIe SSD storage.

  6. SQL Server 2008 R2 Licensing Quick Reference Guide

    01 May 2010

    Understand the basics of how Microsoft SQL Server 2008 R2 is licensed and sold in both physical and virtual environments.

  7. Business Continuity for MS SQL Server and VMware on Dell Servers

    25 Jan 2010

    Minimize planned or unplanned downtime of your Microsoft SQL Server database by exploring the solutions that are available with the implementation of VMware HA and VMware FT in your virtual environment.

  8. Consolidate and Virtualize SQL Server on Dell Servers and Storage

    01 Jul 2009

    Obtain guidance and recommendations to help you design a consolidation and virtualization strategy for deploying Microsoft SQL Server software on the latest Dell PowerEdge servers and Dell EqualLogic Internet SCSI (iSCSI) storage arrays.

  9. Consolidating SQL Server 2008 to Dell R900 and R905 Using MS Hyper-V

    28 Jan 2009

    Reduce costs and save time by learning how to effectively consolidate your Microsoft SQL Server 2008 databases using Microsoft Hyper-V on the Dell PowerEdge R900 or PowerEdge R905 server.

  10. Migrating SQL Server 2000 to SQL Server 2008

    25 Apr 2008

    Microsoft SQL Server 2008 offers scalability and efficiency on a trusted, reliable database platform. Use it to manage enterprise data in ways that make best use of your time and IT resources.

Talk to Dell About SQL Server Solutions
SQL Server online advisor