Proactive information - SQL Server Best Practices / SQL Server Tips

These tips come from our GPSD - Global Partner Support Delivery, Denmark as a service to all Gold Partners. If you are a Gold Partner and didn't receive this information yesterday, contact GPSD to get it in the future.

A subset of the resources and information is here for all of you to enjoy and benefit from.

SQL Server Best Practices https://technet.microsoft.com/en-us/sqlserver/bb671430.aspx
Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation
to the next level. These SQL Server best practices draw on the extensive experience and expertise from
respected developers and engineers at Microsoft, who walk you through the specifics on solving particularly
difficult issues.

SQL Server Tips

Monitor SQL Server Performance and Activity with Built-In Functions
SQL Server includes a number of built-in functions you can use to retrieve system information. Here's an overview of
these functions.

Configure a Fail-Safe Operator for Notifications
When things go wrong with notification, operators do not get notified and problems might not be corrected
in a timely manner. Learn how you can prevent this with a fail-safe operator.

Configure Parallel Processing in SQL Server 2008
Understand when SQL Server uses parallel processing and learn how to configure parallel processing for your database.

Configure SQL Server 2008 to Automatically Manage File Size
Learn how you can easily configure SQL Server 2008 to automatically manage database and log size.

Manage SQL Server Services from the Command Line
You can manage SQL Server from a command line just as you would any other service. Here are the commands
you need to know.

Enjoy! :-)

Martin Houlberg Jensen
CRM Evangelist
Microsoft Dynamics CRM team