Category: Articles
-
Systray Utility to check SQL Server Service
I have developed this utility to monitor the instances of SQL Server running in a machine (i.e only standalone and not remote machines) and to send failure mail alerts upon service status. When I tried this type of systray utility in internet I could find only utilities that are monitoring the service and not sending…
-
Creating user defined System Objects in SQL Server
You can create an object in SQL Server and convert it to a system object just by marking the object as given below. By doing so you will be able to call the procedure from any db context
-
Installing SQL Server 2008 Clustering on Windows Server 2008
In this webcast we are going to install SQL Server 2008 Clustering on Windows server 2008. Ive already made my both the nodes clustered with Windows server 2008 and the details are below.
-
Configuring Failover Clustering in Windows Server 2008
I have planned to configure SQL Server 2008 clustering on Windows Server 2008 Clustering. To do this, first I need to configure Windows Server Clustering. Now a days DBA’s are not only working on RBMS platform, they should also have sufficient knowledge in their operating system on which their RDBMS is running. As a DBA…
-
Installing MSDTC as Cluster Aware Service
This is my first webcast for sql-articles.com. In this article we are going to discuss on Installing MSDTC as cluster aware service on Windows server 2008. We need this service as cluster aware because this is the pre-requisites when configuring SQL Server 2008.