Part IV: Configuring SQL Mail

We will finish off this series with showing you how to take advantage of the stored procedure xp_sendmail through T-SQL. Note: Select the link to read the entire blog series on SQL Mail. Configure xp_sendmail Now that you have configured SQL Mail, you can take advantage of the xp_sendmail stored procedure that allows you to [...]

Part II: The SQL Server Best Practices Analyzer

In my last post, we began to show you the The SQL Server Best Practices Analyzer. Let’s pick up where we left off. Now that you have installed the Best Practices Analyzer (BPA), you are ready to open it from the Start menu by choosing Start | Microsoft Best Practices Analyzer | SQL Best Practices [...]

The SQL Server Best Practices Analyzer

Do you not have a full-time DBA to keep Microsoft SQL Server databases running according to industry standards and best practices? Sometimes even DBAs want to test their SQL Servers against various best practices. In the past, you would have to tweak your SQL Server settings manually to find the ideal configuration. Now, Microsoft has [...]

Next Page »