SQL Server 2008 R2 Best Practices Analyzer


The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions: Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server Determines if the configurations are set according to the recommended best practices Reports on all configurations, indicating settings that differContinue reading “SQL Server 2008 R2 Best Practices Analyzer”

Microsoft SQL Server 2008 Upgrade Advisor


Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008. Overview Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 in preparation for upgrading to SQL Server 2008.Continue reading “Microsoft SQL Server 2008 Upgrade Advisor”

SAN Storage Best Practices for SQL Server


Source: How to Connect SQL Servers to the SAN How to Connect SQL Servers to the SAN The term SAN gets misused a lot because it really means Storage Area Network – the communication pipelines between your server and a magic black box called a SAN controller.  That controller is the configurable hardware that managesContinue reading “SAN Storage Best Practices for SQL Server”

How to create Read-Only Database User in SQL Server 2008?


How do you give permission to a database in SQL server to a QA or someone who wants to have read only access? In SQL server 2008, if you want to give read only access to the database for a person, do the following steps 1. Create a new login which is going to haveContinue reading “How to create Read-Only Database User in SQL Server 2008?”