Category: DBA
-
Installing SQL Server Reporting Services 2008
In this webcast we are going to install SQL Server reporting services 2008. Watch the video and post your feed back incomments.
-
Activity Monitor
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…
-
Creating Linked server to MYSQL from SQL Server
In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to MYSQL database server from SQL Server environment and then going to query datas from MYSQL. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…
-
Configuring Alerts to Notify Policy deviations in Policy Based Management
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…
-
How to work with Policy Based Management (PBM)
In my previous article on policy based management Ive gone through what is policy based management and how it helps administration. Lets discuss about how to work with policy based management i.e. how to create a policy and implement it. To work with a policy we need to first create a condition and we need…