I often get asked, if there is an easy way to get notifications for Patches and Hotfixes for SQL Server. Generally I recommend people keep
Category: Best Practices
How to calculate Max Memory for SQL Server?
How do you calculate max memory setting for SQL Server; in affect how much memory to leave to OS, threads, etc.
Granting Execute Permissions
Following code can be used to Grant Execute Permissions to a Database Role, in a database. This is for SQL Server 2000; because in 2000