Microsoft SQL Server Performance Monitoring and Tuning

  • Recover lost SQL Server data

    Data recovery success in SQL Server depends on your failover method in place. Failover options range from a simple backup and restore process to the highly sophisticated clustering model. Edgewood Solutions' Greg Robidoux outlines the available ...  Continue Reading

  • Database access for SQL Server business and reporting users

    SQL Server business users and reporting users have a common goal: a successful business. Their roles, however, are different as they compete to capture data. To successfully report against transactional databases know your hardware resources, CPU ...  Continue Reading

  • Ownership chaining in SQL Server 2005

    Ownership chains have unique permissions' issues in SQL Server 2005. Understanding their dynamic is important when using one type of object to access another in an environment where different access levels are granted. Contributor Serdar Yegulalp ...  Continue Reading

  • Stored procedures vs. dynamic SQL: When should you use each?

    Stored procedures and dynamic SQL each have their place in the SQL Server world. You must consider parameters, tables being queried, the number of databases and so forth. In this tip, Serdar Yegulalp maps out the best scenarios for each.  Continue Reading

  • SQL Server indexes made handy

    Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application. In this tip learn how to validate and build indexes for best performance.  Continue Reading

  • Alerting capabilities in SQL Server 2005

    Alerts in SQL Server 2005 have surpassed the functionality of those in SQL Server 2000. It seems the latter version is meeting industry needs for an SMTP based email system with the introduction of Database Mail. In this tip Edgewood Solutions' ...  Continue Reading