Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers.
Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU time etc, this really helps us to know the status of the server immediately.
In this podcast we are going to install SQL Server 2008 Clustering on Windows server 2008. I’ve already made my both the nodes clustered with Windows server 2008 and the details are below.
Below are the list of SQL Server 2008 editions supporting clustering.
Today Microsoft has released the final version of Service pack 1 for SQL Server 2008. You can download it from the link below. Some of the new features are included in SQL Server 2008 service pack 1.
In this article we are going to configure alerts for policy management. Alerts are triggered when a violation takes place in a particular policy that uses any of the three automated evaluation mode. Each of these evaluation mode will return an error number starting with 340*. You can use these alerts to notify either policy administrator or the database administrator who needs to make sure these values are under company standards. Upon receiving these alerts they can work with the user who has violated the policies or company standards. Error number for each of these evaluation mode is given in the below table.